Ab Initio Developer

Position Description

Founded in 1976, CGI is among the largest independent IT and business consulting services firms in the world. With 94,000 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 2024 reported revenue is CA$14.68 billion and CGI shares are listed on the TSX (GIB.A) and the NYSE (GIB). Learn more at cgi.com.

Job Title: Ab Initio Developer

Experience: 5 to 8 Years

#LI-SP40

Location: Hyderabad / Chennai / Bangalore

Position ID : J0626-2066

Seeking an experienced Ab Initio Developer with strong expertise in ETL development, Data Warehousing, SQL/PLSQL, and UNIX Shell Scripting. The candidate will be responsible for designing, developing, optimizing, and supporting large-scale data integration solutions while ensuring data quality, performance, and governance standards.

Your future duties and responsibilities

Ab Initio GDE (Graphical Development Environment)

Ab Initio Co>Operating System

EME (Enterprise Meta Environment)

Ab Initio Plans & Scripts

Parallel Processing Concepts

SQL / PL-SQL

UNIX/Linux Shell Scripting

Data Warehousing Concepts

ETL Development & Support

Performance Tuning

Preferred Skills

Continuous Flows

Oracle / DB2 / SQL Server / PostgreSQL

Control-M / Autosys

AWS / Azure / GCP

Agile/Scrum Methodology

Metadata Management

Data Governance

Roles & Responsibilities

ETL Development

Design, develop, test, and deploy Ab Initio graphs and reusable components.

Develop and maintain EME projects, sandboxes, and metadata repositories.

Build scalable ETL solutions for large-volume data processing.

Conduct code reviews and ensure adherence to development standards.

Performance Optimization

Optimize Ab Initio graphs for throughput and resource utilization.

Tune SQL queries, stored procedures, and database operations.

Identify and resolve ETL and database performance bottlenecks.

Support production performance tuning activities.

Data Quality & Governance

Ensure data accuracy, consistency, and integrity.

Implement validation, reconciliation, and error-handling mechanisms.

Support enterprise metadata management and governance initiatives.

Ensure compliance with data standards and policies.

Production Support

Investigate and resolve ETL failures and data issues.

Perform root cause analysis for production incidents.

Participate in release deployments and post-production validation.

Provide preventive solutions for recurring issues.

Required qualifications to be successful in this role

4–8 years of experience in Ab Initio development.

Strong understanding of Data Warehousing and ETL concepts.

Advanced SQL and database performance tuning skills.

Hands-on experience with UNIX/Linux scripting.

Experience working in large-scale enterprise data environments.

Domain Experience (Preferred)

Banking & Financial Services

Healthcare

Insurance

Together, as owners, let’s turn meaningful insights into action.

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.

That same commitment to fairness extends to how we use technology. To support our recruitment team, AI tools may be used to help assess applications though they never replace human judgement. All hiring decisions remain entirely in the hands of our recruitment professionals.

Come join our team - one of the largest IT and business consulting services firms in the world.