AWS Informatica Developer *

AWS Informatica DeveloperCGI 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.This position is required in one of the following locations: Lafayette, LA, Knoxville, TN, Birmingham, AL or Columbia, SC. CGI's benefits are offered to eligible professionals on their first day of employment to include: competitive compensation, comprehensive insurance options, matching contributions through the 401(k) plan and the share purchase plan, paid time off for vacation, holidays, and sick time, paid parental leave, learning opportunities and tuition assistance, wellness and well-being programs.Your Future Duties And Responsibilities:Develop, enhance, test, implement, and support ETL workflows using Informatica PowerCenter (CDI PC version). Analyze complex business and technical requirements and translate them into technical specifications. Develop and optimize complex Oracle SQL queries supporting data integration and processing. Develop Python scripts and utilities for data processing, automation, and integration. Create and maintain Unix/Linux shell scripts supporting ETL and batch processing. Work with AWS, including Lambda, SNS, and SQS, to support cloud-based data processing and integrations. Work with Amazon Redshift and Redshift Spectrum for large scale data processing and querying. Develop and support Apache Airflow DAGs for data pipeline orchestration and scheduling. Troubleshoot ETL, data pipeline, application, and production issues and perform root cause analysis. Support CI/CD and automated deployment processes, including Jenkins where applicable. Ensure solutions meet established security, quality, compliance, and operational requirements. Collaborate effectively with business and technology teams in a fast-paced financial services environment.Required Qualifications To Be Successful In This Role:5+ years of Informatica experience, with strong hands-on expertise in Informatica PowerCenter (CDI PC version). Strong enterprise ETL and data integration development experience. Advanced Oracle and SQL skills, including complex query development and troubleshooting. Strong Python scripting/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. Bachelor's degree in computer science, Information Technology, Engineering, or a related technical field.