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 strong 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 solid 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 efficient 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 database maintenance activities and ensure efficient data operations.
Pe

📌 Data Engineer (Mumbai)
🏢 NexionPro Services
📍 Mumbai