We are looking for an experienced ETL/Data Engineer with strong hands-on expertise in Informatica IICS and IBM DataStage. The ideal candidate should have strong SQL and data integration skills, with experience in developing, optimizing, and troubleshooting data pipelines.
Key Responsibilities
- Design, develop, and maintain ETL/ELT workflows using Informatica IICS and DataStage.
- Develop and manage scalable data integration pipelines across multiple source and target systems.
- Write and optimize complex SQL queries for data extraction, transformation, and validation.
- Work with relational databases and understand database concepts including joins, indexing, stored procedures, and performance optimization.
- Monitor and troubleshoot ETL jobs, data pipelines, and integration processes.
- Identify and resolve data quality, job failures, and performance-related issues.
- Optimize ETL workflows and pipelines for improved performance and reliability.
- Collaborate with business and technical teams to understand data requirements and deliver effective integration solutions.
Required Skills
- Strong hands-on experience with Informatica IICS.
- Strong hands-on experience with IBM DataStage.
- Good understanding of ETL/ELT and data integration concepts.
- Strong SQL and database knowledge.
- Experience in developing and optimizing data pipelines.
- Positive troubleshooting and performance-tuning skills.
- Strong analytical and problem-solving abilities.
Must-Have Skills: IICS | DataStage | SQL | ETL/ELT | Data Integration | Data Pipelines