Data modeler

Position Description:

Position Description
Founded in , CGI is among the world's largest independent IT and business consulting services firms. With 94, consultants and professionals globally, 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 .
This is a great opportunity to join a winning team. CGI offers a competitive compensation package with opportunities for growth and professional development. Benefits for full-time, permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans. We wish to thank all applicants for their interest and effort in applying for this position, however, only candidates selected for interviews will be contacted. No unsolicited agency referrals please.

Your future duties and responsibilities:

Job Title: Data Modeler
Position: SE / SSE / Lead Analyst / Associate Consultant
Experience: 6+Yrs
Category: Software Development
Job location: Bangalore
Position ID: J-
Work Type: Hybrid
Employment Type: Full Time / Permanent
Qualification: Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field.


We are seeking a skilled Data modeler with 6+ years of hands-on experience in managing enterprise databases and supporting critical application deployments. The role requires strong expertise in data migration, database object creation (tables, indexes, procedures), performance tuning, and deployment scripting.

Key Responsibilities
· Perform data migration across environments and platforms.
· Develop and maintain conceptual, logical, and physical data models to support business and technical requirements.
· Analyse existing systems and translate business needs into data structures and relationships.·
· Define data standards, naming conventions, and metadata for consistency across the organization. ·
· Ensure models support performance, scalability, and integration requirements. ·
· Design and create database objects such as tables, indexes, stored procedures, and views.
· Optimize queries and perform performance tuning to ensure efficient database operations.
· Prepare and execute deployment scripts for releases and environment refreshes.
· Monitor database health, troubleshoot issues, and ensure availability and reliability.
· Collaborate with development and DevOps teams to support application deployments.

Required Skills
· Strong expertise in data modeling methodologies (3NF, dimensional/star schema, snowflake, etc.).
· Proficiency with data modeling tools (ERwin, ER/Studio, PowerDesigner, or similar).
· Strong SQL knowledge and understanding of RDBMS concepts.
· Proven experience in data migration, performance tuning, and query optimization.
· Strong skills in SQL scripting and automation.
· Hands-on knowledge of backup/recovery tools and deployment processes.
· Good understanding of indexes, partitions, and database design principles.
· Excellent communication and problem-solving skills.

Nice to Have
· Experience with CI/CD pipelines and DevOps-based database deployments.
· Exposure to cloud databases (AWS RDS, Azure SQL, GCP) is a plus.

CGI is an equal opportunity employer. In addition, CGI is committed to providing accommodation for people with disabilities in accordance with provincial legislation. Please let us know if you require reasonable accommodation due to a disability during any aspect of the recruitment process and we will work with you to address your needs.

#LI-GB9

Skills: