Job Title:  Consulting-SA&MA-Analytics and Cognitive-Snowflake.

Job requisition ID ::  24005
Date:  May 6, 2022
Location:  Bengaluru
Designation:  Consultant
Entity: 

Location- PAN India-Deloitte

 

What impact will you make?

 

Every day, your work will make an impact that matters, while you thrive in a dynamic culture of inclusion, collaboration and high performance. As the undisputed leader in professional services, Deloitte is where you will find unrivaled opportunities to succeed and realize your full potential

 

Deloitte is where you will find unrivaled opportunities to succeed and realize your full potential.

 

The Team
 

Deloitte’s SA&MA- Analytics & Cognitive practice can help you uncover and unlock the value buried deep inside vast amounts of data. Our global network provides strategic guidance and implementation services to help companies manage data from disparate sources and convert it into accurate, actionable information that can support fact-driven decision-making and generate an insight-driven advantage. Our practice addresses the continuum of opportunities in business intelligence & visualization, data management, performance management and next-generation analytics and technologies, including big data, cloud, cognitive and machine learning.

Learn more about Analytics and Information Management Practice

 

Work you’ll do

 

As a Consultant/Senior Consultant in our Consulting team, you’ll build and nurture positive working relationships with teams and clients with the intention to exceed client expectations. You’ll:

 

  • Design, develop and maintain the data architecture, data models and standards for various Data Integration & Data warehouse projects in Snowflake.
  • Ensure new features and subject areas are modelled to integrate with existing structures and provide a consistent view.
  • Leverage your experience working with data warehousing technologies to deploy solutions to solve client business problems
  • Contribute to project teams and work with all stakeholders responsible for all stages of design and development for complex products and platforms, including solution design, analysis, coding, testing, and integration.
  • Produce high-quality code resulting from knowledge of the latest frameworks, code peer review, and automated unit test scripts
  • Collaborate with other developers and team members
  • Participate in product design meetings, daily standups, backlog grooming
  • Develop and document unit tests and execute all processes and procedures in assigned areas of responsibility.

 

 

Qualifications

 

Data Architect

 

  • Must have total 3+ years' experience working as a snowflake Data Architect and 5+ years in Data warehouse, ETL, BI projects.
  • Must have experience at least two end-to-end implementation of Snowflake cloud data warehouse and 3 end to end data warehouse implementations on-premise or cloud.
  • Expertise in Snowflake - data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts
  • Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, zero copy clone, time travel and understand how to use these features.
  • Certified Snowflake cloud data warehouse Architect (Desirable).
  • Train and coach members of project groups to ensure effective knowledge management and planning for contingencies.
  • Participates as a team member and fosters teamwork.
  • Should be able to troubleshoot problems across infrastructure, platform and application domains.
  • Provide direction on adoption of Cloud technologies (Snowflake) and industry best practices in the field of data warehouse architecture and modelling.

 

 

Data Engineer

  • At least 2 years’ experience working as snowflake developer.
  • Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python
  • Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
  • Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling)
  • Experience with data security and data access controls and design
  • Experience with AWS or Azure data storage and management technologies such as S3 and ADLS
  • Familiar with RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshooting.
  • Resolve technical issues of projects and explore alternate designs
  • Effectively collaborate and communicate with the stakeholders and ensure client satisfaction
  • Develop and maintain documentation of the data architecture, data flow and data models of the data warehouse appropriate for various audiences.

 

 

Your role as a leader

 

At Deloitte India, we believe in the importance of leadership at all levels. We expect our people to embrace and live our purpose by challenging themselves to identify issues that are most important for our clients, our people, and for society and make an impact that matters.

 

In addition to living our purpose, Senior Consultant across our organization:

 

  • Develop high-performing people and teams through challenging and meaningful opportunities
  • Deliver exceptional client service; maximize results and drive high performance from people while fostering collaboration across businesses and borders
  • Influence clients, teams, and individuals positively, leading by example and establishing confident relationships with increasingly senior people
  • Understand key objectives for clients and Deloitte; align people to objectives and set priorities and direction.
  • Acts as a role model, embracing and living our purpose and values, and recognizing others for the impact they make

 

How you will grow

 

At Deloitte, our professional development plan focuses on helping people at every level of their career to identify and use their strengths to do their best work every day. From entry-level employees to senior leaders, we believe there is always room to learn. We offer opportunities to help build excellent skills in addition to hands-on experience in the global, fast-changing business world. From on-the-job learning experiences to formal development programs at Deloitte University, our professionals have a variety of opportunities to continue to grow throughout their career. Explore Deloitte University, The Leadership Centre.

 

Benefits

At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Learn more about what working at Deloitte can mean for you.

 

Our purpose                                                                                                                

                                                                                                                

Deloitte is led by a purpose: To make an impact that matters.

 

Every day, Deloitte people are making a real impact in the places they live and work. We pride ourselves on doing not only what is good for clients, but also what is good for our people and the

 

Communities in which we live and work—always striving to be an organization that is held up as a role model of quality, integrity, and positive change. Learn more about Deloitte's impact on the world

 

Recruiter tips

We want job seekers exploring opportunities at Deloitte to feel prepared and confident. To help you with your interview, we suggest that you do your research: know some background about the organization and the business area you are applying to. Check out recruiting tips from Deloitte professionals.