SNOWFLAKE CONSULTING ARCHITECT15-18 YRSPUNE/BANGALORE/HYDERABADWhat'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. You would be guiding customers on setting up data & analytics platform for their business requirements, advise on next best technologies and help them plan next set of solutions and services to create value for their business users and end customers.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:· Collaborate with clients to understand their business objectives and challenges and provide data-driven solutions.· Design and implement end-to-end data architecture solutions, considering scalability, performance, and security requirements.· Conduct data assessments and develop strategies for data management, integration, and analytics.· Lead and mentor a team of data professionals, providing guidance on best practices and industry standards.· Responding to client RFI, RFP documents with proper solution design including cost estimates. Provide technical expertise and support during the pre-sales process, including proposal development and client presentations.· Stay updated on industry trends and advancements in data architecture and analytics.· Contributing to SoWs, technical project roadmaps, etc required for successful execution of projects leveraging Technical Scoping & Solutioning approach· Planning end to end technical scope of the project and customer engagement area including planning sprint and deliverySkills required to contribute:15+ Years of experience in Data and Analytics experience with minimum 7-8 years in Snowflake and 2-3 years in one of cloud platforms like Azure or AWS1. Proven experience as a Data Architect, with a focus on consulting and solution design.2. Extensive experience in Cloud Data stack from consulting, setting up data platform, rearchitecting or refactoring data platform to cloud native services along with industry leading tools/products, Strong expertise in data modeling, database design, and ETL processes.3. Excellent communication and presentation skills.4. 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.5. 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 procedures6. 6+ Years of experience in Informatica 10.x & above / IICS 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)7. Minimum 2 data lake & EDW implementations using Azure/AWS/GCP Cloud Data native services along with Snowflake cloud data warehouse.8. Design and build production data pipelines from ingestion to consumption within a big data architecture, using Java, Python, Scala.9. Well versed with Waterfall, Agile, Scrum and similar project delivery methodologies.10. Experienced in internal as well as external stakeholder management11. Familiarity with data science and machine learning concepts is a plus.12. Exposure to various data visualization tools (e.g. Tableau, Power BI etc)13. Experience in MDM / DQM / Data Governance technologies like Collibra, Atacama, Alation, Reltio will be added advantage.14. 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 recommendations and best practices for application development, platform development, and developer tools· Actively stay abreast on industry best practices, share learnings, and experiment and apply cutting edge technologies· 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 ZensarWe 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 origin, citizen status, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veterans’ status.Zensar is a place where you are free to express yourself in an environment that values individuality, nurtures development and is mindful of wellbeing. We put our people and customers at the center of everything that we do. Our core values include:• Putting people first• Client-centricity• Collaboration Grow. Own. Achieve. Learn. with Zensar: /watch?v=i2NZsiQqVnU Visit to know more.Ready to think velocity?Put in details of how you want the candidate to apply. Add links to the portals, mention email ID. Can we also have links to a process guide, that we can direct the candidate to?
Job Title
Data Architect (Snowflake)