Senior Informatica ETL Engineer – AWS Data Pipelines

Cloud Analytics Technologies, LLC; Atlanta (GA); Presencial; USD 120.000 - 160.000; Jornada completa

Descripción de la vacante

Cloud Analytics Technologies, LLC is seeking an experienced Informatica Developer to analyze, design, and implement complex ETL solutions. The role emphasizes hands-on development with Informatica PowerCenter, Oracle SQL, Python, and AWS-based data processing in a fast-paced financial services setting.

You will design and optimize data pipelines, support CI/CD, and collaborate across teams to deliver scalable analytics solutions while ensuring security and compliance.

Formación

• Bachelor's degree in CS/IT/Engineering or related field.
• Minimum 5+ years of Informatica and PowerCenter experience.
• Strong Oracle SQL and PL/SQL skills with data integration focus.

Responsabilidades

• Develop, test, and support ETL workflows using Informatica PowerCenter.
• Analyze requirements and translate to technical specifications.
• Create and optimize Oracle SQL queries for data integration.
• Implement Python scripts and utilities for data processing.
• Develop Unix/Linux shell scripts for ETL and batch processing.
• Work with AWS services (Lambda, SNS, SQS) for cloud data processing.
• Leverage Amazon Redshift and Redshift Spectrum for large-scale queries.
• Build and operate Airflow DAGs for data pipelines.
• Troubleshoot production issues and perform root cause analysis.
• Support CI/CD and automated deployment (Jenkins).
• Ensure security, quality, and regulatory compliance of solutions.
• Collaborate with business and tech teams in a finance environment.

Conocimientos

Informatica PowerCenter

Oracle SQL

Python

Unix/Linux shell

AWS (Lambda/SNS/SQS)

Apache Airflow

Amazon Redshift

CI/CD / Jenkins

Java / J2EE (benefit)

Educación

Bachelor's degree in Computer Science / IT / Engineering / related field

Herramientas

Jenkins

Descripción del empleo

Cloud Analytics Technologies, LLC is seeking an experienced Informatica Developer to analyze, design, and implement complex ETL solutions. The role emphasizes hands-on development with Informatica PowerCenter, Oracle SQL, Python, and AWS-based data processing in a fast-paced financial services setting.

You will design and optimize data pipelines, support CI/CD, and collaborate across teams to deliver scalable analytics solutions while ensuring security and compliance.