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 strong 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

📌 Data Engineer (Mumbai)
🏢 NexionPro Services
📍 Mumbai