ETL Developer

$76,300 - $185,800/Yr

CGI - Pittsburgh, PA

Full-time - Mid Level

Pittsburgh, PA

Professional, Scientific, and Technical Services

About the position

CGI is seeking ETL Developers to work closely with one or more Agile Software Development teams. The projects are fast-paced and utilize new and innovative technologies and methodologies to build new products or support new initiatives. As part of a close-knit team, you will have access to global resources and the opportunity to explore a wide range of industries, technologies, and geographies, all while enjoying the personal touch that our local operating approach offers. Growth at CGI is driven by your goals, so if you're looking for an inclusive place where you're empowered to chart your own path, then we'd love to meet you. This role can be completed from Cleveland, OH, Dallas, TX, or Pittsburgh, PA.

Responsibilities

• Responsible for sound and high quality technical deliverables.
• Analyze, quantize and estimate the amount of work for every sprint or release.
• Work in an Agile environment and adapt to the changing needs and requirements of the business.
• Be hands-on to develop or fix issues to deliver on time and with highest quality.
• Produce high quality code, following and recommending best practices.

Requirements

• Minimum 6+ years of overall experience in IT.
• Minimum 6+ years of ETL-Informatica experience using a variety of Databases.
• Act as SME to team in the plan, design, and delivery of BI and Data Warehouse solutions.
• Advise on the application of standards/methodology practices to the project.
• Create complex data loading processes for Operational Data Stores, Data Warehouses and Data Marts that satisfy all functional and technical requirements.
• Responsible for extracting data from various sources, transforming the data as required, and loading it to various target (ETL) database(s) and/or structures.
• Analyze and review complex object and data models and the metadata repository in order to structure processes and data for accuracy, efficiency, and maintainability.
• Work with various levels of project managers, data modelers, DBAs, and system administrators to design load processes and identify potential problem areas.
• Collaborate with the Data Architect to understand, interpret, and implement complex data integration requirements.
• Strong Documentation skills required.
• Strong Data Analysis skill using SQL.
• Develop Process flow diagrams.
• Strong Collaboration and communication skills within distributed project teams and in Agile environment.
• Excellent Oral and Written Communication Skills.

Benefits

• Competitive base salaries.
• Eligibility to participate in an attractive Share Purchase Plan (SPP) in which the company matches dollar-for-dollar contributions made by eligible employees, up to a maximum, for their job category.
• 401(k) Plan and Profit Participation for eligible members.
• Generous holidays, vacation, and sick leave plans.
• Comprehensive insurance plans that include, among other benefits, medical, dental, vision, life, disability, out-of-county emergency coverage in all countries of employment.
• Back-up child care, Pet insurance, a Member Assistance Program, a 529 college savings program, a personal financial management tool, lifestyle management programs and more.