The company is seeking a Sr. Tech Lead with Informatica Development expertise to design, develop, and implement robust ETL solutions, optimize ETL performance, and troubleshoot issues in existing ETL processes.
Requirements
- 10+ years of experience in Informatica ETL development.
- Expertise in Informatica PowerCenter, IICS, and Data Quality (IDQ).
- Strong SQL and PL/SQL skills; ability to work with large data sets and optimize queries.
- Proficient in relational database technologies like Oracle, SQL Server, and/or Snowflake.
- Experience in data warehousing and data lake environments.
- Knowledge of cloud data integration (AWS, Azure, or GCP) is a strong plus.
- Experience with CI/CD, version control tools (e.g., Git), and DevOps practices.
Responsibilities
- Design, develop, and implement robust ETL solutions using Informatica PowerCenter or Informatica Intelligent Cloud Services (IICS).
- Analyze business requirements and translate them into technical specifications.
- Develop complex data mappings, transformations, and workflows to support business reporting and analytics.
- Optimize ETL performance through tuning and best practices.
- Work with various source and target systems such as Oracle, SQL Server, flat files, cloud platforms (AWS, Azure), etc.
- Implement data quality and data governance frameworks as needed.
- Troubleshoot and resolve issues in existing ETL processes.
Other
- Provide mentorship and technical guidance to junior developers.
- Collaborate with data architects, business analysts, and QA teams to deliver high-quality solutions.
- Understanding of Agile/Scrum methodologies.
- Strong analytical and problem-solving skills.
- Excellent verbal and written communication skills.
