Job Summary:We are seeking an experienced ETL Developer with strong expertise in Informatica PowerCenter and IICS. The ideal candidate will design, develop, and maintain ETL processes, ensuring high-quality data integration, performance optimization, and alignment with business requirements.
Key Responsibilities:- Design, develop, and maintain ETL workflows using Informatica PowerCenter and IICS.
- Collaborate with business analysts and data architects to translate business requirements into technical specifications.
- Conduct data analysis, data modeling, and dimensional modeling to support ETL design.
- Ensure data quality and integrity through validation, cleansing, and testing processes.
- Optimize ETL processes for performance, efficiency, and minimal downtime.
- Troubleshoot issues in ETL workflows and provide post-production support.
- Maintain comprehensive documentation for ETL processes, mappings, and workflows.
- Collaborate with cross-functional teams and offshore resources to define data requirements and contribute to database design decisions.
Required Skills & Experience:- 7+ years of hands-on experience with Informatica PowerCenter and IICS.
- Strong expertise in ETL process design, development, and maintenance.
- Experience in data modeling, dimensional modeling, and data analysis.
- Knowledge of performance tuning, data validation, and troubleshooting ETL processes.
- Familiarity with working in hybrid or offshore-collaborative environments.
Preferred Skills:- Strong documentation and communication skills.
- Experience with large-scale data integration projects and best practices in ETL.
Skills Keywords: ETL, Informatica PowerCenter, IICS, Data Modeling, Data Integration, Data Quality