IICS Developer

Job description

Key Responsibilities Design, develop, and maintain data integration workflows using Informatica Intelligent Cloud Services (IICS). Build and optimize ETL/ELT pipelines for ingesting, transforming, and loading data from multiple source systems. Develop complex SQL queries, stored procedures, and performance-tuned database solutions. Implement data cleansing, transformation, and validation processes to ensure high data quality. Collaborate with business analysts, data engineers, and stakeholders to understand data requirements and deliver scalable solutions. Troubleshoot and resolve data pipeline failures, data quality issues, and performance bottlenecks. Participate in code reviews, deployment activities, and production support. Create and maintain technical design documents, mapping specifications, and operational runbooks. Ensure adherence to data governance, security, and best practices. Must-Have Skills 4+ years of experience in Data Engineering, ETL Development, or Data Integration. Strong hands-on experience with Informatica Intelligent Cloud Services (IICS): Cloud Data Integration (CDI) Taskflows Parameterization REST/API integrations Error handling and monitoring Strong expertise in SQL with hands-on experience in: Complex joins and subqueries Stored procedures/functions Query optimization and performance tuning Data modeling fundamentals Experience working with relational databases such as SQL Server, Oracle, PostgreSQL, or similar. Understanding of ETL concepts, data warehousing, and dimensional modeling. Experience with source control tools such as Git. Good-to-Have Skills Experience with Snowflake data warehouse: Snowflake SQL Data loading and transformation Performance optimization Streams, Tasks, and Snowpipe Exposure to cloud platforms such as AWS, Azure, or GCP. Knowledge of Python or Shell scripting for automation. Experience with Data Quality and Data Governance frameworks. Familiarity with Agile/Scrum delivery methodologies.