*Title: ETL Informatica Lead* *Location: Phoenix, AZ* *Job Type: **Full Time Direct Hire* *Hours: 40 Hours a week*
*Role:* You will be a critical member of the BI development team. This position requires a sound knowledge of and Data warehouse database platforms like ETL, SQL, / PSQL, *Responsibilities* - Responsible for design and development of Mappings, mapplets, sessions workflows and schedule them. - Responsible for handling SCD’s in project. - Responsible for database design process, logical design, physical design, star schema, snowflake schema etc. - Design connections objects and be well versed with session and workflow properties. - 5-8 years of progressive experience with Data Warehouse and Informatica - Good programming skills - quick and self-learner and has good experience in Informatica, ETL - Project Lead - Architecture and Design - Mentor team members on coding & conduct Code Reviews - Resolving technical issues - Project documentation, Adheres to Quality guidelines& Schedules - Works hand in hand with PM for successful delivery of project and provide Estimation, scoping, scheduling assistance - Lead and guide development of an Informatica based ETL architecture, handle Complex ETL architecture definition and design and development - Develop solution in highly demanding environment, with high performance and availability and provide hands on guidance to other team members - Collaborate with product development teams and senior designers to develop architectural requirements to ensure client satisfaction with Solution. - Assess requirements for completeness and accuracy and decide if they are actionable for the ETL team, - Conduct impact assessment and determine size of effort based on requirements. - Develop full SDLC project plans to implement ETL solution and resource identification. - Perform as active, leading role in shaping and enhancing overall ETL Informatica architecture. Identify, recommend and implement ETL process and architecture - improvements. - Assist and verify design of solution and production of all design phase deliverables. Identify bugs when developers are not able to do so. - Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture.Resolve difficult design and develop issues. *Preferred Background* - Candidate should have experience in at least 2 full life cycle implementation and support of DW Solutions using Informatica - Power Center. - Excellent expertise in SQL, PLSQL (expert level knowledge in one Database) - Expertise in Performance tuning of Informatica Jobs and Error Handling - Bachelor's degree in computer science or computer engineering or equivalent degree required Thanks, CHETAN CYNET SYSTEMS Inc *[email protected] <[email protected]>* Ph:571.207.8017 | Fx:866.838.0907 | WWW.CYNETSYSTEMS.COM <http://www.cynetsystems.com/> IT & ENGINEERING CONSULTING -- You received this message because you are subscribed to the Google Groups "Visa Transfer OPT, CPT, PT, H1,H4" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/paul_talluri/CAEmTzCcRvPNve0Z5djuA5RU4wDhw3cKq%3Dd9tQL7kWjQv0swvSw%40mail.gmail.com.
