ETL Lead Developer

CGI•Pittsburgh, PA

19h•Onsite

About The Position

CGI is hiring a Lead ETL Developer to serve as a technical expert on a large-scale digital development project with onshore and offshore developers. The role uses Informatica, Oracle, Teradata, and Tableau, and involves working with Product Owners, Subject Matter Experts, and Technical Managers to build workflows and schedule jobs. The position is open in Pittsburgh, Dallas, and Strongsville and must be performed five days per week at the client site. Employer sponsorship for immigration-related visas or green card status through the PERM process is not available for this client engagement. The Lead ETL Developer aligns business strategy with software solutions; proposes, designs, and codes solutions for complex business needs; leads problem solving; provides technical guidance; and oversees technical and procedural documentation. The role also applies modern principles, methodologies, and tools to advance business initiatives and capabilities. The stated U.S. compensation range is $89,600 to $176,300. CGI lists benefits for eligible professionals beginning on their first day of employment, including competitive compensation, comprehensive insurance options, matching contributions through its 401(k) and share purchase plans, paid time off for vacation, holidays, and sick time, paid parental leave, learning opportunities and tuition assistance, and wellness and well-being programs.

Requirements

6–8 years of experience working in relational database design with Oracle and Teradata.
Proficiency in Informatica and good knowledge of ETL development.
Strong experience designing, building, and testing ETL applications.
Experience working with enterprise data warehouses.
Familiarity with extracting data from multiple sources, including DB2, Oracle, and flat files.
Familiarity with database stored procedures.
Strong SQL experience.
Experience working in a Linux environment and with shell scripting.
Strong Agile/Scrum development experience.
Strong collaboration and communication skills within distributed project teams.
Excellent written and verbal communication skills.

Responsibilities

Align business strategy with software solutions.
Propose, design, and code software solutions for complex business needs.
Oversee required technical and procedural documentation.
Lead complex problem solving.
Provide technical guidance and support to colleagues and solution development.
Apply modern principles, methodologies, and tools to advance business initiatives and capabilities.
Work with Product Owners, Subject Matter Experts, and Technical Managers to build workflows and schedule jobs.
Provide end-user support, including responding to business queries and requests.
Review deliverables and identify gaps and areas for improvement.
Maintain current knowledge of standards, guidelines, and industry trends for data integration, data migration, and architectures.
Design and develop logical and physical data models.