AmbitionBox
Search
Jobs
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
All Filters
140 Merck Jobs
Snowflake Solution Architect
Merck
posted 13hr ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
The Snowflake Solution Architect takes ownership to collaborate with data architects, analysts, and stakeholders to design optimal and scalable data solutions leveraging the Snowflake platform.
This position aims to enhance team effectiveness through high-quality and timely contributions while primarily adhering to standardized procedures and practices to achieve objectives and meet deadlines, exercising discretion in problem-solving.
This role will be based in Bangalore India, and reporting to the Head of SAC Snowflake Engineering.
This position aims to enhance team effectiveness through high-quality and timely contributions while primarily adhering to standardized procedures and practices to achieve objectives and meet deadlines, exercising discretion in problem-solving.
This role will be based in Bangalore India, and reporting to the Head of SAC Snowflake Engineering.
- Design, develop, and maintain sophisticated data pipelines and ETL processes within Snowflake
- Craft efficient and optimized SQL queries for seamless data extraction, transformation, and loading
- Leverage Python for advanced data processing, automation tasks, and integration with various systems
- Implement and manage data modelling techniques, including OLTP, OLAP, and Data Vault 2
- 0 methodologies
- Oversee and optimize CI/CD pipelines using Azure DevOps to ensure smooth deployment of data solutions
- Uphold data quality, integrity, and compliance throughout the data lifecycle
- Troubleshoot, optimize, and enhance existing data processes and queries to boost performance
- Document data models, processes, and workflows clearly for future reference and knowledge sharing
- Employ advanced performance tuning techniques in Snowflake to optimize query performance and minimize data processing time
- Develop and maintain DBT models, macros, and tests for efficient data transformation management in Snowflake
- Manage version control using Git repositories, facilitating seamless code management and collaboration
- Design, implement, and maintain automated CI/CD pipelines using Azure DevOps for Snowflake and DBT deployment processes
-
Who You Are:Hold a Bachelor s or Master s degree in Computer Science, Information Technology, or a related field - A minimum of 5-7 years of proven experience as a Snowflake developer/architect or in a similar data engineering role
- Extensive hands-on experience with SQL and Python, showcasing proficiency in data manipulation and analysis
- Significant industry experiences working with DBT (Data Build Tool) for data transformation
- Strong familiarity with CI/CD pipelines, preferably in Azure DevOps
- Deep understanding of data modelling techniques (OLTP, OLAP, DBT, Data Vault 2
- 0) and best practices
- Experience with large datasets and performance tuning in Snowflake
- Knowledge of data governance, data security best practices, and compliance standards
- Familiarity with additional data technologies (eg, AWS, Azure, GCP, Five Tran) is a plus
- Experience in leading projects or mentoring junior developers is advantageous
Employment Type: Full Time, Permanent
Read full job descriptionPrepare for Solution Architect roles with real interview advice
Top Merck Solution Architect Interview Questions
Q1. proc report/ which argument should be used to modify variables
asked in
Statistical Programmer interview
Q2. What is the difference between where and if
asked in
Statistical Programmer interview
Q3. what is proc transpose/ what does the by do
asked in
Statistical Programmer interview
What people at Merck are saying
Solution Architect salary at Merck
reported by
5
employees
with 10-14
years exp.
₹21
L/yr - ₹38
L/yr
8%
less
than the average Solution Architect Salary in India
View more details
What Merck employees are saying about work life
based on 311 employees
Flexible timing
Monday to Friday
Within city
Day Shift
Merck Benefits
View more benefits
Compare Merck with
Pfizer
Compare
GlaxoSmithKline Pharmaceuticals
Compare
Novartis
Compare
Johnson & Johnson
Compare
Sanofi
Compare
Bayer
Compare
Eli Lilly and Company
Compare
Abbott
Compare
Bristol-Myers Squibb
Compare
AstraZeneca
Compare
Hetero
Compare
Viatris
Compare
Micro Labs
Compare
Biological E
Compare
Granules India
Compare
Piramal Pharma
Compare
Novo Nordisk
Compare
Teva Pharmaceuticals
Compare
Otsuka Pharmaceutical India Private Limited
Compare
Par Pharmaceutical Companies
Compare
Similar Jobs for you
Share an Interview