Senior Informatica ETL Developer & DW Specialist

Cloud Analytics Technologies, LLC; Charlotte (NC); On-site; USD 90,000 - 130,000; Full time

Job summary

Cloud Analytics Technologies, LLC is seeking an experienced ETL Developer to design scalable data integration solutions and manage complex data workflows, ensuring reliable data delivery across enterprise systems. Ideal candidates have hands-on Informatica PowerCenter and Informatica Cloud (IICS), strong SQL/PLSQL, and experience with data warehouses, data marts, and dimensional modeling.

Proficiency in Unix/Linux scripting and job scheduling (Control-M or Autosys) is required; Oracle and SQL

Qualifications

• 5-8 years of ETL development experience.
• 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

Workflow development

Oracle

SQL Server

Dimensional modeling

Data warehouses

Unix/Linux scripting

Job scheduling

Control-M

Autosys

Cloud-based data integration

Education

Bachelor's degree in Computer Science, Information Technology, Software Engineering, or related discipline

Master's degree in a relevant technical field (added advantage)

Job description

Cloud Analytics Technologies, LLC is seeking an experienced ETL Developer to design scalable data integration solutions and manage complex data workflows, ensuring reliable data delivery across enterprise systems. Ideal candidates have hands-on Informatica PowerCenter and Informatica Cloud (IICS), strong SQL/PLSQL, and experience with data warehouses, data marts, and dimensional modeling.

Proficiency in Unix/Linux scripting and job scheduling (Control-M or Autosys) is required; Oracle and SQL