AWS Data Engineer Trans America
At a glance
Mid-level Data Engineering role at Fa Ewjt Saasfaprod1. Gurugram · full-time.
Pay not stated Data Engineering salary
dataroles summary, based on the employer's posting.
What you'll do
- Turn business needs into data models designed to support lasting solutions
- Reconstruct physical data models by examining databases and SQL scripts
- Assess data integration problems and recommend ways to address them
- Help shape data architecture, including movement patterns and technology choices
What you bring
- At least five years of work as a data engineer
- Advanced SQL skills, including joins, subqueries, CTEs and aggregation
- Hands-on experience with Snowflake, ETL, SQL and CI/CD
- A computer science, software engineering or MIS degree, or equivalent education and experience
Who this fits
This role suits a mid-level data engineer with strong SQL and ETL skills, plus knowledge of data modeling and Python. AWS familiarity is useful, especially with S3 and Glue. The role is hybrid and can be based in Bangalore, Pune, Hyderabad or Gurugram.
From the employer
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