Senior ETL Engineer — Informatica PowerCenter & IICS

Robotics Technologies LLC; Columbia (SC); In loco; USD 90.000 - 135.000; Tempo pieno

Descrizione del lavoro

Robotics Technologies LLC is seeking an ETL Developer to design and maintain scalable data integration solutions. You will work with Informatica PowerCenter and IICS, write complex SQL/PLSQL, and model dimensional structures for enterprise data warehouses.

You will manage Unix/Linux scripting and job scheduling with Control-M or Autosys, ensuring data quality and timely delivery. The role emphasizes production support, documentation, and collaboration with DBAs and data architects to optimize

Competenze

• Strong hands-on experience with Informatica PowerCenter and Informatica Cloud (IICS).
• Proficiency in SQL, PL/SQL, and complex query development.
• Experience with data mapping, transformation, and workflow development.
• Knowledge of Oracle, SQL Server, and relational database systems.
• Understanding of dimensional modeling, data marts, and data warehouses.
• Experience with Unix/Linux shell scripting.
• Knowledge of scheduling tools such as Control-M or Autosys.
• Familiarity with cloud-based data integration is an advantage.

Mansioni

• Develop and maintain ETL mappings, sessions, workflows, and reusable transformations.
• Build data integration solutions to process structured and unstructured data.
• Analyze source-to-target mapping documents and implement transformation logic.
• Optimize ETL workflows to improve processing time and system performance.
• Perform data reconciliation and troubleshoot data quality issues.
• Coordinate with database administrators and data architects.
• Monitor scheduled jobs and resolve production failures.
• Prepare technical documentation and support deployment activities.

Conoscenze

SQL

PL/SQL

Data mapping

Workflow development

Dimensional modeling

Unix/Linux scripting

Formazione

Bachelor's degree in Computer Science/IT/Software Engineering

Master's degree preferred

Strumenti

Informatica PowerCenter

Informatica Cloud (IICS)

Oracle

SQL Server

Control-M

Autosys

Descrizione del lavoro

Robotics Technologies LLC is seeking an ETL Developer to design and maintain scalable data integration solutions. You will work with Informatica PowerCenter and IICS, write complex SQL/PLSQL, and model dimensional structures for enterprise data warehouses.

You will manage Unix/Linux scripting and job scheduling with Control-M or Autosys, ensuring data quality and timely delivery. The role emphasizes production support, documentation, and collaboration with DBAs and data architects to optimize