ETL Architect - Informatica PowerCenter & IICS Expert

Artifintech; Columbia (SC); On-site; USD 90,000 - 120,000; Full time

Job summary

Artifintech in Columbia, SC is seeking an experienced ETL Developer to design and implement scalable data integration solutions using Informatica PowerCenter and Informatica Cloud (IICS). The role requires strong SQL/PL-SQL skills, data mapping and transformation experience, and familiarity with data warehouses, Unix/Linux scripting, and job scheduling tools like Control-M or Autosys.

You will collaborate with DBAs and data architects, optimize pipelines for performance, perform data

Qualifications

• 5–8 years of ETL development experience.
• Informatica PowerCenter and IICS hands-on experience.
• Proficient in SQL and PL/SQL.
• Experience with enterprise data warehouses.
• Unix/Linux scripting and job scheduling experience.
• Knowledge of Oracle/SQL Server and relational databases.
• Familiar with dimensional modeling and data marts.

Responsibilities

• Develop and maintain ETL mappings, sessions, workflows, and reusable transformations.
• Build data integration solutions for structured and unstructured data.
• Analyze source-to-target mappings and implement transformation logic.
• Optimize ETL workflows for performance and speed.
• Perform data reconciliation and troubleshoot 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 scripting

Control-M

Autosys

Education

Bachelor’s degree in Computer Science / IT / Software Engineering

Master’s degree in a relevant field (added advantage)

Equivalent industry experience considered

Tools

Informatica PowerCenter

Informatica Cloud (IICS)

Oracle

SQL Server

Control-M

Autosys

Job description

Artifintech in Columbia, SC is seeking an experienced ETL Developer to design and implement scalable data integration solutions using Informatica PowerCenter and Informatica Cloud (IICS). The role requires strong SQL/PL-SQL skills, data mapping and transformation experience, and familiarity with data warehouses, Unix/Linux scripting, and job scheduling tools like Control-M or Autosys.

You will collaborate with DBAs and data architects, optimize pipelines for performance, perform data