Senior ETL Developer: Informatica PowerCenter & IICS

Artifintech; Charlotte (NC); On-site; USD 110,000 - 140,000; Full time

Job summary

Artifintech seeks an experienced ETL Developer to design and implement scalable data integration solutions using Informatica PowerCenter and IICS. The role focuses on building and maintaining ETL mappings, sessions, and workflows for enterprise data warehouses.

You will work with SQL/PL-SQL, Unix/Linux scripting, and job scheduling tools to optimize performance and ensure data quality across complex datasets. A strong background in data modeling and collaboration with DBAs is required.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related discipline.
• 5–8 years of ETL development experience.
• Strong experience with Informatica PowerCenter and IICS.
• Proficiency in 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 & transformation

Unix/Linux shell scripting

Job scheduling

Data warehouses

Education

Bachelor's degree in CS/IT/SE

Master's degree in a technical field

Equivalent relevant industry experience

Tools

Oracle

SQL Server

Control-M

Autosys

Unix/Linux

Job description

Artifintech seeks an experienced ETL Developer to design and implement scalable data integration solutions using Informatica PowerCenter and IICS. The role focuses on building and maintaining ETL mappings, sessions, and workflows for enterprise data warehouses.

You will work with SQL/PL-SQL, Unix/Linux scripting, and job scheduling tools to optimize performance and ensure data quality across complex datasets. A strong background in data modeling and collaboration with DBAs is required.