AWS Data Engineer Trans America

Role: Data Engineer

Location: Bangalore, Pune, Hyderabad, Gurugram (Hybrid)

Key Role and Responsibilities:

• Understand and translate business needs into data models supporting long-term

solutions.

• Perform reverse engineering of physical data models from databases and SQL

scripts.

• Analyse data-related system integration challenges and propose appropriate

solutions.

• Assist with and support setting the data architecture direction (including data

movement approach, architecture/technology strategy, and any other data

related considerations to ensure business value).

Requirements:

• 5+ Years of experience as a Data Engineer

• Strong technical expertise in SQL Advanced SQL querying skills (joins, subqueries,

CTEs, aggregation)

• Strong knowledge of joins and common table expressions (CTEs)

• Experience in Snowflake, ETL, SQL, CI/CD

• Strong expertise in ETL process and with various data model concepts

• Knowledge of star schema and snowflake schema

• Good to know about AWS services such as S3, Athena, Glue, EMR/Spark with a

major emphasis on S3 and Glue

• Good knowledge of Python

Education: Bachelor’s degree in computer science, Software Engineering, MIS or equivalent

combination of education and experience

Key Skills: SQL, Snowflake, Python, AWS

Key Role and Responsibilities:

• Understand and translate business needs into data models supporting long-term

solutions.

• Perform reverse engineering of physical data models from databases and SQL

scripts.

• Analyse data-related system integration challenges and propose appropriate

solutions.

• Assist with and support setting the data architecture direction (including data

movement approach, architecture/technology strategy, and any other data

related considerations to ensure business value).

Bachelor’s degree