Snowflake + Dbt

**Snowflake + DBT**
**-**
**(**
**0090489**
**)**

**Description**

SNOWFLAKE ARCHITECT

12-15 YRS

PUNE/BANGALORE/HYDERABAD

What's this role about?

As a Snowflake Data Architect, you will be responsible for providing advisory and thought leadership on migration to Snowflake or implementing data solutions using Snowflake Cloud services including integration with existing data and analytics platforms and tools. You will contribute in pre-sales and design, implement scalable data architectures, and information solutions covering data security, data privacy, data governance, metadata management, multi-tenancy and mixed workload management, and provide delivery oversight.

Here's how you'll contribute:
Snowflake Architect at Zensar participates in end to end cycle from opportunity identification to its closure and takes up complete ownerships of project execution and provide valuable expertise in the project. You will do this by:

- Responding to client RFI, RFP documents with proper solution design including cost estimates- Understanding customer requirements and create technical proposition- Contributing to SoWs, technical project roadmaps, etc required for successful execution of projects leveraging Technical Scoping & Solutioning approach- Managing and owning all aspects of technical development and delivery- Understanding requirements and writing technical documents- Ensuring code review and developing best practises- Planning end to end technical scope of the project and customer engagement area including planning sprint and delivery- Estimating effort, identifying risk and providing technical support whenever needed- Demonstrating the ability to multitask and re prioritizing responsibility based on dynamic requirements- Leading and mentoring teams as neededSkills required to contribute:
12-15 Years of Data and Analytics experience with minimum 5+ years in Snowflake Cloud Data warehousing- Excellent communication and presentation skills.-
- Extensive experience in Snowflake - Virtual warehouse (Compute), Data modeling & storage including LDM/PDM design, data loading/unloading and data sharing, SnowSQL (CLI) as well as Snowflake Internals and integrations, SnowPipe implementation, S3 Internal data copy/movement, Snowflake security including readers and consumers accounts.-
- Advance SQL knowledge and hands on experience on complex queries writing using with Analytical functions, Troubleshooting, problem solving and performance tuning of SQL queries accessing data warehouse as well as Strong knowledge on stored procedures-
- 6+ Years of experience in Informatica 10.x & above with all modules including ETL design & development and troubleshooting / debugging, Repository Manager, Strong experience in Informatica Mapping Designer (Mapping & Mapplets creations using all Transformations) and Workflow Designer (Session & Task implementation and Job scheduling)-
- Minimum 2 data lake & EDW implementations using Azure/AWS/GCP Cloud Data native services along with Snowflake cloud data warehouse.-
- Design and build production data pipelines from ingestion to consumption within a big data architecture, using Java, Python, Scala.-
- Good experience in Requirements Analysis and Solution Architecture Design, Data modelling, ETL, data integration and data migration design-
- Well versed with Waterfall, Agile, Scrum and similar project delivery methodologies.-
- Experienced in internal as well as external stakeholder management-
- Experience in MDM / DQM / Data Governance technologies like Collibra, Atacama, Alation, Reltio will be added advantage.-
- SnowPro-Core / SnowPro-Advanced certification will be added advantage.How we’d like you to lead:
Take part in and host regular knowledge sharing sessions, mentor more junior members of the team and support the continuous development of our practice.

We also want you to:

- Share project stories with the wider business.- Provide technical leadership and be a role model/coach to software engineers pursuing technical career path in engineering- Provide/inspire innovations that fuel the growth of Intuit as a whole and generate creative ideas for emerging business needs- Create content to promote your personal brand and Zensar to the world.- Live Zensar's values, both, internally and externallyAdvantage Zensar

We are a technology consulting and services company with 11, 500+ associates in 30+ global locations. More than 145 leading enterprises depend on our expertise to be more disruptive, agile, and competitive. We focus on conceptualizing, designing, engineering, marketing, and managing digital products and experiences for high-growth companies looking to disrupt through innovation and velocity.

Zensar Technologies is an Equal Employment Opportunity (EEO) and Affirmative Action Employer, encouraging diversity in the workplace. Please be assured that we will consider all qualified applicants fairly, regardless of race, creed, color, ancestry, religion, sex, national origi