ETL Informatica Tech Lead

1.About the Job - The candidate should require mandatory ETL Informatica Experience

2. Job Title - ETL Informatica Lead

3. Location - Gurugram

4. Educational Background - UG. B. Tech /B. E in any specialization & PG. MCA/MSC in Computers

5. Key Responsibilities -

• Lead the ETL development team in ETL development on AWS Cloud solution (IICS & IDMC) for SunSurf module, and other ETL relevant workflows.
• Conduct the solution design and architecture review, and ensure technical design meets business requirements.
• Work with BSAs on the requirement review, discussion and clarification.
• Conduct unit testing, work in continuous integration environments, and ensure code quality.
• Mentor and guide team members, promoting knowledge sharing and growth.
• Stay updated with emerging technologies and recommend innovative solutions.
• Coach developers and review technical deliverables.
• Prepare technical related materials and development Standard, support SIT, UAT, etc.
• Lead developers to deliver system to meet business requirements.
• Review developers key deliverables.
• Transform SSIS ETL package / into Informatica ETL package.
• Develop exception handing and error control logic in ETL logic.
• Tuning performance of slow / ineffective ETL process, SQL execution.
• Develop & plan unit testing case according to the business requirement / logic developed.
• Produce documentation - unit testing case, testing results, enhance development standard.
• Work with teammates with different regions (HK, PH, India).
• Pro-active team player in deliver best quality and work effectively, and knowledge sharing.
• Committed to project schedule for assigned work.

6. Skills Required

• Lead the ETL development team in ETL development on AWS Cloud solution (IICS & IDMC) for SunSurf module, and other ETL relevant workflows.
• Tuning performance of slow / ineffective ETL process, SQL execution.
• Transform SSIS ETL package / into Informatica ETL package.