Role & responsibilities
Design, develop, and maintain scalable data pipelines and data warehouse solutions using MySQL, AWS Redshift, and other enterprise database platforms.
Develop and optimize complex SQL code leveraging advanced DDL/DML, CTEs, analytical window functions, and set-based processing techniques.
Perform query performance tuning by analyzing execution plans, optimizing inefficient queries, and resolving concurrency issues such as deadlocks.
Build automation and data-processing solutions using Python, with additional scripting support through Shell scripting where applicable.
Troubleshoot data quality issues, investigate data anomalies, and support healthcare risk modeling and analytics platforms.
Leverage up-to-date data engineering technologies, including AWS services and Databricks, to enhance scalability and operational efficiency.
Act as a technical lead by driving engineering best practices,



conducting code reviews, and mentoring team members.

Preferred candidate profile
6+ years of experience in Data Engineering, Data Warehousing, and Advanced SQL development, with strong expertise in MySQL or similar enterprise database platforms.
Proven ability to design, optimize, and troubleshoot large-scale data pipelines, including query performance tuning, execution plan analysis, and database optimization.
Solid programming skills in Python for automation, data processing, and engineering solutions; experience with Shell scripting is an added advantage.
Demonstrated ability to solve complex data challenges, support analytics platforms, mentor team members, and drive engineering best practices in a team-oriented environment.

📌 Software Database Developer Bengaluru (India)
🏢 Emids Technologies
📍 India