Software Engineer - ETL Developer

Position Description: Company Profile: Founded in , CGI is among the largest independent IT and business consulting services firms in the world. With 94, consultants and professionals across the globe, CGI delivers an end-to-end portfolio of capabilities, from strategic IT and business consulting to systems integration, managed IT and business process services and intellectual property solutions. CGI works with clients through a local relationship model complemented by a global delivery network that helps clients digitally transform their organizations and accelerate results.

CGI Fiscal reported revenue is CA$14.68 billion and CGI shares are listed on the TSX (GIB.A) and the NYSE (GIB). Learn more at . Job Title: ETL Developer Position: Software Engineer Experience: 3 - 5 Years Category: Software Development/ Engineering Main location: Hyderabad Position ID: J- Employment Type: Full Time Your future duties and responsibilities: .

Design, develop, and maintain ETL workflows and mappings using Informatica PowerCenter and PowerExchange. . Develop complex PL/SQL procedures, functions, packages, and triggers to support data integration and transformation. . Integrate and process data from multiple sources including Oracle, MongoDB, SQL Server, and DB2 (Mainframe). .

Handle and process mainframe datasets/files (VSAM, flat files, etc.) as part of ETL pipelines. . Optimize ETL jobs and SQL queries for performance and scalability. . Perform data validation, data quality checks, and reconciliation between source and target systems.

Primary Technical Skills . ETL Tools: Informatica PowerCenter, Informatica PowerExchange . Database Development: Oracle PL/SQL .

Databases: Oracle, MongoDB, SQL Server, DB2 (Mainframe) . Data Integration: Handling mainframe files and datasets . SQL Development: Advanced SQL, query tuning, performance optimization Secondary Skills .

Knowledge of mainframe data structures and file handling . Experience with data migration and data warehousing concepts . Familiarity with batch processing and scheduling tools .

Exposure to data quality frameworks and reconciliation processes Required qualifications to be successful in this role: We are seeking a Mid Level ETL & PL/SQL Developer with strong expertise in ETL development, database programming, and data integration across multiple platforms including Oracle, MongoDB, SQL Server, and DB2 (Mainframe). Skills: English ETL MongoDB Oracle Postgre SQL PowerCenter SQLite