Data Engineer - AWS Redshift & Data Warehousing

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

Job summary

Tata Consultancy Services invites applications for a Data Engineer to perform data engineering on the AWS Redshift platform and design scalable data warehouse solutions. You will write and optimize complex SQL queries, develop ETL workflows, and build data extracts for enterprise integrations.

The role requires strong SQL and data warehousing knowledge, experience with cloud data services, and collaboration with stakeholders in Agile delivery environments.

Qualifications

• Must-have data engineering skills for AWS Redshift and data warehouse environments.
• Strong SQL development and query optimization capabilities.
• Experience with data warehousing concepts and ETL development.
• Proficiency in database design and data flow analysis.
• Hands-on with relational databases including Snowflake, Teradata or similar systems.
• Familiarity with AWS data services (Redshift, Athena) and CI/CD tools like Jenkins or GitHub.
• Experience with Python, Spark or Java will be a plus.

Responsibilities

• Perform data engineering activities on AWS Redshift platform.
• Design and develop scalable data warehouse solutions.
• Write and optimize complex SQL queries.
• Develop and support ETL workflows and provisioning processes.
• Build, test, and maintain data extracts and integrations.
• Work with cloud and big data technologies to support enterprise data platforms.
• Support CI/CD implementation and deployment activities.
• Collaborate with business and technical stakeholders in Agile delivery environments.

Skills

AWS Redshift

SQL development

Data warehousing

ETL development

Database design

Relational databases

Snowflake

Teradata

Relational Databases

AWS Athena

CI/CD tools

Python

Spark

Java

Unix Shell Scripting

Hive

MongoDB

DynamoDB

DB2

NoSQL Databases

SnapLogic

Informatica

AWS EC2

AWS S3

Job description

Must Have Skills

• AWS Redshift


• Strong SQL development and query optimization


• Data Warehousing concepts


• ETL Development


• Database Design and Data Flow Analysis


• Snowflake / Teradata / Relational Databases


• AWS Data Services (Redshift, Athena)


• CI/CD tools (Jenkins, GitHub, Bitbucket, Bamboo)

Good to Have Skills

• Python


• Spark


• Java


• Unix Shell Scripting


• Hive


• MongoDB


• DynamoDB


• DB2


• NoSQL Databases


• SnapLogic


• Informatica


• AWS EC2


• AWS S3

Responsibilities

• Perform Data Engineering activities on AWS Redshift platform.


• Design and develop scalable data warehouse solutions.


• Write and optimize complex SQL queries.


• Develop and support ETL workflows and provisioning processes.


• Build, test, and maintain data extracts and integrations.


• Work with cloud and big data technologies to support enterprise data platforms.


• Support CI/CD implementation and deployment activities.


• Collaborate with business and technical stakeholders in Agile delivery environments.