Job Title:  Consulting - SAMA - Data & Analytics - Pl/SQL - Consultant

Job requisition ID ::  10867
Date:  Nov 24, 2021
Location:  Bengaluru
Designation:  Consultant
Entity:  Deloitte Touche Tohmatsu India LLP


Designation – Consultant


Job Location: Pune/Mumbai/Bengaluru/Chennai/Gurgaon/Hyderabad/Kolkata



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 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 deploy data lake solutions using different tools, design principles and conventions
  • Leverage your experience working with AWS/Azure/GCP/Snowflake 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




Must Have

  • Education Qualification: BE/B Tech/ MCA.
  • 2-5 years of specific technical experience working with PL SQL and SQL.
  • Experienced PL SQL Developer with project delivery experience for at least 2 years and database skill is required
  • Proficiency in oracle database, procedures, functions, triggers, performance tuning and query optimization is a must.
  • Development Proficiency in data modelling and database design is added advantage.
  • Exposure to performance tuning and SQL tuning of large database environments.
  • Ability to work both independently and as a team member.
  • Understand SDLC process and tools, agile program management concepts and version
  • Strong analytical and problem-solving skills.
  • Excellent written and verbal communication skills


Nice to have:

  • Knowledge in one of ETL tools - Informatica or SSIS.
  • Thorough Understanding of Data Warehousing Concepts like Facts, aggregated facts, history preserving facts, dimension, junk dimensions, SCD type 1, 2,3
  • Understanding of various data modelling concepts – 1 NF, 2 NF, 3 NF, Star, Snowflake
  • Understanding of ODS and Data marts


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, 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.



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.