ROLE AND RESPONSIBILITIES·
Design and implement ETL using AWS Glue, Python, and SQL to ingest, transform, and load data.
Develop and maintain data lakes and data warehouses leveraging Amazon S3 and Amazon Redshift.
Optimize data storage, performance, and cost efficiency using Redshift Spectrum and query tuning.· Build reusable data ingestion and transformation frameworks following best practices for reusability,scalability, and security]
Troubleshoot performance bottlenecks, ensure system reliability, and follow AWS Well-Architected andsecurity best practices.
Collaborate with cross-functional teams to define and implement data models, data governance, andsolution design aligned with business goals.
Implement data quality checks, monitoring, and metadata management across ETL pipelines.
Liaise with SBU users, Development team, Center of excellence team, Regional Infrastructure team duringexecution of project deliverables.
Responsible for requirements gathering through design, development, and implementation of thesolution within Data Analytics.
Document requirements, create functional specifications and prepare wireframes/flowcharts
Prepare technical user manuals, system configuration documents and provide user training
REQUIRED SKILLS \& EXPERIENCE
Strong hands-on experience with AWS analytics stack AWS Glue, Amazon Redshift, Amazon S3, AWS Lambda, Step Functions, Athena (good to have).
Proficiency in Python for data processing and automation.
Strong SQL expertise for complex queries, transformations, and data validation.
Experience with data modeling, schema design, and dimensional modeling (Star/Snowflake schemas).
Good understanding of solution design principles, data architecture, and integration patterns.
Exposure to data governance, cataloging, and security best practices in AWS environment.
Willingness to learn and adapt to new technologies and areas such as Generative BI and Tableau
SOFT SKILLS
Strong problem-solving and analytical skills.
Ability to work independently and in agile teams.
Excellent communication and documentation skills.
Job Type: Full-time
Pay: ₹800,000.00 - ₹1,200,000.00 per year
Benefits:
Health insurance
Provident Fund
Work Location: In person