Senior ETL Developer - Informatica & Data Warehouse

Machine Learning Technologies, LLC; Charlotte (NC); In loco; USD 95.000 - 130.000; Tempo pieno

Descrizione del lavoro

Machine Learning Technologies, LLC seeks an experienced ETL Developer to design and implement scalable data integration solutions. You will work with Informatica PowerCenter and Informatica Cloud (IICS) to build mappings, sessions, workflows, and reusable transformations within enterprise data warehouses.

The role requires strong SQL/PL-SQL skills, data mapping and transformation capabilities, and experience with Unix/Linux scripting and job scheduling tools such as Control-M or Autosys.

Competenze

• 5–8 years of ETL development experience.
• Minimum 3 years of Informatica PowerCenter experience.
• Strong SQL/PL-SQL and complex query development.
• Experience with enterprise data warehouses and large datasets.
• Unix/Linux scripting and job scheduling experience.
• Production support and performance optimization experience.

Mansioni

• Develop and maintain ETL mappings, sessions, workflows, and reusable transformations.
• Build data integration solutions for structured and unstructured data.
• Analyze source-to-target mapping documents and implement transformation logic.
• Optimize ETL workflows for performance and reliability.
• Perform data reconciliation and troubleshoot data quality issues.
• Coordinate with DBAs and data architects.
• Monitor scheduled jobs and resolve production failures.
• Prepare technical documentation and support deployments.

Conoscenze

SQL proficiency

PL/SQL

Data integration

Data warehouse concepts

Data mapping

Data transformation

Workflow development

Unix/Linux scripting

Formazione

Bachelor's degree in CS/IT/related

Master's degree preferred

Equivalent industry experience

Strumenti

Informatica PowerCenter

Informatica Cloud (IICS)

Control-M

Autosys

Oracle/SQL Server

Unix/Linux

Cloud data integration

Descrizione del lavoro

Machine Learning Technologies, LLC seeks an experienced ETL Developer to design and implement scalable data integration solutions. You will work with Informatica PowerCenter and Informatica Cloud (IICS) to build mappings, sessions, workflows, and reusable transformations within enterprise data warehouses.

The role requires strong SQL/PL-SQL skills, data mapping and transformation capabilities, and experience with Unix/Linux scripting and job scheduling tools such as Control-M or Autosys.