Sr. Data Engineer

Anblicks Inc.; Hyderabad; On-site; INR 1,500,000 - 2,000,000; Full time

Job summary

A technology consulting firm in India is looking for a Senior SQL Server Developer / Data Engineer with 8+ years of experience in SQL Server and T-SQL. The ideal candidate will design, develop, and optimize complex databases and ETL processes. Responsibilities include troubleshooting performance issues, supporting data integration, and collaborating with cross-functional teams. This role requires a strong analytical mindset, excellent problem-solving skills, and the ability to work independently. Competitive salary and growth opportunities are offered.

Qualifications

• 8+ years of experience in SQL Server development or data engineering.
• Expertise in developing stored procedures, functions, and complex SQL queries.
• Strong understanding of ETL concepts and data warehousing.

Responsibilities

• Design and maintain complex T-SQL stored procedures and ETL workflows.
• Analyze and reverse engineer existing SQL Server code for business logic.
• Support data integration and resolve ETL performance issues.
• Document technical processes and participate in deployment activities.

Skills

SQL Server development

T-SQL

ETL development

Data engineering

Data validation

Performance optimization

Analytical skills

Problem-solving

Communication skills

Collaboration

Education

Bachelor’s degree in Computer Science

Tools

Databricks

Microsoft Fabric

Salesforce

Job description

Senior SQL Server Developer / Data Engineer

Job Description

Experience

8+ Years

Location

TBD / As Applicable

Job Summary

We are seeking a highly skilled Senior SQL Server Developer / Data Engineer with 8+ years of experience and strong expertise in SQL Server, T‑SQL, and ETL/data integration. The ideal candidate should have hands‑on experience in designing, developing, optimizing, and supporting enterprise database solutions and data pipelines. This role requires strong analytical and troubleshooting skills, a solid understanding of data movement and transformation, and the ability to reverse engineer existing code and legacy implementations to support enhancements, production support, and modernization initiatives.

Key Responsibilities

• Design, develop, and maintain complex T‑SQL stored procedures, functions, views, and triggers.
• Build, enhance, and support ETL workflows for data extraction, transformation, and loading.
• Analyze and reverse engineer existing SQL Server code, database objects, and legacy data flows to understand business logic and system dependencies.
• Develop and optimize SQL queries and database objects for performance, scalability, and maintainability.
• Support data integration and synchronization across multiple source and target systems.
• Troubleshoot and resolve issues related to ETL jobs, SQL Server performance, and production data pipelines.
• Ensure data quality, reconciliation, and consistency across systems.
• Work closely with business analysts, architects, and application teams to understand requirements and implement effective data solutions.
• Participate in unit testing, system testing, deployment, and production support activities.
• Prepare and maintain technical documentation for mappings, workflows, stored procedures, data flows, and operational processes.
• Support release and deployment activities across multiple environments.
• Follow development standards, coding best practices, and governance processes.

Required Skills

• 8+ years of experience in SQL Server development, data engineering, or ETL development.
• Strong hands‑on experience with SQL Server and T‑SQL.
• Expertise in developing stored procedures, functions, views, triggers, and complex SQL queries.
• Strong understanding of ETL concepts, including extraction, transformation, loading, data mapping, and workflow orchestration.
• Experience in query tuning, performance optimization, and troubleshooting in SQL Server.
• Good understanding of data warehousing concepts, including staging, ODS, and dimensional models.
• Ability to reverse engineer existing code, understand legacy business logic, and support migration or modernization initiatives.
• Experience in data validation, reconciliation, and root cause analysis.
• Ability to support critical production processes and resolve data‑related issues.
• Strong analytical, problem‑solving, and communication skills.
• Ability to work independently and collaboratively within a team environment.

Nice to Have / Preferred Skills

• Experience with Databricks, Microsoft Fabric, and Salesforce.
• Experience with CI/CD implementation using DACPAC‑based deployments.
• Familiarity with version control systems and deployment automation.
• Exposure to cloud‑based data engineering and modern data platforms.
• Experience with enterprise data migration, modernization, or platform transformation initiatives.
• Familiarity with API‑based and file‑based integrations.
• Knowledge of scheduling and orchestration tools.

Education

Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field.

Ideal Candidate Profile

• Strong in SQL Server development and ETL implementation.
• Experienced in building and supporting enterprise‑grade database and data integration solutions.
• Able to reverse engineer and understand existing code and legacy data processes.
• Comfortable working on both development and production support activities.
• Strong collaborator who can work across technical and functional teams.
• Capable of delivering reliable and scalable data solutions in a fast‑paced environment.