DL
Informatica (IICS/IDMC)
Diverse Lynx India
🇺🇸 United States
On-site
5 months ago
- ETL
- Informatica
- SQL
- Unix
- Linux
- Data Modeling
- Agile
5 months ago
Job Title: ETL Developer – Informatica (IICS / IDMC / PowerCenter)
Location: Pune, IndiaWork Mode: Hybrid
Shift Timing: 9:00 AM – 6:00 PM
Job Summary
We are looking for a skilled ETL Developer with strong hands-on experience in Informatica (IICS / IDMC and/or PowerCenter) to design, develop, and support data integration solutions. The ideal candidate should have strong SQL and Unix scripting skills, along with a solid understanding of data warehousing concepts and the full software development lifecycle.Key Responsibilities
- Design, develop, and maintain ETL workflows usingInformatica IICS / IDMC / PowerCenter
- Build and optimize data pipelines for large-scale data integration and warehousing solutions
- Write efficient and optimizedSQL queries for data extraction, transformation, and validation
- Develop and maintainUnix/Linux scripts for automation and job scheduling support
- Perform data analysis, mapping, transformation, and data quality checks
- Support end-to-endSDLC activities including analysis, design, development, testing, deployment, and production support
- Troubleshoot and resolve ETL job failures and data-related issues
- Collaborate with business analysts, developers, and stakeholders to deliver solutions
- Ensure performance tuning and optimization of ETL processes
- Maintain documentation for ETL processes, mappings, and workflows
Mandatory Skills
- Hands-on experience inInformatica ETL (IICS / IDMC / PowerCenter)
- Strong proficiency inSQL
- Experience withUnix/Linux scripting
- Good understanding ofdata warehousing concepts and ETL processes
- Experience inapplication development and production support lifecycle
Desired Skills (Good to Have)
- Knowledge ofdata modeling and database design
- Experience withreporting tools and BI integration
- Exposure to performance tuning of ETL workflows
- Familiarity with agile development methodologies
Informatica (IICS/IDMC) · Diverse Lynx India