Data Engineer (MSBI / SSIS / ETL)

Noida / Bangalore - On-site

TESCRA India

Tescra Software Pvt. Ltd. No 11, 3rd Floor, Adam Chambers, Richmond Road, Bengaluru, Karnataka 560025 India

Full-time

3–10 Years

Job Overview

TESCRA India is seeking a highly skilled and experienced Data Engineer with a strong background in Microsoft Business Intelligence (MSBI) technologies, specifically SQL Server Integration Services (SSIS), SQL, and Extract, Transform, Load (ETL) processes. The successful candidate will be instrumental in designing, developing, and maintaining robust data solutions. This role requires a deep understanding of data modeling principles, including facts and dimensions, data warehousing concepts, and query optimization techniques to ensure efficient and accurate data management.

Key Responsibilities

• Design, develop, implement, and maintain scalable and efficient ETL processes utilizing SSIS and other relevant ETL tools.
• Leverage the full MSBI stack, including SSIS, SSRS (SQL Server Reporting Services), and SSAS (SQL Server Analysis Services), for data integration and business intelligence solutions.
• Develop and optimize complex SQL queries, stored procedures, and functions to ensure high performance and data accuracy.
• Construct and maintain robust data models, adhering to best practices for fact and dimension table design within a data warehousing environment.
• Design, implement, and manage comprehensive Data Warehouse (DWH) solutions to support analytical and reporting needs.
• Ensure the highest standards of data quality, integrity, and performance optimization across all data pipelines and repositories.
• Collaborate effectively with cross-functional teams, including business analysts and stakeholders, to gather and translate data requirements into technical specifications.
• Proactively identify, troubleshoot, and resolve data-related issues to ensure uninterrupted data flow and system stability.

Educational Qualifications

• Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent practical experience.

Must-Have Skills

• Proven experience with the Microsoft Business Intelligence (MSBI) stack, with a strong emphasis on SSIS.
• Expert-level proficiency in SQL, including advanced query writing, performance tuning, and optimization techniques.
• Hands-on experience with ETL tools, with SSIS being a primary requirement.
• Solid understanding of Data Warehousing (DWH) concepts, architecture, and best practices.
• Strong knowledge of data modeling principles, including the design and implementation of fact and dimension tables.
• Demonstrated experience in performance tuning and optimization of database queries and ETL processes.

Good-to-Have Skills

• Experience with other ETL/ELT tools beyond SSIS.
• Familiarity with cloud-based data platforms (e.g., Azure Data Factory, AWS Glue).
• Knowledge of data governance and data security best practices.
• Experience with scripting languages such as Python or PowerShell for automation.
• Understanding of agile development methodologies.

Pay Rate/Salary

Competitive salary commensurate with experience and qualifications.

Number of Openings

Multiple