Snowflake - Senior Technical Lead
__jobinformationwidget.freetext.LocationText__
Noida, Uttar Pradesh, India
- Sopra Steria
- Engineering, Development, Applications
- 6 to 10 years
- Standard
- Noida, Uttar Pradesh
- All Sectors
- English
- No
About Sopra Steria
Sopra Steria, a major Tech player in Europe with 50,000 employees in nearly 30 countries, is recognised for its consulting, digital services and solutions. It helps its clients drive their digital transformation and obtain tangible and sustainable benefits. The Group provides end-to-end solutions to make large companies and organisations more competitive by combining in-depth knowledge of a wide range of business sectors and innovative technologies with a collaborative approach. Sopra Steria places people at the heart of everything it does and is committed to putting digital to work for its clients in order to build a positive future for all. In 2024, the Group generated revenues of €5.8 billion.
The world is how we shape it.
Position: Snowflake - Senior Technical Lead
Experience: 8-11 years
Location: Noida/ Bangalore
Education: B.E./ B.Tech./ MCA
Primary Skills: Snowflake, Snowpipe, SQL, Data Modelling, DV 2.0, Data Quality, AWS, Snowflake Security
Good to have Skills: Snowpark, Data Build Tool, Finance Domain
- Experience with Snowflake-specific features: Snowpipe, Streams & Tasks, Secure Data Sharing.
- Experience in data warehousing, with at least 2 years focused on Snowflake.
- Hands-on expertise in SQL, Snowflake scripting (JavaScript UDFs), and Snowflake administration.
- Proven experience with ETL/ELT tools (e.g., dbt, Informatica, Talend, Matillion) and orchestration frameworks.
- Deep knowledge of data modeling techniques (star schema, data vault) and performance tuning.
- Familiarity with data security, compliance requirements, and governance best practices.
- Experience in Python, Scala, or Java for Snowpark development is good to have.
- Strong understanding of cloud platforms (AWS, Azure, or GCP) and related services (S3, ADLS, IAM)
Key Responsibilities
- Define data partitioning, clustering, and micro-partition strategies to optimize performance and cost.
- Lead the implementation of ETL/ELT processes using Snowflake features (Streams, Tasks, Snowpipe).
- Automate schema migrations, deployments, and pipeline orchestration (e.g., with dbt, Airflow, or Matillion).
- Monitor query performance and resource utilization; tune warehouses, caching, and clustering.
- Implement workload isolation (multi-cluster warehouses, resource monitors) for concurrent workloads.
- Define and enforce role-based access control (RBAC), masking policies, and object tagging.
- Ensure data encryption, compliance (e.g., GDPR, HIPAA), and audit logging are correctly configured.
- Establish best practices for dimensional modeling, data vault architecture, and data quality.
- Create and maintain data dictionaries, lineage documentation, and governance standards.
- Partner with business analysts and data scientists to understand requirements and deliver analytics-ready datasets.
- Stay current with Snowflake feature releases (e.g., Snowpark, Native Apps) and propose adoption strategies.
- Contribute to the long-term data platform roadmap and cloud cost-optimization initiatives.
BTech/MCA
At our organization, we are committed to fighting against all forms of discrimination. We foster a work environment that is inclusive and respectful of all differences.
All of our positions are open to people with disabilities.
Discover what working at Sopra Steria looks like...
Are you looking for a place where you can free your creativity and take initiatives, supported by tech experts?
Join us on this adventure where every idea counts and every talent steps up.
Job offers that might interest you
Salary
Location
Noida, Uttar Pradesh, India
Vacancy language
English
Job Type
Standard
Experience Level
6 to 10 years
Department
Engineering, Development, Applications
Brand
Sopra Steria
Sector
All Sectors
Remote
No
Location
Noida, Uttar Pradesh
Description
8+ years design/implementation/consulting/S4H Migration experience with SAP Production planning/Quality Management. Must have Multiple S4Hana Public Cloud in SAP - PP Module Should have worked in at l
Reference
0e0c5057-5b15-4b97-8e15-65e9977be82f
Expiry Date
Jan 1, 0001
Salary
Location
Noida, Uttar Pradesh, India
Vacancy language
English
Job Type
Standard
Experience Level
6 to 10 years
Department
Engineering, Development, Applications
Brand
Sopra Steria
Sector
All Sectors
Remote
No
Location
Noida, Uttar Pradesh
Description
Key technological skills: Java 11+, J2EE, Spring-boot, Docker, PostgreSQL, MongoDB, Hazelcast/Redis, REST, OAuth2.0, JWT, Angular, JSON, XML. Key Responsibilities Develop software solutions by unders
Reference
acdfd768-3f3f-493b-ae5c-4793ad5bd40d
Expiry Date
Jan 1, 0001
Salary
Location
Noida, Uttar Pradesh, India
Vacancy language
English
Job Type
Standard
Experience Level
6 to 10 years
Department
Engineering, Development, Applications
Brand
Sopra Steria
Sector
All Sectors
Remote
No
Location
Noida, Uttar Pradesh
Description
Experience: 6yr to 8yr Work Location: Noida / Bangalore Mode of work: Hybrid (3 days office every week) Strong SAP technology experience in multiple business and technical processes Profound ABAP d
Reference
235dc779-95e6-4f9d-8f27-7dd33d18369e
Expiry Date
Jan 1, 0001
Salary
Location
Noida, Uttar Pradesh, India
Vacancy language
English
Job Type
Standard
Experience Level
6 to 10 years
Department
Engineering, Development, Applications
Brand
Sopra Steria
Sector
All Sectors
Remote
No
Location
Noida, Uttar Pradesh
Description
Mandatory: Technical Autonomous with one programming language/scripting· Autonomous with one Database. Good understanding of SQL queries· Autonomous with
Reference
347b5a88-2cdd-4a43-968e-dc81715a61ce
Expiry Date
Jan 1, 0001
Salary
Location
Noida, Uttar Pradesh, India
Vacancy language
English
Job Type
Standard
Experience Level
6 to 10 years
Department
Engineering, Development, Applications
Brand
Sopra Steria
Sector
All Sectors
Remote
No
Location
Noida, Uttar Pradesh
Description
Responsibilities: Design and implement cloud and hybrid (mix of cloud and on-premises) based infrastructure solutions that includes both virtualized compute and storage. Design and implement high avai
Reference
8a22a284-430e-4486-b934-40469bccc2ac
Expiry Date
Jan 1, 0001
Salary
Location
Noida, Uttar Pradesh, India
Vacancy language
English
Job Type
Standard
Experience Level
6 to 10 years
Department
Engineering, Development, Applications
Brand
Sopra Steria
Sector
All Sectors
Remote
No
Location
Noida, Uttar Pradesh
Description
Job Description: Functional Consultant-Avature Experience on Avature / workday / Smart recruiters / Taleo recruitment tools Position Overview: We are seeking a skilled and experienced Avature Functi
Reference
9e3f44b3-c429-4654-aca8-18d05d809fd9
Expiry Date
Jan 1, 0001
Salary
Location
Noida, Uttar Pradesh, India
Vacancy language
English
Job Type
Standard
Experience Level
6 to 10 years
Department
Engineering, Development, Applications
Brand
Sopra Steria
Sector
All Sectors
Remote
No
Location
Noida, Uttar Pradesh
Description
Technical Autonomous with one programming language/scripting· Autonomous with one Database. Good understanding of SQL queries· Autonomous with Unix/Linux/RedHat/CentOS/AIX etc. Operational Flexibil
Reference
7de0f712-dbdb-4fd7-aa45-7ac7383cece3
Expiry Date
Jan 1, 0001
Salary
Location
Noida, Uttar Pradesh, India
Vacancy language
English
Job Type
Standard
Experience Level
6 to 10 years
Department
Engineering, Development, Applications
Brand
Sopra Steria
Sector
All Sectors
Remote
No
Location
Noida, Uttar Pradesh
Description
Job Description: Work Location : Chennai / Noida SAP EWM Functional experience between 8 and 10 years. Minimum 1 E2E implementation & 2 support projects. Work self-directed and independently. Able to
Reference
d5aef09a-9fad-44d7-bca5-b1dd1bcb6f08
Expiry Date
Jan 1, 0001
Salary
Location
Noida, Uttar Pradesh, India
Vacancy language
English
Job Type
Standard
Experience Level
6 to 10 years
Department
Engineering, Development, Applications
Brand
Sopra Steria
Sector
All Sectors
Remote
No
Location
Noida, Uttar Pradesh
Description
Primary Skill: SAP Functional GTS Job Description: 1) SAP GTS consultant(6-10 years of experience) must act as E2E responsible for all GTS Topics (Compliance, Customs, Trade Preference etc.) to prov
Reference
4f23f6e0-f2a7-44a8-a78c-7ee7f22be2b7
Expiry Date
Jan 1, 0001
Salary
Location
Noida, Uttar Pradesh, India
Vacancy language
English
Job Type
Standard
Experience Level
6 to 10 years
Department
Engineering, Development, Applications
Brand
Sopra Steria
Sector
All Sectors
Remote
No
Location
Noida, Uttar Pradesh
Description
· Minimum of 8-10 years of SD experience in full cycle implementation as well as in support projects. · Minimum 2-3 E2E SD Implementation experience. · Knowledge of working experience o
Reference
1c1de706-07b1-4b69-b691-838f350f65d7
Expiry Date
Jan 1, 0001