Informatica IICS Developer

Apexon; United States; In loco; USD 90.000 - 130.000; Tempo pieno

Descrizione del lavoro

Apexon is seeking an experienced Informatica Intelligent Cloud Services (IICS) Developer to design, develop, and support cloud-based data integration solutions. The role focuses on building reliable data pipelines, improving data quality, and leveraging modern data warehousing technologies.

The ideal candidate has hands-on IICS development experience, strong SQL skills, and solid understanding of enterprise data integration and management practices, in an Agile environment.

Competenze

• Hands-on experience with Informatica IICS for ETL/ELT pipelines.
• Experience building mappings, transformations, and taskflows.
• Strong SQL and relational database knowledge required.
• Solid understanding of data warehousing, modeling, and data integration.
• Experience with data quality, profiling, validation, and reconciliation.
• Ability to troubleshoot complex data integration and production issues.
• Experience creating technical docs and supporting deployments.

Mansioni

• Develop, configure, and maintain ETL/ELT pipelines using IICS.
• Build mappings, transformations, and taskflows.
• Work with Snowflake and cloud data platforms for ingestion and transformation.
• Support data processing across raw, refined, and business-ready layers.
• Implement data validation, quality checks, and reconciliation.
• Integrate data from multiple sources including SFTP, Azure Blob Storage, and databases.
• Develop and maintain SQL queries and data transformations.
• Monitor jobs, troubleshoot failures, and optimize pipelines.
• Contribute to metadata documentation, data lineage, and catalog integration.
• Prepare specs, mapping docs, test cases, and deployment docs.
• Participate in Agile ceremonies and collaborate with data engineers and analysts.
• Assist with production releases and knowledge transfer.

Conoscenze

Informatica IICS

ETL/ELT development

SQL

Data warehousing concepts

Data quality & profiling

Troubleshooting data issues

Documentation & deployments

Agile experience

Strumenti

Snowflake

Azure Blob Storage

SFTP

Descrizione del lavoro

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.
• Developed and tested ETL/ELT pipelines.
• Data integration and validation test results.
• Technical documentation and production release materials.