Senior Informatica Developer - Cloud & Data Pipeline Expert

Artifintech; Atlanta (GA); On-site; USD 100,000 - 150,000; Full time

Job summary

Artifintech is seeking an experienced Informatica Developer to perform high‑complexity analysis, design, development, and unit testing of enterprise applications. The role requires strong in SDLC, testing, Informatica, Python, Lambdas, SQL, and a broader Java stack.

Responsibilities include ETL workflows with PowerCenter, Oracle SQL optimization, Python scripting, shell scripting, and AWS services (Lambda, SNS, SQS), plus Redshift, Airflow, and CI/CD.

Qualifications

• 5+ years of Informatica experience with PowerCenter.
• PowerCenter experience required; IDMC not substitute.
• Strong ETL and data integration development.
• Advanced Oracle and SQL skills.
• Strong Python scripting for data processing.
• Strong Unix/Linux shell scripting.
• 3+ years AWS experience (Lambda, SNS, SQS).
• Experience with Apache Airflow and DAGs.
• Experience with Redshift and Redshift Spectrum.
• Strong troubleshooting and root cause analysis.
• Experience supporting enterprise data pipelines.
• Ability to adapt to changing requirements.

Responsibilities

• Develop, test, and support ETL workflows using Informatica PowerCenter.
• Analyze requirements and translate into technical specs.
• Develop and optimize Oracle SQL queries.
• Develop Python scripts for data processing and automation.
• Create Unix/Linux shell scripts for ETL and batch processing.
• Work with AWS services (Lambda, SNS, SQS) for cloud data processing.
• Use Redshift/Redshift Spectrum for large-scale data.
• Develop Airflow DAGs for data pipelines.
• Troubleshoot ETL and production issues; perform root cause analysis.
• Support CI/CD and deployments (Jenkins where applicable).
• Ensure security, quality, compliance, and ops requirements.
• Collaborate with business and technology teams in financial services.

Skills

ETL development

SQL

Python

Unix/Linux scripting

AWS

Airflow

Data integration

CI/CD

Troubleshooting

Root cause analysis

Education

Bachelor's degree in computer science or related field

Tools

Informatica PowerCenter

Oracle

Redshift

Redshift Spectrum

Apache Airflow

AWS Lambda

AWS SQS

AWS SNS

Jenkins

Job description

Artifintech is seeking an experienced Informatica Developer to perform high‑complexity analysis, design, development, and unit testing of enterprise applications. The role requires strong in SDLC, testing, Informatica, Python, Lambdas, SQL, and a broader Java stack.

Responsibilities include ETL workflows with PowerCenter, Oracle SQL optimization, Python scripting, shell scripting, and AWS services (Lambda, SNS, SQS), plus Redshift, Airflow, and CI/CD.