Urgent opening For AWS Data Engineer

Teamwhiz It Solution; Pune District; Hybrid; INR 1,200,000 - 2,400,000; Full time

Job summary

Teamwhiz It Solution is seeking an AWS Data Engineer with 4+ years of experience to translate business needs into scalable data models and build robust data pipelines in the AWS ecosystem.

Key tasks include reverse engineering data models, optimizing data processing, and collaborating with stakeholders to ensure performance and value from data initiatives.

Qualifications

• 5+ years of experience as a Data Engineer.
• Advanced SQL querying skills (joins, subqueries, CTEs).
• Strong knowledge of joins and CTEs.
• Strong experience with Python.
• Experience in Snowflake, ETL, SQL, CI/CD.
• Strong expertise in ETL processes and data model concepts.
• Knowledge of Star Schema and snowflake schema.
• Good knowledge of AWS services such as S3, Athena, Glue, EMR/Spark, with emphasis on S3 and Glue.

Responsibilities

• Translate business needs into data models for long-term solutions.
• Reverse engineer physical data models from databases and SQL scripts.
• Analyze data integration challenges and propose solutions.
• Assist with data architecture direction including data movement strategy and tech decisions.
• Design and implement data pipelines, optimize processing and storage, and ensure performance.

Skills

SQL

Advanced SQL

CTEs

Python

Snowflake

ETL

CI/CD

Data modeling

Star schema

AWS S3

AWS Glue

Athena

EMR/Spark

Education

Bachelors or Masters in CS/Data Engineering

Tools

Snowflake

CI/CD

ETL tools

AWS S3

AWS Glue

Athena

EMR/Spark

Job description

Role: AWS Data Engineer
Exp:4 + Years

Key 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.
• Analyze 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).

Responsibilities for Internal Candidates

• Design and implement data pipelines, Optimize data processing and storage,
• Ensure data solutions meet performance standards, Provide technical support,
• Collaborate with stakeholders.

Must-Have Skills

• 5+ Years of experience as a Data Engineer
• Strong technical expertise in SQL Advanced SQL querying skills (joins, subqueries, CTEs, aggregation)
• Strong knowledge of joints and common table expressions (CTEs)
• Strong experience with Python
• 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-to-Have Skills

• Experience with Big Data Tools and technologies
• Good Understanding of data structures and data analysis
• Knowledge of Insurance Domain is an addition.

Qualifications

• Bachelors or masters degree in computer science, Data Engineering, Information Systems, or a related field.