Senior ETL Developer – Informatica & Data Warehouse

Valiant Technologies LLC; Charlotte (NC); On-site; USD 90,000 - 120,000; Full time

Job summary

Valiant Technologies LLC is seeking an experienced ETL Developer to design and maintain scalable data integration solutions in a data warehousing environment. You will work with Informatica PowerCenter and IICS, crafting complex SQL/PL-SQL queries to support large datasets.

The role focuses on building reusable transformations, optimizing ETL workflows, and ensuring data quality while collaborating with DBAs and data architects to support production deployments in a fast-paced enterprise setting.

Qualifications

• Bachelor's degree in CS/IT/SE or equivalent.
• 5–8 years of ETL development experience.
• Minimum 3 years of hands-on Informatica PowerCenter experience.
• Experience with enterprise data warehouses and large datasets.
• Proficient in Unix/Linux scripting and job scheduling.
• Strong SQL/PL-SQL and complex query development.

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

Workflow development

Oracle

SQL Server

Relational databases

Dimensional modeling

Data marts

Data warehouse

Unix/Linux scripting

Job scheduling (Control-M/Autosys)

Cloud data integration

Education

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

Master's degree in a relevant technical field

Equivalent relevant industry experience

Tools

Oracle

SQL Server

Control-M

Autosys

Job description

Valiant Technologies LLC is seeking an experienced ETL Developer to design and maintain scalable data integration solutions in a data warehousing environment. You will work with Informatica PowerCenter and IICS, crafting complex SQL/PL-SQL queries to support large datasets.

The role focuses on building reusable transformations, optimizing ETL workflows, and ensuring data quality while collaborating with DBAs and data architects to support production deployments in a fast-paced enterprise setting.