I

Data Engineer(AWS)

Infinit-O
Full-time
On-site
Gurugram, Haryana, India

The Data Engineer will be responsible for building, optimizing, and maintaining data pipelines and DataMarts on AWS while ensuring compliance with data privacy regulations. They will work closely with the Data Architect and onshore teams to develop scalable ETL processes that support business reporting and analytics needs.


Key Responsibilities


Specific Duties and Responsibilities:

  • Develop scalable and high-performance DataMarts in AWS Redshift.
  • Implement ETL pipelines using AWS Glue, Python, and SQL.
  • Optimize SQL queries and AWS data integration for Tableau.
  • Work closely with Data Architects to ensure the right data modeling approaches.
  • Perform unit testing, troubleshooting, and bug fixes before deployment.


Key Skills

1️ Data Engineering & ETL Development

Strong experience in ETL development using AWS Glue, Lambda, and Step Functions

Expertise in building scalable Data Pipelines (Batch & Streaming)

Hands-on experience with SQL-based transformations and Redshift stored procedures


2️ AWS Cloud Data Services

AWS Redshift – Query optimization, table design, partitioning, and indexing.

AWS Glue & AWS Athena – Building serverless ETL pipelines

Amazon S3 – Data lake management and integration with Redshift

AWS Lambda – Writing lightweight data processing functions


3️ Data Modeling & DataMart Development

Experience designing star and snowflake schemas for DataMarts

Ability to create optimised fact and dimension tables

Strong understanding of data partitioning and indexing strategies


Requirements

Key Responsibilities:

  • Develop scalable and high-performance DataMarts in AWS Redshift.
  • Implement ETL pipelines using AWS Glue, Python, and SQL.
  • Optimize SQL queries and AWS data integration for Tableau.
  • Work closely with Data Architects to ensure the right data modeling approaches.




Requirements

Requirements

Key Responsibilities:

  • Develop scalable and high-performance DataMarts in AWS Redshift.
  • Implement ETL pipelines using AWS Glue, Python, and SQL.
  • Optimize SQL queries and AWS data integration for Tableau.
  • Work closely with Data Architects to ensure the right data modeling approaches.


Apply now
Share this job
Twitter Facebook Linkedin Email