Data Engineer

Smart Ims; Hyderabad; Hybrid; INR 1,800,000 - 3,200,000; Full time

Job summary

Smart Ims in Hyderabad is seeking an experienced Data Engineer to design, develop, and maintain SQL Server databases and ETL pipelines. The role focuses on T-SQL development, SSIS packages, and data migrations to ensure data quality and performance across systems.

The ideal candidate will handle complex queries, indexing, and performance tuning, while collaborating with cross-functional teams to meet data requirements and deliver reliable migration solutions.

Qualifications

• Strong hands-on experience with Microsoft SQL Server.
• T-SQL development experience.
• Hands-on SSIS (SQL Server Integration Services).
• Strong understanding of ETL processes and data integration.
• Experience with data/database migration projects.
• Experience with stored procedures, views, functions, CTEs, temporary tables, and complex joins.
• Good understanding of indexes, execution plans, query optimization, and performance tuning.
• Experience with SQL Server Agent and scheduled jobs.
• Strong troubleshooting and analytical skills.

Responsibilities

• Develop, maintain, and optimize SQL Server databases and database objects.
• Write complex and efficient T-SQL queries, stored procedures, functions, views, and triggers.
• Design and develop SSIS packages for ETL and data integration.
• Perform data migration and database migration activities between legacy and target systems.
• Extract, transform, cleanse, and load data using SSIS and T-SQL.
• Develop migration scripts and perform data validation, reconciliation, and troubleshooting.
• Analyze and resolve data quality, ETL, and database performance issues.
• Optimize SQL queries, stored procedures, indexes, and ETL processes.
• Work with large volumes of data and ensure migration processes are accurate and efficient.
• Schedule and monitor ETL jobs using SQL Server Agent.
• Support production deployments and troubleshoot failures in database and ETL processes.
• Collaborate with application, infrastructure, and business teams to understand data requirements.
• Prepare technical documentation for database, ETL, and migration processes.

Skills

Troubleshooting

Analytical skills

ETL design

Data migration

Collaboration

Tools

Microsoft SQL Server

T-SQL

SSIS (SQL Server Integration Services)

ETL

SQL Server Agent

Indexes & query optimization

Performance tuning

Oracle

Azure SQL

Azure Data Factory

Job description

Role: Data Engineer

Experience: 6-10 years

Job Location: Hyderabad

Job Summary

We are looking for an experienced SQL Developer with strong expertise in SQL Server, T-SQL, SSIS, ETL, and data migration. The candidate will be responsible for developing and maintaining database solutions, building ETL workflows, supporting data migration initiatives, and ensuring data quality and performance.

Key Responsibilities

• Develop, maintain, and optimize SQL Server databases and database objects.
• Write complex and efficient T-SQL queries, stored procedures, functions, views, and triggers.
• Design and develop SSIS packages for ETL and data integration.
• Perform data migration and database migration activities between legacy and target systems.
• Extract, transform, cleanse, and load data using SSIS and T-SQL.
• Develop migration scripts and perform data validation, reconciliation, and troubleshooting.
• Analyze and resolve data quality, ETL, and database performance issues.
• Optimize SQL queries, stored procedures, indexes, and ETL processes.
• Work with large volumes of data and ensure migration processes are accurate and efficient.
• Schedule and monitor ETL jobs using SQL Server Agent.
• Support production deployments and troubleshoot failures in database and ETL processes.
• Collaborate with application, infrastructure, and business teams to understand data requirements.
• Prepare technical documentation for database, ETL, and migration processes.

Required Skills

• Strong hands-on experience with Microsoft SQL Server.
• Strong T-SQL development experience.
• Hands-on experience with SSIS (SQL Server Integration Services).
• Strong understanding of ETL processes and data integration.
• Experience with data/database migration projects.
• Experience with stored procedures, views, functions, CTEs, temporary tables, and complex joins.
• Good understanding of indexes, execution plans, query optimization, and performance tuning.
• Experience with SQL Server Agent and scheduled jobs.
• Strong troubleshooting and analytical skills.

Preferred Skills

• Experience migrating data from legacy databases/applications to SQL Server.
• Experience with Oracle, MySQL, PostgreSQL, or other source databases is a plus.
• Knowledge of data warehousing concepts.
• Experience with Azure SQL / Azure Data Factory is a plus.
• Experience working in Agile development environments.