CoreHRx Jobs

Apply in one click, save jobs and take free mock tests.

Register free Log in
Hiring? Post jobs with CoreHRx
My account
user

View & update profile

Lead Architect – Snowflake

CGI

Full time
Experience
3+ years
Location
India
Work mode
Not stated
Salary
₹11L – ₹25L a year estimatetypical for IT Jobs in India, 824 posts
Posted 9 days ago

Free · takes a minute · your resume fills your profile

CoreHRx never asks candidates for money. If anyone does, .

Role at a glance

You will
  • Define Snowflake architecture and solution designs based on business, data, security, and operational requirements.
  • Lead the design of data platforms, including data ingestion, transformation, storage, integration, and consumption patterns.
  • Establish standards for data modeling, naming, development, testing, deployment, and platform operations.
Experience
3+ years
Education
Bachelor's degree
Must-have skills
Data ModelingETLSQLSnowflake

How well do your skills match this job?

Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.

Job description

Position Description:

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: Lead Architect
Position: Lead Architect
Experience: 15+
Category: Infrastructure
Shift: Timing/rotation etc. details
Main location: Bangalore
Position ID: J1026-2284
Employment Type: Full Time

Education Qualification: Bachelor’s degree in computer science or related field or higher with minimum 3 years of relevant experience.

Lead the architecture, design, and implementation of Snowflake based data solutions. The role will guide technical teams and stakeholders through solution design, establish delivery standards, and ensure that the data platform is secure, scalable, well governed, and cost effective.
Key responsibilities

. Define Snowflake architecture and solution designs based on business, data, security, and operational requirements.
. Lead the design of data platforms, including data ingestion, transformation, storage, integration, and consumption patterns.
. Establish standards for data modeling, naming, development, testing, deployment, and platform operations.
. Advise on Snowflake features and approaches for workload management, performance, scalability, availability, and cost optimization.
. Design security and governance controls, including role based access, data classification, masking, and auditability.
. Guide the selection and integration of ETL/ELT, orchestration, BI, and cloud services.
. Review solution designs and code, resolve complex technical issues, and support implementation and production readiness.
. Lead technical discussions with business stakeholders, client teams, and delivery partners; translate requirements into practical solutions.
. Mentor developers and consultants and promote consistent engineering practices.
. Contribute to estimates, technical proposals, roadmaps, and delivery plans.

Required skills and experience

. Strong experience architecting, designing, and implementing Snowflake solutions.
. Deep knowledge of Snowflake architecture, SQL, data modeling, data integration, and performance tuning.
. Experience designing enterprise scale data platforms and migration or modernization solutions.
. Strong understanding of data security, access management, governance, and operational controls.
. Experience leading technical teams and engaging with senior business and technology stakeholders.
. Ability to explain architectural decisions clearly and balance business needs with technical considerations.

Preferred

. Experience in banking, financial services, or the credit union sector.
. Knowledge of financial data domains such as deposits, lending, cards, payments, customer data, risk, or regulatory reporting.
. Familiarity with banking security, privacy, audit, and data retention requirements.
. Experience with cloud platforms and common data integration, orchestration, and analytics tools.

Skills:

  • Snowflake
  • Technical Architecture
  • ETL
  • Physical Data Modelling
  • Security Analysis

What you can expect from us:

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.

Key skills

Required

Data ModelingETLSQLSnowflake

Preferred

Regulatory Reporting

Job market insights

641active Data Modeling jobs in India
633active ETL jobs in India
3,310active SQL jobs in India
₹11L – ₹25L advertised yearly salary for IT Jobs in India (middle half of 824 posts that show a salary; median ₹17L)
41 more open jobs at CGI

Jobs asking for Data Modeling in India also ask for

  • SQL60%
  • Python49%
  • AWS33%
  • CI/CD32%
  • ETL31%

From live job posts on CoreHRx, updated 12 Nov 2026. Skill figures count posts that list their skills; salary figures only posts that show a salary.

Questions about this job

What is the salary for this Lead Architect – Snowflake job?

The post does not state the pay. As an estimate, comparable posts on CoreHRx advertise ₹11L – ₹25L a year (typical for IT Jobs in India, 824 posts).

How much experience does this job need?

The post asks for 3 Yrs experience.

What kind of job is this?

It is a full time job.

This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.

Questions you may be asked

  1. What is the difference between WHERE and HAVING?
  2. What is the difference between DELETE, TRUNCATE and DROP?
  3. What is the difference between an INNER JOIN and a LEFT JOIN?
  4. What is the difference between a primary key and a unique key?

Get IT jobs by email

Create a free profile and we email you new IT jobs, at most once a week.

Similar jobs

Free · takes a minute · your resume fills your profile