Data Engineer (SQL + Python)

Location:
Mumbai

Experience:
5 - 7 Years

Employment Type:
Full-Time

About the Role

We are looking for a highly analytical and detail-oriented
Data Engineer
with solid expertise in
SQL and Data Analysis
. This role requires a professional who can understand complex datasets, derive meaningful insights from data, and write optimized SQL queries to support business and engineering requirements.

The ideal candidate should possess
strong hands-on SQL skills (80%)
with working knowledge of
Python (20%)
for data processing and automation tasks. Candidates with excellent SQL expertise and moderate Python skills will be preferred over candidates with robust Python and average SQL capabilities.

Key Responsibilities

Data Engineering & SQL Development
Analyze large datasets and understand business context to derive meaningful insights.
Design, develop, and optimize complex SQL queries for data extraction, transformation, and validation.




Work closely with stakeholders to understand data requirements and translate them into productive database solutions.
Perform data quality checks and ensure data accuracy, consistency, and integrity across systems.

Advanced SQL & Database Management
Demonstrate strong expertise in:
Window Functions
Set Operators (UNION, INTERSECT, MINUS/EXCEPT)
Correlated and Nested Queries
Common Table Expressions (CTEs)
Subqueries and Complex Query Optimization
Hands-on experience with all types of SQL Joins:
Inner Join
Left Join
Right Join
Full Outer Join
Self Join
Cross Join

Data Handling & Transformation
Handle and manipulate different data types, including:
Date
Timestamp
Numeric
Character/String
Work with Regular Expressions (Regex) for data cleansing, validation, and transformation.
Perform data profiling and identify data inconsistencies and anomalies.

Database Operations
Extensive experience with DML operations:
INSERT
UPDATE
DELETE
MERGE/UPSERT
Support

📌 Data Engineer Mumbai
🏢 NexionPro Services
📍 Mumbai