SSIS, SSAS, SSRS, MSBI

Infosys Limited; Pune District; On-site; INR 1,200,000 - 2,100,000; Full time

Job summary

Infosys Limited in Pune seeks a BI developer with 5–8 years of experience to lead MSBI solutions using SSIS, SSAS, and SSRS. You will design ETL packages, build SSAS models, and develop SSRS reports, while tuning SQL queries for performance and reliability.

Strong SQL skills and Python knowledge for data processing are required, with mentoring responsibilities and involvement in production deployments.

Qualifications

• BTECH, MTECH, MCA, or MSC.
• 5–8 years of experience delivering BI solutions using SSIS, SSAS, SSRS, and MSBI.
• Strong hands-on expertise in SQL including query writing, optimization, and database objects.
• Proven experience building ETL workflows in SSIS with robust logging, error handling, and scheduling.
• Experience developing SSAS models and SSRS reports with focus on performance and correctness.
• Working knowledge of Python for data processing, automation, or integration tasks supporting BI delivery.

Responsibilities

• Lead end-to-end development and support of MSBI solutions using SSIS, SSAS, and SSRS.
• Design, develop, and optimize SSIS ETL packages including data extraction, transformation, loading, scheduling, and error handling.
• Build and maintain SSAS models, measures, KPIs, hierarchies, and partitions aligned to business reporting needs.
• Develop SSRS reports, datasets, and subscriptions; ensure report accuracy, usability, and performance.
• Write and tune complex SQL queries, stored procedures, and views to support ETL and reporting workloads.
• Perform performance tuning for ETL, cube/model processing, and reporting; analyze bottlenecks and implement improvements.
• Drive requirement discussions with stakeholders, convert needs into technical designs, and ensure timely, quality delivery.
• Implement data validation, reconciliation checks, and monitoring to improve reliability and data quality.
• Provide technical guidance, code reviews, and mentoring to team members; promote best practices and standards.
• Support production deployments, troubleshooting, and root-cause analysis with clear documentation and communication.

Skills

SSIS

SSAS

SSRS

MSBI

SQL

Python

Education

BTECH

MTECH

MCA

MSC

Tools

SSIS

SSAS

SSRS

MSBI

Job description

Job ID/Reference Code INFSYS-INDEED1-252735

Work Experience 5 - 8 Years

Job Title SSIS, SSAS, SSRS, MSBI

Educational Requirements

MCA,MSc,MTech,Bachelor of Engineering,BTech

Service Line

Data & Analytics Unit

Responsibilities

Key Responsibilities:

• Lead end-to-end development and support of MSBI solutions using SSIS, SSAS, and SSRS across multiple subject areas.
• Design, develop, and optimize SSIS ETL packages including data extraction, transformation, loading, scheduling, and error handling.
• Build and maintain SSAS tabular/multidimensional models, measures, KPIs, hierarchies, and partitions aligned to business reporting needs.
• Develop SSRS reports, datasets, and subscriptions; ensure report accuracy, usability, and performance.
• Write and tune complex SQL queries, stored procedures, and views to support ETL and reporting workloads.
• Perform performance tuning for ETL, cube/model processing, and reporting; analyze bottlenecks and implement improvements.
• Drive requirement discussions with stakeholders, convert needs into technical designs, and ensure timely, quality delivery.
• Implement data validation, reconciliation checks, and monitoring to improve reliability and data quality.
• Provide technical guidance, code reviews, and mentoring to team members; promote best practices and standards.
• Support production deployments, troubleshooting, and root-cause analysis with clear documentation and communication.

Minimum Qualifications:

• BTECH, MTECH, MCA, or MSC.
• 5–8 years of experience delivering BI solutions using SSIS, SSAS, SSRS, and MSBI.
• Strong hands-on expertise in SQL including query writing, optimization, and database objects (views, stored procedures).
• Proven experience building ETL workflows in SSIS with robust logging, error handling, and scheduling.
• Experience developing SSAS models and SSRS reports with a focus on performance and correctness.
• Working knowledge of Python for data processing, automation, or integration tasks supporting BI delivery.

Additional Responsibilities:

Preferred Qualifications:

• Experience designing dimensional data models (star/snowflake) and applying BI best practices for analytics-ready datasets.
• Strong troubleshooting skills across ETL, semantic models, and reporting layers with a structured approach to root-cause analysis.
• Experience with Python libraries for data handling and automation (e.g., Pandas) to complement BI workflows.
• Exposure to version control and release practices for BI assets; ability to maintain clean, reusable, well-documented code.
• Demonstrated leadership in coordinating deliveries, improving team standards, and collaborating effectively with business stakeholders.

Technical and Professional Requirements:

Primary skills:Technology->Business Intelligence - Analytics->MSBI (SSAS)Technology->Business Intelligence - Reporting->MSBI (SSRS)Technology->SQL SSIS->SQL Server

Preferred Skills:

Technology->Business Intelligence - Analytics->MSBI (SSAS) Technology->Business Intelligence - Reporting->MSBI (SSRS) Technology->SQL SSIS->SQL Server