Data Architect (Hadoop/ AWS)

Tech Mahindra Limited

Pune District

Hybrid

INR 4,000,000 - 7,000,000

Full time

5 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Tech Mahindra Limited is seeking a senior data warehouse architect with 15–22 years of experience, including at least 10 years as a developer and 5 years as an architect. Pharma industry expertise is a must, with knowledge of relational databases (Oracle, Redshift, Snowflake) and SQL.

Design and implement data warehousing on AWS Redshift, develop big data architectures with Hadoop, optimize queries, and lead cross-functional teams using Agile methods and Jira.

Qualifications

  • 15-22 years of experience in designing and implementing large-scale data warehousing solutions.
  • Strong understanding of AWS services (S3, Glue, Lambda) and Redshift.
  • Proficiency in developing ETL processes using Python or Groovy/Shell.
  • Experience designing scalable distributed architectures for massive data volumes.

Responsibilities

  • Design and implement data warehousing solutions using Redshift on AWS.
  • Develop technical architecture for big data pipelines using Hadoop technologies.
  • Collaborate with cross-functional teams to design scalable data architectures.
  • Optimize queries and indexing to ensure high-performance results.
  • Provide SQL expertise including complex query optimization.

Skills

Project management
Agile methodologies
SQL

Tools

AWS
Redshift
Hadoop
Python

Job description

Summary:

At least 15 years technical experience with development and maintenance of big Data Warehouses particularly 10 years experience as developer, at least 5 years as dedicated architect Record of initiatives / projects to be provided - At least 10 years experience working in Pharma industry Excellent knowledge of processes, systems and data sources in Pharma industry is a must - Excellent knowledge of relational databases (e.g. Oracle, Redshift, Snowflake) and SQL is a must, experience with the Amazon Web Services is a plus - Proven project and demand management skills, including agile methods (e.g. Scrum) and tools (particularly Atlassian Stack / Jira)

Roles and Responsibilities
  • Design and implement data warehousing solutions using Redshift on AWS.
  • Develop technical architecture for big data processing pipelines using Hadoop technologies.
  • Collaborate with cross-functional teams to gather requirements and design scalable data architectures.
  • Ensure high-performance query performance by optimizing database queries and indexing strategies.
  • Provide expertise in SQL programming language, including complex query optimization techniques.
Desired Candidate Profile
  • 15-22 years of experience in designing and implementing large-scale data warehousing solutions.
  • Strong understanding of AWS services such as S3, Glue, Lambda, etc., along with hands-on experience working with Redshift.
  • Proficiency in developing complex ETL processes using Python or other scripting languages like Groovy or Shell Scripting.
  • Experience with designing scalable distributed systems architecture for handling massive volumes of structured & unstructured data.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Architect
Data Architect

Navikenz • Bengaluru

On-site
INR 1,500,000 - 2,500,000
AWS Data Engineer (Redshift)
AWS Data Engineer (Redshift)

Anblicks Inc. • Hyderabad

On-site
INR 1,200,000 - 1,800,000
AWS Redshift Data Engineer
AWS Redshift Data Engineer

Mployee.me • Delhi

On-site
INR 180,000 - 300,000
Data Architect
Data Architect

R Systems International Limited • Bengaluru

On-site
INR 3,800,000 - 6,000,000
AWS Redshift Data Engineer
AWS Redshift Data Engineer

Vouchagram India • New Delhi

On-site
INR 900,000 - 1,400,000
Data Architect (AWS)
Data Architect (AWS)

TeamPlus Staffing Solution Pvt Ltd • Bengaluru

On-site
INR 1,400,000 - 2,400,000
R Systems International - Data Architect - AWS
R Systems International - Data Architect - AWS

R Systems • Dadri

On-site
INR 2,500,000 - 5,000,000
Sr. Data Engineer
Sr. Data Engineer

Minfy Technologies • Gurugram District

On-site
INR 1,800,000 - 2,400,000
Data Engineer - Data Warehouse, BigData, Python and SQL
Data Engineer - Data Warehouse, BigData, Python and SQL

Tech ECS Limited • Kolkata District

On-site
INR 1,400,000 - 2,100,000
Sr. Data Engineer - Amazon redshift & AWS(Glue) 3 - 5 Years Mumbai
Sr. Data Engineer - Amazon redshift & AWS(Glue) 3 - 5 Years Mumbai

OneTure Technologies Private Limited • Mumbai

On-site
INR 3,500,000 - 7,500,000