MSBI Developer

Infosys; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Infosys in Bengaluru is seeking a BI/ETL specialist to develop and maintain database objects, design ETL packages, build OLAP models, and create dashboards in Power BI.

You will ensure data quality, optimize performance, and collaborate with stakeholders, leveraging Azure data services where needed.

Qualifications

• Bachelor of Engineering as minimum education.
• Strong hands-on experience with Microsoft SQL Server.
• Experience with SSIS for ETL development.
• Knowledge of SSAS (Multidimensional and/or Tabular Models).
• Proficiency in Power BI report and dashboard development.
• Understanding of Data Warehouse concepts, Star Schema, and Data Modeling.

Responsibilities

• Develop and maintain database objects, including stored procedures, functions, views, and triggers in SQL Server.
• Design, build, and support ETL packages using SSIS.
• Develop and manage multidimensional/tabular models using SSAS.
• Create interactive dashboards, reports, and visualizations using Power BI.
• Perform data analysis, validation, and troubleshooting to ensure data quality and integrity.
• Optimize database performance and ETL processes.
• Collaborate with business users and stakeholders to gather and understand reporting requirements.
• Support data warehousing and business intelligence initiatives.
• Exposure to Azure Data Services (Azure SQL, Azure Data Factory, Synapse Analytics).
• Experience with Power BI DAX and Power Query.
• Knowledge of data governance and reporting best practices.

Skills

SQL

ETL

Data modeling

Analytics

Communication

Problem solving

Education

Bachelor's degree in Engineering

Tools

SSIS

SSAS

Power BI

Job description

Educational Requirements

Bachelor of Engineering

Service Line

Information Systems

Responsibilities

• Develop and maintain database objects, including stored procedures, functions, views, and triggers in SQL Server.
• Design, build, and support ETL packages using SSIS.
• Develop and manage multidimensional/tabular models using SSAS.
• Create interactive dashboards, reports, and visualizations using Power BI.
• Perform data analysis, validation, and troubleshooting to ensure data quality and integrity.
• Optimize database performance and ETL processes.
• Collaborate with business users and stakeholders to gather and understand reporting requirements.
• Support data warehousing and business intelligence initiatives.

Additional Responsibilities

• Exposure to Azure Data Services (Azure SQL, Azure Data Factory, Synapse Analytics).
• Experience with Power BI DAX and Power Query.
• Knowledge of data governance and reporting best practices.

Technical and Professional Requirements

• Strong hands-on experience with Microsoft SQL Server.
• Experience in SSIS for ETL development and data integration.
• Knowledge of SSAS (Multidimensional and/or Tabular Models).
• Proficiency in Power BI report and dashboard development.
• Good understanding of Data Warehouse concepts, Star Schema, and Data Modeling.
• Expertise in SQL query tuning and performance optimization.
• Strong analytical, problem-solving, and communication skills.

Preferred Skills

• Technology->Business Intelligence - Analytics->MSBI (SSAS)
• Technology->Business Intelligence - Reporting->MSBI (SSRS)
• Technology->Business Intelligence - Integration->MSBI (SSIS)
• Technology->SQL SSIS->SQL Server
• Technology->Cloud Platform->Power Platform->Power BI