Senior Informatica ETL Developer (AWS)
About The Position
CGI is seeking a Senior Informatica ETL Developer to support and enhance enterprise data warehouse applications. The role focuses on building and maintaining data pipelines using Informatica PowerCenter and IDMC, AWS services, and Python. The position is based in one of the following locations: Birmingham, Alabama; Columbia, South Carolina; Knoxville, Tennessee; or Lafayette, Louisiana. The developer will work with data engineering and operations teams, assist with workflow orchestration, and participate in an on-call rotation for production support. The position requires experience with ETL development or data engineering, Informatica technologies, AWS, Python, SQL, data warehouses, and large-scale data pipelines. A bachelor's degree in Computer Science, Engineering, or a related field is preferred. The estimated U.S. compensation range is $97,300 to $123,200. Eligible professionals receive CGI benefits from their first day of employment. U.S. offers are contingent on successfully completing a background investigation.
Requirements
- At least 7 years of experience in ETL development or data engineering, with strong Informatica PowerCenter skills.
- Experience with Informatica IDMC.
- Hands-on experience with AWS services including EMR, ECS, Glue, Redshift, S3, SNS, SQS, Lambda, and CloudWatch.
- Strong Python and SQL skills, including work with Redshift, PostgreSQL, or Oracle.
- Experience supporting data warehouses and large-scale data pipelines.
- Docker experience.
- Ability to troubleshoot production issues, communicate clearly, and work independently and as part of a team.
- Experience working in Agile teams and participating in sprint ceremonies.
Nice To Haves
- Familiarity with Autosys or MWAA.
- A bachelor's degree in Computer Science, Engineering, or a related field.
Responsibilities
- Support and enhance enterprise data warehouse applications.
- Build and maintain data pipelines using Informatica PowerCenter and IDMC, AWS services, and Python.
- Work with data engineering and operations teams.
- Help manage workflow orchestration.
- Participate in an on-call rotation for production support.
- Troubleshoot production issues.
- Participate in Agile team sprint ceremonies.
Benefits
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
