Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 2K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

Add office photos

Premium Employer

Deloitte

Compare

3.8

based on 17.4k Reviews

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

Top Rated Mega Company - 2024

90 Deloitte Senior Consultant Jobs

Senior Consultant | AWS Glue, Athena, SQL, Python, PySpark

Deloitte Shared Services India Pvt. Ltd

3.8

based on 17.4k Reviews

3-6 years

₹ 9.9 - 37L/yr (AmbitionBox estimate)

Bangalore / Bengaluru

1 vacancy

Senior Consultant | AWS Glue, Athena, SQL, Python, PySpark

Deloitte

posted 5d ago

Job Role Insights

Flexible timing

Key skills for the job

Computer Science Data Analysis Python SQL Financial Services SAP Data Migration

+ 4 more

Job Description

Job Title: Senior Consultant | AWS Glue, Athena, SQL, Python, PySpark | Bengaluru, Hyderabad | Engineering

Job requisition ID :: 76815

Date: Jan 30, 2025

Location: Bengaluru

Designation: Senior Consultant

Entity:

Data Engineer

T he position is suited for individuals who have the ability to work in a constantly challenging environment and deliver effectively and efficiently. As a Data Engineer, you will be an integral member of our Data & Analytics team responsible for design and development of pipelines using cutting edge technologies.

Key Responsibilities -

Data Modeling: Create and maintain conceptual, logical, and physical data models that accurately represent the organizations data assets. These models may include entity-relationship diagrams (ERDs), data flow diagrams, and schema designs.

Requirements Gathering: Collaborate with business analysts, data analysts, and other stakeholders to understand their data needs and requirements. Translate these requirements into data model specifications.

Data Standardization: Define and enforce data standards, naming conventions, and data definitions to ensure consistency and clarity across the organization.

Database Design: Work closely with database administrators (DBAs) to design and optimize database schemas based on the data models. Ensure that databases are efficient, scalable, and well-structured.

Data Integration: Facilitate the integration of data from various sources into the organizations data environment. Ensure that data is transformed and mapped appropriately to meet business needs.

Data Governance: Participate in data governance initiatives by establishing data quality rules, data lineage, and data ownership guidelines. Monitor and enforce data governance policies.

Documentation: Maintain comprehensive documentation of data models, data dictionaries, and metadata. Ensure that all changes to data models are properly documented and communicated.

Performance Optimization: Collaborate with developers and DBAs to optimize database performance. Identify and resolve performance bottlenecks related to data access and storage.

Data Security: Implement data security measures to protect sensitive and confidential data. Define access controls and data encryption strategies as needed.

Data Analysis Support: Support data analysts and data scientists by providing well-structured data models that facilitate data analysis and reporting.

Data Migration: Assist in data migration projects by ensuring that data models are consistent between source and target systems. Verify data integrity during migration.

Professionals should possess a clear understanding of current data models

Should be able to clearly articulate end-to-end data pipelines with analysis and accomplishment.

Implementing data pipelines and ETL processes within AWS

Must possess the ability to construct data pipelines utilizing Glue and allocate cloud resources.

Should be capable of conducting data analysis, executing data quality checks, and rectifying data quality problems in collaboration with business stakeholders or Product Owners

Required to adhere to leading practices to design pipelines in line with industry standards

Will be collaborating with key stakeholders to address critical issues as they arise.

Qualifications

3-10 years of proficient experience with AWS ETLs, Glue, EMR, S3 & Athena
Expert in languages e.g., Python, Pyspark
Advanced knowledge of database management systems SQL
Excellent problem-solving and analytical skills.
Strong communication and collaboration skills to work with cross-functional teams.
Experience with version control practices and CICD Process (Git, Bamboo, etc.)
Understanding of Financial Services Industry- IMRE (preferred)

Primary Skills:

AWS Glue

Athena

SQL

Python

PySpark

Soft Skills:

Strong leadership, communication, and problem-solving abilities.

Ability to work collaboratively with cross-functional teams.

Flexibility to meet critical deadlines as needed.

Preferred Qualifications:

Bachelor s degree in computer science, Information Systems, or a related field

Certification in related technologies is desirable.

Experience/Willingness working in Support Role

Job Locations:

Hyderabad, Bangalore

Employment Type: Full Time, Permanent

Read full job description

Deloitte Interview Questions & Tips

Prepare for Deloitte Senior Consultant roles with real interview advice

What Senior Consultant at Deloitte are saying

3.8

Rating based on 1.4k Senior Consultant reviews

Anonymous · Risk Management & Compliance in Gurgaon / Gurugram

Likes

Great brand to work for. Employee friendly policies with great benefits. Focus on learning and upskilling. Provides opportunities to explore new work areas. Some good leaders who are also mentors

Salary - Excellent

+6 more

Dislikes

You're responsible for your own career here. People will guide you but you will have to take ownership and create a rapport with the leadership. May not suit everyone's working style. Also, work can sometimes become monotonous.

Read 1.4k Senior Consultant reviews