Highlights
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. This position requires strong troubleshooting and problem-solving skills, along with experience supporting reliable, secure, and high-volume enterprise data pipelines.
Numbers & Facts
| Location | Lafayette, LA |
| Industry | Staffing/Employment Agencies |
| Company Size | 2,500 to 4,999 employees |
| Website | https://systemone.com |
Description
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
About Company
Every day, System One focuses on services and solutions that require a high degree of specialization, in-demand technical skills, and large-scale operational expertise. We are essential partners to those on the front lines of our nation’s most critical infrastructure, technology, and life sciences initiatives.
Founded more than 40 years ago as a staffing partner to the engineering industry, today System One is a diversified organization operating in over 50 locations and putting more than 9,000 people to work in the United States, Canada, and the United Kingdom.