AWS Informatica Developer

AWS Informatica DeveloperCGI is seeking an experienced Senior Informatica / AWS Data Engineer to support complex data integration and data processing solutions within a large scale financial services environment. This role is well suited for a hands on engineer with deep Informatica experience, strong SQL skills, and practical experience working with AWS data services. We partner with 15 of the top 20 banks globally, and our top 10 banking clients have worked with us for an average of 26 years!. This role is located at a client site in either Knoxville, TN, Columbia SC or Lafayette, LA or Birmingham, AL. A hybrid working model is acceptable.Your Future Duties and ResponsibilitiesThe successful candidate will analyze complex business and technical requirements, develop and enhance data integration components, and support applications throughout the development lifecycle. The role will work with Informatica, AWS, Python, SQL, Unix/Linux, and Redshift technologies to deliver reliable and scalable data solutions. Key responsibilities include:Analyze complex business and technical requirements and translate them into technical specifications.Develop, enhance, test, implement, and support Informatica based data integration solutions.Write and optimize complex SQL queries used for data processing, transformation, and analysis.Develop and maintain Unix/Linux shell scripts supporting data workflows and batch processing.Work with AWS services including Lambda, SNS, and SQS to support cloud based data processing and application integrations.Develop and maintain Python code supporting data processing and automation needs.Work with Amazon Redshift and Redshift Spectrum for large scale data processing and querying.Troubleshoot production and application issues and perform root cause analysis.Follow established development, testing, security, quality, and compliance standards.Collaborate with technical and business teams in a fast paced environment where priorities and requirements may evolve.Required Qualifications to Be Successful in This Role. 5+ years of Informatica experience, including hands on development and support of complex data integration solutions. Strong proficiency with Informatica and enterprise ETL/data integration processes. Advanced SQL skills, including experience writing and troubleshooting complex queries. Strong Unix/Linux and shell scripting experience. 3+ years of hands-on AWS experience, particularly with Lambda, SNS, and SQS. Working knowledge of Python for data processing, scripting, or automation. Hands on experience with Amazon Redshift and Redshift Spectrum. Experience troubleshooting complex data and application issues in enterprise environments. Understanding of software development, testing, deployment, security, and production support practices. Strong analytical and problem-solving skills with the ability to work independently. Comfortable working in an environment with changing requirements and priorities.SkillsWhat You Can Expect From UsTogether, as owners, let's turn meaningful insights into action. Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you'll reach your full potential because… You are invited to be an owner from day 1 as we work together to bring our Dream to life. That's why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company's strategy and direction. Your work creates value. You'll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise. You'll shape your career by joining a company built to grow and last. You'll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons. Come join our team—one of the largest IT and business consulting services firms in the world.