Informatica Developer

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

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Summary:

We are looking for an Informatica Developer to perform high-complexity analysis, design, development, and unit testing of enterprise applications. Must be strong in SDLC, testing, Informatica, Python, Lambdas, SQL, and one or more of J2EE, Java, EJB, ASP, PowerBuilder, C, C++, CGI, Windows, NT, Visual Basic, Oracle, Sybase, MQ Series.

Responsibilities

• Develop, enhance, test, implement, and support ETL workflows using Informatica PowerCenter (CDI PC version).
• Analyze complex business and technical requirements and translate them into technical specifications.
• Develop and optimize complex Oracle SQL queries supporting data integration and processing.
• Develop Python scripts and utilities for data processing, automation, and integration.
• Create and maintain Unix/Linux shell scripts supporting ETL and batch processing.
• Work with AWS, including Lambda, SNS, and SQS, to support cloud-based data processing and integrations.
• Work with Amazon Redshift and Redshift Spectrum for large scale data processing and querying.
• Develop and support Apache Airflow DAGs for data pipeline orchestration and scheduling.
• Troubleshoot ETL, data pipeline, application, and production issues and perform root cause analysis.
• Support CI/CD and automated deployment processes, including Jenkins where applicable.
• Ensure solutions meet established security, quality, compliance, and operational requirements.
• Collaborate effectively with business and technology teams in a fast-paced financial services environment.

Requirements

• 5+ years of Informatica experience, with strong hands-on expertise in Informatica PowerCenter (CDI PC version).
• Informatica PowerCenter experience is required; IDMC should not be considered a substitute for the required PowerCenter experience.
• Strong enterprise ETL and data integration development experience.
• Advanced Oracle and SQL skills, including complex query development and troubleshooting.
• Strong Python scripting/development skills for data processing and automation.
• Strong Unix/Linux shell scripting experience.
• 3+ years of hands-on AWS experience, including Lambda, SNS, and SQS.
• Hands on experience with Apache Airflow, including DAG development and data pipeline orchestration.
• Experience with Amazon Redshift and Redshift Spectrum.
• Strong troubleshooting, analytical, and root cause analysis skills.
• Experience supporting enterprise data pipelines and production environments.
• Ability to work effectively with changing requirements and priorities.

Desired Skillset

• Jenkins and CI/CD experience.
• Additional AWS data services experience.
• Financial services or other regulated industry experience.

Educational Requirements

Bachelor's degree in computer science, Information Technology, Engineering, or a related technical field.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.