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

System One, and its subsidiaries including Joulé, ALTA IT Services, TeamPeople, and 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.