ETL Engineer - Informatica & Data Warehousing

Cloud Analytics Technologies, LLC; Columbia (SC); On-site; USD 100,000 - 130,000; Full time

Job summary

Cloud Analytics Technologies, LLC in the United States (Columbia, SC) seeks an experienced ETL Developer to build scalable data integration solutions using Informatica PowerCenter and Informatica Cloud (IICS). Proficiency in SQL/PL-SQL and data warehousing is required.

You will optimize ETL workflows, perform data mapping, and collaborate with DBAs and data architects to ensure data quality and timely delivery. A Bachelor's degree is required; 5–8 years of experience is preferred.

Qualifications

• Bachelor's degree in CS/IT/Software Engineering or related field.
• 5–8 years of ETL development experience.
• Minimum 3 years with Informatica PowerCenter.
• Strong SQL/PL-SQL development and data warehousing knowledge.

Responsibilities

• Develop and maintain ETL mappings, sessions, and workflows.
• Build data integration solutions for structured and unstructured data.
• Analyze source-to-target mappings and implement transformation logic.
• Optimize ETL workflows for performance and reliability.
• Perform data reconciliation and address data quality issues.
• Coordinate with DBAs and data architects; monitor jobs; troubleshoot failures.
• Prepare technical docs and support deployment activities.

Skills

ETL development

Data mapping

Data transformation

Dimensional modeling

Data marts

Data warehousing

Unix/Linux scripting

Production support

Education

Bachelor's degree in CS/IT/SE

Master's degree (advantage)

Tools

Informatica PowerCenter

Informatica Cloud (IICS)

SQL

PL/SQL

Oracle

SQL Server

Unix/Linux

Control-M

Autosys

Job description

Cloud Analytics Technologies, LLC in the United States (Columbia, SC) seeks an experienced ETL Developer to build scalable data integration solutions using Informatica PowerCenter and Informatica Cloud (IICS). Proficiency in SQL/PL-SQL and data warehousing is required.

You will optimize ETL workflows, perform data mapping, and collaborate with DBAs and data architects to ensure data quality and timely delivery. A Bachelor's degree is required; 5–8 years of experience is preferred.