pri AWS Redshift Engineer

Tata Consultancy Services; Hyderabad, Chennai District, Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Tata Consultancy Services in Hyderabad seeks an experienced Data Engineer to design and maintain cloud-based data pipelines using AWS, Redshift, and modern ETL/ELT processes. The role focuses on building robust data warehouses, implementing API-based integrations, and delivering well-tested, scalable data solutions.

The candidate will work in an Agile environment, applying advanced SQL and Python skills (Pandas, NumPy, Flask) to ensure data quality, monitoring, and efficient analytics pipelines.

Qualifications

• 4-5+ years of experience with AWS (including Redshift)
• 4-5+ years of experience designing and maintaining data warehouses
• Expertise in real-time and batch data pipelines, including API-based integration workflows
• Experience in data onboarding blueprints mapping source/target data strategies and aggregations
• Advanced SQL proficiency including query optimization, indexing, and partitioning
• Hands-on Python for data processes with pandas/NumPy and Flask
• Experience with data monitoring, detection, troubleshooting and validation frameworks
• Proven track record delivering well-designed, tested pipelines in Agile environments

Responsibilities

• Design and maintain cloud-based data pipelines (real-time and batch)
• Build and optimize ETL/ELT processes and data warehouse schemas
• Develop API-based data integration workflows and onboarding blueprints
• Implement data quality checks, monitoring and validation across pipelines
• Collaborate in Agile teams to deliver scalable data solutions

Skills

AWS

Redshift

Data Warehousing

ETL/ELT

SQL

Python

Data Monitoring

Agile

Tools

Pandas

NumPy

Flask

Job description

JOB DESCRIPTION

• 4-5+ years of experience with AWS (including Redshift) and other cloud technologies
• 4-5+ years of experience designing and maintaining data warehouses (e.g., Redshift, Big Query) as well as building complex ETL/ELT pipelines.
• Expertise in working with real-time and batch data pipelines, including API-based integration workflows.
• Experience in maintaining and executing data onboarding blueprints which map source and target data strategies and aggregations.
• Advanced SQL proficiency, including concepts such as query optimization, indexing, and partitioning.
• Hands-on experience with Python for data-related processes, using libraries like pandas, numpy, and frameworks like Flask.
• Experience with data monitoring, detection, troubleshooting as well as validation frameworks.
• Proven track record of delivering well-designed, well-tested and performant software solutions and pipelines within an agile environment.