Data Engineer

Position: Permanent

Role: Data Engineer

Experience: 5 -7 yrs

Location: Gurugram

Shift: 2 pm -11 pm

Domain- cross domain(Insurance, Investment, Financial services)

Role Overview

We are seeking a skilled Data Engineer with 57 years of experience to design, build, and maintain

scalable data pipelines and data warehouse solutions on AWS, with a strong focus on Amazon

Redshift. The role requires hands-on expertise in SQL and Python, exposure to Snowflake, and the

ability to work across multiple business domains.

The candidate will collaborate closely with data architects, analysts, and business stakeholders to

deliver reliable, high-performance data solutions that support analytics and reporting needs.

Key Responsibilities

Design, develop, and maintain batch and near-real-time data pipelines using AWS

services.

Build and optimize data ingestion and transformation workflows feeding Amazon

Redshift.

Implement scalable ETL/ELT frameworks using Python and SQL.

Support data integration from multiple source systems across domains.

Develop and maintain Redshift data models, tables, and views.

Optimize Redshift performance using appropriate distribution styles, sort keys, and

query tuning.

Support data validation, reconciliation, and quality checks.

Work within the AWS ecosystem (S3, Glue, Redshift, Lambda, IAM, etc.).

Support and integrate with Snowflake for analytics or downstream consumption.

Ensure security, scalability, and cost efficiency of data solutions.

Work closely with Data Architects and Data Modelers to implement approved designs.

Partner with analysts and business teams to understand data requirements.

Support production issues, root-cause analysis, and continuous improvements

Required Skills & Experience

57 years of hands-on experience in data engineering or data warehousing roles.

Experience working across multiple business domains (cross-domain exposure).

Strong expertise in Amazon Redshift.

Advanced SQL skills for complex transformations and analytics.

Proficiency in Python for ETL, data processing, and automation.

Working knowledge of Snowflake (data modeling, querying, or integrations).

Solid understanding of AWS data services.

Strong understanding of ETL/ELT patterns and data pipeline design.

Experience with data quality, monitoring, and error handling.

Familiarity with dimensional and analytical data models.

Strong problem-solving and analytical skills.

Good communication and stakeholder collaboration abilities.

Ability to work independently and in team-based delivery models.

Nice to Have

Experience with orchestration tools (e.g., Airflow, AWS Step Functions).

Exposure to CI/CD for data pipelines.

Prior experience in financial services or regulated environments

Interested Candidate can share their CV at chanchala.kumari@infystrat.com