Job Description :
Job Title: ETL/Informatica Lead
Job Location: RTP, NC 27709
Job Duration: 6+ Months Contract

Job Description:
Required Skills:
Must have minimum of 10 years of overall IT experience with at least 6 years of Informatica experience.
Must have minimum of 3 years Team Lead/Supervisory experience.
Must have experience with Integration technologies including Middleware and API Gateway.
Must have experience with Informatica toolsets: PowerCenter, Data Quality Management, Informatica MDM, Informatica Cloud, Business Glossary, Metadata Manager etc.
Certification on any Informatica tools is an added plus.
Must have experience managing technical teams across different integration areas like ETL, Middleware, API’s etc.
Must have experience in SDLC and Change Management.
Deep understanding of end-to-end Data Warehouse, performance tuning and optimization.
Expert level knowledge of SQL, PL/SQL on Oracle 11 or later version of database.
Experience with any Scheduling tools like Autosys, Active Batch etc.
Hands on experience on AWS technologies.
Any experience with Salesforce applications is a plus
Data modelling experience is a plus.
Good analytical and problem solving skills.
Strong communication skills and able to work independently as well as with the team.

Job Responsibilities:
Review and understand business requirements and functional specifications.
Act as Interface/Integration Lead and be able to define Interface definitions.
Coordinating with the Support teams, project teams, DBA, infrastructure team and project vendor to implement ETL tasks.
Oversee the creation of technical design documents that meet the business/functional requirements or to address the production issues.
Consolidate inputs from project teams and collectively provide inputs to testing strategy, configuration, deployment etc.
Meet regularly with project technical leads and solution architects to review designs, recommend solutions and participate in code reviews for applicable systems for all activities related to upgrades, patches, releases, production schedules, disaster recovery plans.
Responsible for troubleshooting and resolving issues acting as expert level support.
Perform Unit testing and co-ordinate with the testing teams to migrate the higher environments.
Day to day co-ordination with the Offshore & Onsite teams.
Responsible for the deployments/migration activities.