Informatica Developer - AWS Data Pipelines & ETL

Robotics Technologies LLC; Atlanta (GA); On-site; USD 120,000 - 150,000; Full time

Job summary

Robotics Technologies LLC is seeking an experienced Informatica Developer to design, develop, and test enterprise ETL solutions. You will work with Informatica PowerCenter, Oracle SQL, Python, and Unix/Linux shell scripting to build robust data pipelines.

The role involves AWS-based data processing, Redshift, and Airflow for orchestration, plus CI/CD practices and production support in a financial services setting.

Qualifications

• 5+ years of Informatica PowerCenter development.
• Proficient in complex Oracle SQL and data integration.
• Strong Python scripting and Unix/Linux shell skills.
• Experience with AWS services and Apache Airflow.

Responsibilities

• Develop, test, and support ETL workflows using Informatica PowerCenter.
• Analyze complex requirements and translate to technical specifications.
• Develop and optimize Oracle SQL for data integration and processing.
• Create Python scripts and utilities for data processing and automation.
• Create and maintain Unix/Linux shell scripts for ETL and batch processing.
• Work with AWS (Lambda, SNS, SQS) for cloud-based data processing.
• Develop and support Airflow DAGs for data orchestration.
• Troubleshoot ETL/data pipeline issues and perform root cause analysis.
• Support CI/CD and automated deployment processes (e.g., Jenkins).
• Ensure solutions meet security, quality, and compliance requirements.
• Collaborate with business and technology teams in a fast-paced financial services environment.

Skills

Informatica PowerCenter

SQL queries

Python scripting

Unix/Linux shell

ETL design

Root cause analysis

Education

Bachelor's degree in CS/IT/Engineering

Tools

Informatica PowerCenter

AWS

Apache Airflow

Amazon Redshift

Redshift Spectrum

Oracle

Jenkins / CI-CD

Job description

Robotics Technologies LLC is seeking an experienced Informatica Developer to design, develop, and test enterprise ETL solutions. You will work with Informatica PowerCenter, Oracle SQL, Python, and Unix/Linux shell scripting to build robust data pipelines.

The role involves AWS-based data processing, Redshift, and Airflow for orchestration, plus CI/CD practices and production support in a financial services setting.