AWS Informatica Developer

System One; Birmingham (AL); Hybrid; USD 120,000 - 165,000; Full time

Job summary

System One is seeking an AWS Informatica Developer in Lafayette, LA for a permanent full-time, hybrid on-site/remote role. Responsibilities include designing and supporting ETL workflows with Informatica PowerCenter, AWS data services, Redshift, Airflow, and SQL optimization within a financial services setting.

The ideal candidate brings 7+ years in Informatica, strong SQL/Oracle skills, Python proficiency, and hands-on AWS + Airflow experience, with a focus on scalable, secure data pipelines

Qualifications

• 7+ years of Informatica experience with hands-on PowerCenter (CDI PC version)
• Informatica PowerCenter experience required; IDMC not acceptable as a substitute
• 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 (Lambda, SNS, SQS)
• Hands-on experience with Apache Airflow, including DAG development
• Experience with Amazon Redshift and Redshift Spectrum
• Strong troubleshooting, analytical and root cause analysis skills in enterprise data pipelines
• Ability to adapt to changing requirements and priorities
• Desirable: AutoSys scheduling, Jenkins/CI-CD, additional AWS data services
• Desirable: experience in financial services or regulated industries
• Bachelor's degree related to CS/IT/Engineering

Responsibilities

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

Skills

Informatica PowerCenter

SQL

Python scripting

Unix/Linux shell scripting

AWS (Lambda, SNS, SQS)

Apache Airflow

Troubleshooting/Root cause analysis

Security/compliance awareness

Education

Bachelor's degree in Computer Science/IT/Engineering or related field

Tools

Jenkins

AutoSys

Amazon Redshift

Redshift Spectrum

Job description

Job Title: AWS Informatica Developer
Location: Lafayette, LA
Type: Permanent Full Time
Work Model: Hybrid – onsite and remote

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

• 7+ 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:

• AutoSys scheduling experience.
• 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.

System One, and its subsidiaries including Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.