17 Nov
|
Tech Mahindra
|
Pune
17 Nov
Tech Mahindra
Pune
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.
- Robust 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.
📌 Data Architect (Hadoop/ AWS) (Pune)
🏢 Tech Mahindra
📍 Pune