Looking for ETL Informatica Lead in Phoenix, AZ

[Chetan Singh]

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
CHET...@CYNETSYSTEMS.COM

Ph:571.207.8017 | Fx:866.838.0907 | WWW.CYNETSYSTEMS.COM
IT & ENGINEERING CONSULTING