Solution Database Engineer

Overview

Solution Database Engineer (hybrid) to design, develop, and maintain data warehouse and enterprise data integration solutions using SQL Server and SSIS.

What you'll do

• Design and maintain SSIS packages for ETL data extraction, transformation, and loading.
• Integrate data from multiple sources including SQL Server, flat files, APIs, cloud platforms, and third-party applications.
• Build and optimize enterprise data warehouses, data marts, and staging environments.
• Create dimensional models such as star and snowflake schemas and implement cleansing/standardization.
• Write optimized T-SQL queries, views, functions, and stored procedures and improve performance using execution plans and tuning.
• Implement data validation for accuracy and consistency, and support data governance with metadata documentation.
• Support BI/reporting teams by creating datasets/views for Power BI, SSRS, or Tableau.

What you'll need

• 5+ years of hands-on experience in Data Warehouse Development.
• 5+ years of SQL Server development experience.
• 3+ years of experience developing and supporting SSIS packages and ETL solutions.
• Experience with large enterprise databases and high-volume transactional systems.
• Advanced T-SQL programming and stored procedures/views/functions.
• Data modeling experience including star and snowflake schemas and SCD.
• Experience with data validation/reconciliation and root cause analysis.
• Bachelor’s degree in Computer Science, Information Systems, Software Engineering, Data Engineering, or related discipline.

Details

• Work location: Bangalore.
• Shift timings: 8.00am to 5.00pm OR 12.00pm to 9.00pm IST.
• Work mode: Hybrid (3 days office).