IICS Cloud Data Integration Engineer

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

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.