Data Architect

Position Description:

At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72, professionals located in 40 countries. Founded in , CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve. At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72, professionals located in 40 countries. Founded in , CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us. Learn more at 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:

Data Architect

Experience: 10 to 15 Years
Main location: Bangalore/Chennai/Hyderabad
Employment Type: Full Time

We are seeking a skilled Data Architect with 10+ 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.

#LI-SA19

Skills: