Data Engineer (Bengaluru)

Data Engineer (Bengaluru)

15 Nov
|
Innominds Software
|
Bengaluru

15 Nov

Innominds Software

Bengaluru

## Job highlights
- Expertise in SQL performance tuning, deep indexing knowledge, stored procedure optimization, and production incident handling
- Diagnose and optimize slow queries, manage indexing strategies, troubleshoot under pressure, monitor database health, and ensure production readiness Role & responsibilities Skill
- SQL+PowerBI+ADF Please find the below topics and reply with your answer with yes or No. 1) Performance tuning must be hands-on, not conceptual The candidate should be able to actively diagnose and optimize slow queries not just describe best practices. What this means:
- Read execution plans and identify bottlenecks
- Optimize joins, filters, and indexing strategies
- Reduce query latency under real workload conditions
- Demonstrate examples of production tuning they personally handled
- Expectation: Immediate problem-solving ability in live scenarios. 2) Deep indexing knowledge is mandatory Indexes are tied to core business logic — mistakes directly impact a time-critical payment system. Candidate must be able to:
- Explain index types and when to use each
- Identify missing/fragmented indexes
- Perform index maintenance strategy decisions
- Balance performance vs write overhead
- Expectation: Confidence handling indexing decisions without trial-and-error. 3) Rapid troubleshooting mindset The setting does not allow experimentation cycles — the candidate must operate with precision under time pressure. They should demonstrate:
- Structured debugging workflow




- Root cause isolation
- Production-safe remediation approaches
- Prior experience handling critical database incidents
- Expectation: Speed and methodical thinking under pressure. 4) Strong SQL fundamentals, no gaps Basic relational understanding is non-negotiable. Candidate must clearly articulate:
- Left join vs inner join behavior and use cases
- Query impact on result sets and performance
- Practical examples of join misuse causing issues
- Expectation: Core database fluency, instantly recallable. 5) Stored procedure optimization skills Candidates must show a systematic approach to slow stored procedures. They should be able to discuss:
- Execution plan review
- Parameter sniffing considerations
- Query refactoring
- Resource bottleneck identification
- Logging/monitoring techniques
- Expectation: Structured tuning methodology (not guesswork). 6) Database health awareness The role requires proactive monitoring capability. Candidate should understand:
- Health metrics to monitor
- Capacity and performance signals
- Preventive maintenance practices
- Alert interpretation
- Expectation: Ownership mindset toward system stability. 7) Production readiness mentality This is a payment system, downtime tolerance is low. Candidate must demonstrate:
- Experience working in high-stakes environments
- Change safety discipline
- Incident response maturity Expectation: Reliability-first thinking. Preferred candidate profile

📌 Data Engineer (Bengaluru)
🏢 Innominds Software
📍 Bengaluru

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: data engineer (bengaluru) / bengaluru

Subscribe to this job alert:

Get the latest job offers by email for: data engineer (bengaluru) / bengaluru