MSBI Developer (SQL Server Integration Services & Power BI Specialist)

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

Job summary

Infosys seeks an MSBI Developer to design, build, and optimize ETL pipelines with SSIS, and to create robust reports using SSRS and Power BI. You will develop OLAP models with SSAS, implement star/snowflake schemas, and ensure data integrity across BI solutions.

The role involves tuning query performance, collaborating with business stakeholders, and supporting deployments. Strong SQL Server expertise is essential for success.

Qualifications

• Strong experience in Microsoft SQL Server.
• Hands-on experience with: SSIS, SSRS, SSAS.
• Expertise in T-SQL, Stored Procedures, Triggers, Views, and Query Optimization.
• Experience in Data Warehousing concepts and ETL development.
• Knowledge of OLAP Cubes, Tabular Models, and Data Modeling.
• Understanding of database performance tuning and indexing strategies.
• Experience with SQL Server Agent jobs and deployment processes.
• Strong analytical and problem-solving skills.

Responsibilities

• Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS).
• Develop and optimize complex SQL queries, stored procedures, views, and functions.
• Create and maintain reports and dashboards using SQL Server Reporting Services (SSRS).
• Develop multidimensional and tabular data models using SQL Server Analysis Services (SSAS).
• Design and implement data warehouse solutions using Star and Snowflake schemas.
• Perform data extraction, transformation, and loading activities from multiple source systems.
• Monitor ETL jobs and troubleshoot data quality and performance issues.
• Work closely with business stakeholders to gather reporting and analytics requirements.
• Ensure data integrity, security, and compliance across BI solutions.
• Optimize SQL Server databases and BI applications for performance and scalability.
• Support production deployments, enhancements, and maintenance activities.

Skills

SQL proficiency

Analytical problem-solving

Data warehousing concepts

Tools

SSIS

SSRS

SSAS

Power BI

T-SQL

Job description

MSBI Developer

Primary skills: Technology->Business Intelligence - Integration->MSBI (SSIS), Technology->Business Intelligence - Visualization->MSBI (Power BI)

Responsibilities

• Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS).
• Develop and optimize complex SQL queries, stored procedures, views, and functions.
• Create and maintain reports and dashboards using SQL Server Reporting Services (SSRS).
• Develop multidimensional and tabular data models using SQL Server Analysis Services (SSAS).
• Design and implement data warehouse solutions using Star and Snowflake schemas.
• Perform data extraction, transformation, and loading activities from multiple source systems.
• Monitor ETL jobs and troubleshoot data quality and performance issues.
• Work closely with business stakeholders to gather reporting and analytics requirements.
• Ensure data integrity, security, and compliance across BI solutions.
• Optimize SQL Server databases and BI applications for performance and scalability.
• Support production deployments, enhancements, and maintenance activities.

Required Skills

• Strong experience in Microsoft SQL Server.
• Hands-on experience with: SSIS (SQL Server Integration Services) SSRS (SQL Server Reporting Services) SSAS (SQL Server Analysis Services)
• Expertise in T-SQL, Stored Procedures, Triggers, Views, and Query Optimization.
• Experience in Data Warehousing concepts and ETL development.
• Knowledge of OLAP Cubes, Tabular Models, and Data Modeling.
• Understanding of database performance tuning and indexing strategies.
• Experience with SQL Server Agent jobs and deployment processes.
• Strong analytical and problem-solving skills.