Informatica ETL Engineer – PowerCenter & IICS

Valiant Technologies LLC; Columbia (SC); On-site; USD 110,000 - 150,000; Full time

Job summary

Valiant Technologies LLC is seeking an experienced ETL Developer to build scalable data integration solutions. The role focuses on Informatica PowerCenter and IICS, SQL/PL/SQL, data transformation, and enterprise data warehousing.

You will design, implement, and optimize ETL mappings, sessions, and workflows, ensuring data quality and performance across large datasets. Responsibilities include analyzing source-to-target mappings, coordinating with DBAs and data architects, monitoring production

Qualifications

• 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.

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

Skills

Informatica PowerCenter

Informatica Cloud (IICS)

SQL

PL/SQL

Data mapping

Data transformation

Data warehouses

Unix/Linux shell scripting

Job scheduling tools (Control-M/Autos-

Cloud-based data integration

Education

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

Master's degree in a relevant technical field

Equivalent industry experience

Job description

Valiant Technologies LLC is seeking an experienced ETL Developer to build scalable data integration solutions. The role focuses on Informatica PowerCenter and IICS, SQL/PL/SQL, data transformation, and enterprise data warehousing.

You will design, implement, and optimize ETL mappings, sessions, and workflows, ensuring data quality and performance across large datasets. Responsibilities include analyzing source-to-target mappings, coordinating with DBAs and data architects, monitoring production