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
