AWS Informatica Developer

The AWS Informatica Developer role at System One is focused on building and supporting ETL workflows in an AWS-based environment. The position centers on Informatica PowerCenter (CDI PC version), data pipeline orchestration, and production support for integration workloads.

Responsibilities

• Develop, enhance, test, implement, and support ETL workflows using Informatica PowerCenter (CDI PC version).
• Review complex business and technical requirements and translate them into technical specifications.
• Develop and optimize complex Oracle SQL queries used for data integration and processing.
• Build Python scripts and supporting utilities for data processing, automation, and integration.
• Create and maintain Unix/Linux shell scripts to support ETL and batch processing.
• Support AWS-based processing and integrations using Lambda, SNS, and SQS.
• Work with Amazon Redshift and Redshift Spectrum for large-scale data processing and querying.
• Develop and maintain Apache Airflow DAGs for pipeline orchestration and scheduling.
• Troubleshoot ETL, data pipeline, application, and production issues and perform root cause analysis.
• Support CI/CD and automated deployment workflows, including Jenkins where applicable.
• Ensure solutions meet established security, quality, compliance, and operational requirements.
• Collaborate 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 is required; IDMC should not be considered a substitute.
• Strong enterprise experience in ETL and data integration development.
• Advanced Oracle SQL and strong query development and troubleshooting skills.
• Strong Python scripting and development skills for automation and processing.
• Strong experience with Unix/Linux shell scripting.
• 3+ years of hands-on AWS experience, including Lambda, SNS, and SQS.
• Hands-on experience with Apache Airflow, including DAG development and pipeline orchestration.
• Experience with Amazon Redshift and Redshift Spectrum.
• Strong troubleshooting, analytical skills, and the ability to perform root cause analysis.
• Experience supporting enterprise data pipelines and production environments.
• Ability to work effectively with changing requirements and shifting priorities.

Required Education

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

Technologies

• Informatica PowerCenter
• Oracle SQL
• Python
• Unix/Linux shell scripts
• AWS Lambda
• AWS SNS
• AWS SQS
• Amazon Redshift
• Redshift Spectrum
• Apache Airflow
• Jenkins
• CI/CD

Benefits

• Health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, and voluntary plans
• Participation in a 401(k) plan

Desired Skillset

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