Msbi Application Developer

Infosys; Bengaluru; Hybrid; INR 900,000 - 1,500,000; Full time

Job summary

Infosys in Bengaluru is hiring a BI/ETL Developer to design, develop, and maintain data integration and reporting solutions using SSIS, SSRS, and SSAS.

You will optimize complex SQL queries, build data warehouses, validate data quality, and collaborate with stakeholders to deliver analytics-driven insights.

This role covers production support, documentation, and ensuring data security and governance within enterprise BI environments.

Responsibilities

• Design, develop, and maintain ETL solutions using SSIS.
• Develop and optimize complex SQL queries, stored procedures, views, and functions.
• Create operational, analytical, and management reports using SSRS.
• Design and develop multidimensional and tabular models using SSAS.
• Perform data extraction, transformation, and loading from multiple data sources.
• Develop and maintain enterprise data warehouse solutions.
• Conduct data validation, reconciliation, and quality checks.
• Troubleshoot and resolve ETL, reporting, and database performance issues.
• Collaborate with business stakeholders to gather reporting and analytics requirements.
• Create and maintain technical documentation for BI solutions.
• Support production deployments and ongoing maintenance activities.
• Ensure data security, governance, and compliance standards are followed.

Job description

• Design, develop, and maintain ETL solutions using SQL Server Integration Services (SSIS).
• Develop and optimize complex SQL queries, stored procedures, views, and functions.
• Create operational, analytical, and management reports using SQL Server Reporting Services (SSRS).
• Design and develop multidimensional and tabular models using SQL Server Analysis Services (SSAS).
• Perform data extraction, transformation, and loading from multiple data sources.
• Develop and maintain enterprise data warehouse solutions.
• Conduct data validation, reconciliation, and quality checks.
• Troubleshoot and resolve ETL, reporting, and database performance issues.
• Collaborate with business stakeholders to gather reporting and analytics requirements.
• Create and maintain technical documentation for BI solutions.
• Support production deployments and ongoing maintenance activities.
• Ensure data security, governance, and compliance standards are followed.