Senior Informatica Developer: Cloud ETL & Data Pipelines

Machine Learning Technologies, LLC; Atlanta (GA); On-site; USD 110,000 - 140,000; Full time

Benefits offered by this job

Health insurance

Job summary

Machine Learning Technologies, LLC is seeking an Informatica Developer to perform high-complexity analysis, design, development, and unit testing of enterprise applications. The role requires strong SDLC, testing, Informatica, Python, Lambdas, SQL, and experience with J2EE/Java, Oracle, and Windows environments.

Responsibilities include ETL workflow development with Informatica PowerCenter, SQL query optimization for data integration, Python scripting, AWS-driven data processing, and Airflow

Qualifications

• 5+ years of Informatica experience with PowerCenter (CDI PC).
• PowerCenter experience required; IDMC not a substitute.
• Strong enterprise ETL and data integration development.
• Advanced Oracle and SQL skills with complex queries.
• Strong Python scripting for data processing and automation.
• Unix/Linux shell scripting experience.
• 3+ years of hands-on AWS experience (Lambda, SNS, SQS).
• Airflow DAG development and data pipeline orchestration.
• Experience with Redshift/Redshift Spectrum.
• Troubleshooting, root-cause analysis, and production support.

Responsibilities

• Develop, test, and support ETL workflows using Informatica PowerCenter.
• Analyze requirements and translate into technical specifications.
• Develop complex Oracle SQL queries for data integration.
• Create Python scripts and utilities for data processing.
• Create Unix/Linux shell scripts for ETL and batch processing.
• Work with AWS services (Lambda, SNS, SQS) for cloud data processing.
• Work with Redshift and Redshift Spectrum for large-scale querying.
• Develop and support Airflow DAGs for orchestration.
• Troubleshoot ETL and data pipelines and perform root cause analysis.
• Support CI/CD and automated deployments, including Jenkins where applicable.

Skills

ETL design

Data integration

Python

Unix/Linux scripting

SQL

AWS cloud

Education

Bachelor's degree in CS/IT/Engineering

Tools

Informatica PowerCenter

Oracle SQL

Python

Unix/Linux shell scripting

Airflow

Amazon Redshift

AWS Lambda/SNS/SQS

Job description

Machine Learning Technologies, LLC is seeking an Informatica Developer to perform high-complexity analysis, design, development, and unit testing of enterprise applications. The role requires strong SDLC, testing, Informatica, Python, Lambdas, SQL, and experience with J2EE/Java, Oracle, and Windows environments.

Responsibilities include ETL workflow development with Informatica PowerCenter, SQL query optimization for data integration, Python scripting, AWS-driven data processing, and Airflow