ETL Developer (Informatica)

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., 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, 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

Minimum 6+ years of ETL-Informatica experience using variety of Databases. Oracle is a MUST., Strong Collaboration and communication skills within distributed project teams and in Agile environment.

. Excellent Oral and Written Communication Skills., * Informatica

• Oracle
• SQL

CGI is required by law in some jurisdictions to include a reasonable estimate of the compensation range for this role. The determination of this range includes various factors not limited to skill set, level, experience, relevant training, and licensure and certifications. To support the ability to reward for merit-based performance, CGI typically does not hire individuals at or near the top of the range for their role. Compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range for this role in the U.S. is $78,400.00 - $173,500.00.

CGI's benefits are offered to eligible professionals on their first day of employment to include:

. 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

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., 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.