AWS Informatica Developer

Job Title: Senior AWS Informatica Developer Duration: Full Time / Permanent Position Location: Lafayette, LA; Knoxville, TN; Birmingham, AL; or Columbia, SC Work Mode: 5 Days Onsite

Position Description Systemone is seeking an AWS Informatica Developer to support enterprise data integration and processing solutions within a large-scale financial services environment. This is a hands-on engineering role requiring deep experience with Informatica PowerCenter (CDI PC version), Oracle/SQL, Python, shell scripting, Airflow, and AWS technologies.

The engineer will develop, enhance, test, implement, and support complex ETL and data processing workflows across traditional and AWS-based environments. This position requires strong troubleshooting and problem-solving skills, along with experience supporting reliable, secure, and high-volume enterprise data pipelines.

Required Qualifications

• 5+ years of Informatica experience, with strong hands-on expertise in Informatica PowerCenter (CDI PC version).
• Informatica PowerCenter experience is mandatory. IDMC experience alone is not a substitute.
• Strong enterprise ETL and data integration development experience.
• Advanced Oracle and SQL skills, including complex query development and troubleshooting.
• Strong Python scripting and 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 Skills

• 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.

Ref: #404-IT Pittsburgh