Role: Sr. Engineer/Lead,

Job location: Kolkata,

Experience: 6 - 10 years,

Mode: Fulltime,

Notice period: Immediate to 15 days.

Job Description:

DBMS: Deep familiarity with standard relational databases like MySQL or enterprise analytical data warehouses like AWS Redshift.

Writing and Tuning Code: Mastery of advanced DDL/DML, analytical window functions, Common Table Expressions (CTEs), and complex set-based logic.

Knowledge/experience of DataBricks architecture will be a huge bonus. Experience in the AWS ecosystem will also be a bonus.

Programming & Automation: Standard scripting capabilities. Deep knowledge in Python will be a huge plus; knowledge in Shell scripting will also be a plus.

Query Performance Tuning:



Expertise reading execution plans, rewriting problematic queries, eliminating cursor-based loops, and mitigating concurrency issues like deadlocks.

Apply solid analytical and problem-solving skills to debug data anomalies and support healthcare risk modelling platforms.

Act as a technical anchor for the team, establishing engineering best practices and mentoring mid-level engineers.

Collaborate closely with US stakeholders to ensure high availability and seamless execution of the Risk & Analytics module.

📌 Data Development Engineers (Kolkata)
🏢 Shell Infotech
📍 Kolkata