Informatica ETL Developer – Data Warehouse Specialist

Robotics Technologies LLC; Charlotte (NC); In loco; USD 90.000 - 130.000; Tempo pieno

Descrizione del lavoro

Robotics Technologies LLC in Charlotte, NC seeks an experienced ETL Developer to design and maintain scalable data integration solutions. You will work with Informatica PowerCenter and IICS to transform data, build robust ELT workflows, and optimize performance across enterprise data warehouses.

The role requires strong SQL/PL-SQL skills, Unix/Linux scripting, and experience with scheduling tools like Control-M or Autosys. A related Bachelor's degree is expected, with a Master’s preferred.

Competenze

• 5–8 years of experience in ETL development.
• Minimum 3 years of hands-on Informatica PowerCenter experience.
• Strong experience developing complex SQL queries and PL/SQL procedures.
• Experience with enterprise data warehouses and large datasets.
• Practical experience with Unix/Linux scripting and job scheduling.
• Experience in production support and performance optimization.

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

Data transformation

Data warehousing

Unix/Linux scripting

Job scheduling

Formazione

Bachelor's degree in CS/IT/SE or related

Master's degree (added advantage)

Strumenti

Informatica PowerCenter

Informatica Cloud (IICS)

Control-M

Autosys

Descrizione del lavoro

Robotics Technologies LLC in Charlotte, NC seeks an experienced ETL Developer to design and maintain scalable data integration solutions. You will work with Informatica PowerCenter and IICS to transform data, build robust ELT workflows, and optimize performance across enterprise data warehouses.

The role requires strong SQL/PL-SQL skills, Unix/Linux scripting, and experience with scheduling tools like Control-M or Autosys. A related Bachelor's degree is expected, with a Master’s preferred.