Senior ETL Developer: Informatica PowerCenter Expert

Quantum Technologies. LLC; Columbia (SC); On-site; USD 110,000 - 140,000; Full time

Job summary

Quantum Technologies. LLC is seeking an experienced ETL Developer to design and maintain scalable data integration workflows within our data warehouse environment.

The ideal candidate will demonstrate hands-on expertise with Informatica PowerCenter and IICS, strong SQL/PLSQL skills, and a track record of optimizing ETL performance in enterprise-scale warehouses. Experience with Unix scripting and job scheduling is preferred, with a focus on reliability and efficiency.

Qualifications

• 5–8 years of ETL development experience.
• 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 Unix/Linux scripting and job scheduling experience.
• Production support and performance optimization experience.

Responsibilities

• 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 DBAs and data architects.
• Monitor scheduled jobs and resolve production failures.
• Prepare technical documentation and support deployment activities.

Skills

SQL

PL/SQL

Data mapping

Data transformation

Workflow development

Unix/Linux shell scripting

Data warehousing concepts

Education

Bachelor's degree in Computer Science, Information Technology, Software Engineering

Master's degree in a relevant technical field

Equivalent relevant industry experience may be considered

Tools

Informatica PowerCenter

Informatica Cloud (IICS)

Oracle

SQL Server

Control-M

Autosys

Job description

Quantum Technologies. LLC is seeking an experienced ETL Developer to design and maintain scalable data integration workflows within our data warehouse environment.

The ideal candidate will demonstrate hands-on expertise with Informatica PowerCenter and IICS, strong SQL/PLSQL skills, and a track record of optimizing ETL performance in enterprise-scale warehouses. Experience with Unix scripting and job scheduling is preferred, with a focus on reliability and efficiency.