ETL Developer (Informatica)

CGI•Pittsburgh, PA

13h•Onsite

About The Position

We're growing rapidly and are looking for ETL Developers to work closely with one or more Agile Software Development teams. The projects are fast-paced, use new and innovative technologies/methodologies to build new products or for new initiatives. This position is located in our client offices in either Pittsburgh, PA, Cleveland, OH, Phoenix, AZ, Birmingham, AL, or Dallas, TX. We're a close-knit team that has access to global resources. You'll have 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. Your future duties and responsibilities: Analyzes, defines and documents detailed REST API requirements through user interviews, facilitated . 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. . Always be ready to 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 ETL-Informatica experience using variety of Databases. Oracle is a MUST
Responsible for extracting data from various sources, transforming the data as required, and loading it to various target (ETL) database(s) and/or structures
Work experience in Power Exchange and handling mainframe files is a MUST
Analyze and review complex object and data models and the metadata repository in order to structure processes and data for accuracy, efficiency, and maintainability
Act as SME to team in the plan, design, and delivery of BI and Data Warehouse solutions
Advice 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.
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

Responsibilities

Analyzes, defines and documents detailed REST API requirements through user interviews, facilitated
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
Always be ready to 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