13 Nov
|
Kanerika Software
|
Hyderabad
13 Nov
Kanerika Software
Hyderabad
Job highlights
- Certification Reimbursements: Assists employees in obtaining professional
- Required: . 8+
- years of experience in database engineering or backend systems development
- experience with T-SQL,LinkSQL,query optimization,and indexing strategies
- Experience
Role Weu2019re looking for a seasoned Data Engineer to join our Engineering organization and take ownership of the systems that power our data-driven decisions. Youu2019ll architect and maintain high-performance data pipelines and databases across platforms like
MSSQL, Redshift, and Snowflakeu2014ensuring data is reliable, accessible, and optimized for scale. If you thrive on solving complex problems, love optimizing systems for performance, and want to be the go-to expert in a collaborative,
high-impact environment, weu2019d love to meet you.
Key
Responsibilities
****Design and maintain scalable, efficient, and well-partitioned schemas in MSSQL,
Redshift, and Snowflake
Architect and optimize complex queries, stored procedures, indexing strategies, and partitioning for large datasets
Build,
monitor, and maintain data pipelines that ensure timely and accurate delivery of data to internal and external consumers
Own and enforce data refresh SLAs, ensuring availability, consistency, and reliability across production and reporting environments collaborate with software engineers, analysts, and DevOps teams to ensure data models and queries align with product and reporting requirements.
Proactively identify and remediate performance bottlenecks, slow queries, and data inconsistencies
u200b Implement and manage database change workflows using schema migration/versioning tools
Define and promote best practices for data access, security, compliance, and observability
Requirements
What
Youu2019ll Bring:
Bacheloru2019s or Masteru2019s degree in Engineering, Computer Applications, or a related field.
**Required:
8+
years of experience in database engineering or backend systems development
Deep expertise with MySQL, Amazon Redshift, and Snowflake, including schema design and performance optimization
Design,
build, and maintain scalable data pipelines and ETL processes tailored to client needs.
Proven track record maintaining data freshness SLAs and data quality across production pipelines
Hands-on experience with T-SQL, LinkSQL, query optimization, and indexing strategies
Experience with query optimization, mapping tables to blocks and partitions, sub-table structure and keying/indexing for efficiency
Experience of relational data modelling and schema versioning in support of software development.
Experience as the sole or lead database expert on a development team.
Familiarity with source control systems (e.g., Git/Bitbucket) and CI/CD integration.
Strong problem-solving skills are desirable.
Transforming product requirements into workable solutions, in collaboration with several development and testing teams.
Writing robust functions, procedures and scripts using SQL.
Being heavily involved in the day to day running of the business dealing with support and performance issues.
Diagnose and troubleshoot data-related issues, providing quick and effective resolutions.
Analyze data workflows and identify areas for improvement, recommending and implementing solutions to optimize performance.
Utilize a proactive approach to foresee potential problems and address them before they impact operations.
Perks
Employee
Benefits
1.
Culture:
**- Open
Door Policy: Encourages open communication and accessibility to management.
- Open Office Floor Plan: Fosters a collaborative and interactive work environment.
- Adaptable Working Hours: Allows employees to have flexibility in their work schedules.
- Employee Referral Bonus:
Rewards employees for referring qualified candidates.
- Appraisal Process Twice a Year: Provides regular performance evaluations and feedback.
1.
Inclusivity and Diversity:
- i. Hiring practices that promote diversity: Ensures a diverse and inclusive workforce.
- ii. Mandatory POSH training: Promotes a safe and respectful work environment.
1.
Health Insurance and Wellness Benefits: i. GMC and Term Insurance: Offers medical coverage and financial protection.
ii. Health
Insurance: Provides coverage for medical expenses.
iii. Disability
Insurance: Offers financial support in case of disability.
1. Child Care & Parental Leave Benefits: i. Company-sponsored family events: Creates opportunities for employees and their families to bond.
ii. Generous
Parental Leave: Allows parents to take time off after the birth or adoption of a child.
iii. Family
Medical Leave: Offers leave for employees to take care of family members medical needs.
1. Perks and Time-Off Benefits: i. Company-sponsored outings: Organizes recreational activities for employees.
ii. Gratuity:
Provides a monetary benefit as a token of appreciation.
iii. Provident
Fund: Helps employees save for retirement.
iv. Generous
PTO: Offers more than the industry standard for paid time off.
v. Paid sick days: Allows employees to take paid time off when they are unwell.
vi. Paid holidays: Gives employees paid time off for designated holidays.
vii. Bereavement
Leave: Provides time off for employees to grieve the loss of a loved one.
1. Professional Development Benefits: i. L&D; with FLEX- Enterprise Learning Repository: Provides access to a learning repository for professional development.
ii. Mentorship
Program: Offers guidance and support from experienced professionals.
iii. Job
Training: Provides training to enhance job-related skills.
iv. Professional
Certification Reimbursements: Assists employees in obtaining professional certifications.
v. Promote from Within: Encourages internal growth and advancement opportunities.
📌 Sr. Data Engineer (Hyderabad)
🏢 Kanerika Software
📍 Hyderabad