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 robust 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.
Positive 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