Informatica Developer: ETL, AWS & Data Pipeline Specialist

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

Job summary

Valiant Technologies LLC is seeking an Informatica Developer to design, develop, and test enterprise ETL solutions. The role emphasizes strong SDLC processes, data integration, and hands-on work with Informatica PowerCenter, Oracle SQL, Python, and AWS services.

You will collaborate with business and technology teams in a fast-paced financial services environment, troubleshoot production pipelines, and contribute to CI/CD practices using Jenkins.

Qualifications

• 5+ years of Informatica experience.
• PowerCenter (CDI PC) expertise required.
• Strong ETL and data integration development.
• Advanced Oracle and SQL skills.
• Python scripting for data processing.
• Unix/Linux shell scripting experience.
• 3+ years of AWS experience (Lambda, SNS, SQS).
• Experience with Apache Airflow DAGs.
• Experience with Amazon Redshift/Redshift Spectrum.
• Troubleshooting and root cause analysis skills.

Responsibilities

• Develop, test, and support ETL workflows using Informatica PowerCenter.
• Translate complex requirements into technical specs.
• Develop and optimize Oracle SQL queries for data integration.
• Create Python scripts and utilities for data processing.
• Create Unix/Linux shell scripts to support ETL and batch processing.
• Work with AWS services including Lambda, SNS, and SQS.
• Work with Redshift and Redshift Spectrum for large-scale processing.
• Develop and support Airflow DAGs for data orchestration.
• Troubleshoot ETL, data pipelines, and production issues; perform RCA.
• Support CI/CD and automated deployments (Jenkins).
• Ensure solutions meet security, quality, and compliance requirements.
• Collaborate with business and tech teams in a fast-paced financial services environment.

Skills

Informatica expertise

SQL proficiency

Python scripting

Unix/Linux shell scripting

AWS experience (Lambda/SNS/SQS)

ETL development

Data integration

Root cause analysis

Analytical thinking

Education

Bachelor's degree in computer science or related field

Tools

Informatica PowerCenter (CDI PC version)

Apache Airflow

Amazon Redshift

Redshift Spectrum

Jenkins

AWS Lambda

AWS SNS/SQS

Job description

Valiant Technologies LLC is seeking an Informatica Developer to design, develop, and test enterprise ETL solutions. The role emphasizes strong SDLC processes, data integration, and hands-on work with Informatica PowerCenter, Oracle SQL, Python, and AWS services.

You will collaborate with business and technology teams in a fast-paced financial services environment, troubleshoot production pipelines, and contribute to CI/CD practices using Jenkins.