Your browser does not support javascript! Please enable it, otherwise web will not work for you.

Data Architect @ CGI

Home > DBA / Data warehousing

 Data Architect

Job Description

Position Description:

Qualification:

  • Bachelors or Masters degree in Computer Science, Engineering, or a related field
  • 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.

Skills:
  • Application Development
  • Applications Administration
  • Database

Job Classification

Industry: IT Services & Consulting
Functional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: Data warehouse Architect / Consultant
Employement Type: Full time

Contact Details:

Company: CGI
Location(s): Hyderabad

+ View Contactajax loader


Keyskills:   Informatica rds snowflake azure sql software development data migration sql star schema aws rds database design query optimization automation data modeling gcp devops aws azure

 Fraud Alert to job seekers!

₹ Not Disclosed

Similar positions

Oracle DBA+Exadata Professional

  • Capgemini
  • 6 - 11 years
  • Hyderabad
  • 2 days ago
₹ Not Disclosed

Data Platform Architect

  • Accenture
  • 10 - 12 years
  • Bengaluru
  • 2 days ago
₹ Not Disclosed

Data Architect

  • Accenture
  • 12 - 17 years
  • Bengaluru
  • 2 days ago
₹ Not Disclosed

Data Architect

  • Accenture
  • 15 - 20 years
  • Chennai
  • 8 days ago
₹ Not Disclosed

CGI

\n\n The Muthoot Group is one of Indias largest multi-diversified business conglomerates having 20 diversified business divisions with 800 years of family business legacy, 800 years of Charity, 800 years of religious work and 800 years of financial inclusion. The Group serves over 2.5 lakh customers...