Informatica IICS Developer
Position Overview:
We are seeking an experienced Informatica Intelligent Cloud Services (IICS) Developer to design, develop, and support cloud-based data integration solutions. This role involves building reliable data pipelines, improving data quality, and working with modern data warehousing technologies. The ideal candidate will have strong hands-on IICS development experience, excellent SQL skills, and a good understanding of enterprise data integration and data management practices.
Key Responsibilities:
Develop, configure, and maintain ETL/ELT pipelines using Informatica IICS.Build mappings, transformations, taskflows, and automated data integration processes.
Work with cloud data platforms, including Snowflake, to support data ingestion and transformation.
Support structured data processing across raw, refined, and business-ready data layers.
Implement data validation, quality checks, reconciliation, and error-handling processes.
Integrate data from multiple sources, including SFTP, Azure Blob Storage, databases, and cloud platforms.
Develop and maintain SQL queries, database objects, and data transformation logic.
Monitor scheduled jobs, investigate failures, and optimize pipeline performance.
Support data governance initiatives through metadata documentation, data lineage, and catalog integration.
Prepare technical specifications, mapping documents, test cases, and deployment documentation.
Perform unit, integration, regression, and end-to-end testing.
Work closely with data engineers, analysts, and business stakeholders in an Agile environment.
Assist with production releases, issue resolution, and knowledge transfer.
Required Skills:
Strong hands-on experience with Informatica Intelligent Cloud Services (IICS).Experience developing ETL/ELT processes, mappings, transformations, and taskflows.
Strong SQL and relational database knowledge.
Understanding of data warehousing, data modeling, and data integration concepts.
Experience with data quality, profiling, validation, and reconciliation.
Ability to troubleshoot complex data integration and production issues.
Experience preparing technical documentation and supporting deployments.
Preferred Skills:
Snowflake development and integration.
Medallion Architecture (Bronze, Silver, Gold).Azure Blob Storage and SFTP integrations.
Informatica data quality and metadata management tools.
Data governance, cataloging, and lineage tracking.
Experience working in Agile/Scrum environments.
Key Deliverables:
Developed and tested ETL/ELT pipelines.
Data integration and validation test results.
Technical documentation and production release materials.