MSBI Developer 2

Zensar
Apply Now ↗
📍 Pune, Maharashtra, India

About this role

The ideal candidate should have excellent SQL development skills, hands-on experience with the Microsoft BI technology stack, and the ability to translate business requirements into reliable data and reporting solutions.
  • Design, develop, test, deploy, and maintain MSBI solutions using SQL Server and Microsoft BI technologies.
  • Develop and maintain SSIS packages for ETL and data integration processes.
  • Extract, transform, and load data from multiple heterogeneous data sources into data warehouses and data marts.
  • Design and develop complex T-SQL queries, stored procedures, functions, views, triggers, and scripts.
  • Develop, enhance, and maintain SSRS reports, including parameterized, drill-down, drill-through, and operational reports.
  • Develop and maintain SSAS Tabular and/or Multidimensional models based on project requirements.
  • Work on data warehouse design, including fact tables, dimension tables, star schemas, and snowflake schemas.
  • Perform data analysis, data validation, reconciliation, and troubleshooting.
  • Optimize SQL queries, stored procedures, ETL processes, and reports to improve application performance.
  • Troubleshoot production issues related to ETL jobs, databases, reporting, and data quality.
  • Implement error handling, logging, auditing, and restart/recovery mechanisms within ETL solutions.
  • Schedule and monitor ETL processes using SQL Server Agent or enterprise scheduling tools.
  • Collaborate with business analysts, data architects, application teams, and business stakeholders to understand reporting and analytical requirements.
  • Participate in code reviews, unit testing, integration testing, deployment, and production support.
  • Prepare and maintain technical documentation, data mappings, ETL specifications, and deployment documents.
  • Follow development standards, version-control practices, and CI/CD processes.
  • Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline.
  • 4+ years of hands-on experience in MSBI/Business Intelligence development.
  • Strong experience developing ETL processes using SSIS.
  • Strong SQL programming and performance-tuning experience.
  • Hands-on experience developing reports using SSRS.
  • Experience with SSAS Tabular or Multidimensional models.
  • Good understanding of relational databases, data warehousing, and dimensional modeling.
  • Ability to analyze complex business requirements and convert them into technical BI solutions.
  • Strong analytical, troubleshooting, and problem-solving capabilities.
  • Good communication and stakeholder-management skills.
  • Ability to work independently as well as within geographically distributed teams.
At Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.

Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.

We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.

Frequently Asked Questions

Is the salary disclosed for the MSBI Developer 2 position at Zensar?
The salary for this MSBI Developer 2 role at Zensar is not publicly listed. Click "Apply Now" to learn more about the compensation package on their official careers page.
Where is the MSBI Developer 2 position at Zensar located?
This MSBI Developer 2 role at Zensar is based in Pune, Maharashtra, India. The position is listed as on-site or hybrid. Check the full job description or apply directly to confirm the work arrangement.
How do I apply for the MSBI Developer 2 position at Zensar?
Click the "Apply Now" button on this page. You will be redirected to Zensar's official application portal hosted on oraclecloud where you can submit your application directly.
When was the MSBI Developer 2 job at Zensar posted?
This MSBI Developer 2 position at Zensar was posted on Sep 30, 2026. Apply as soon as possible — early applications are often reviewed first.
MSBI Developer 2
Zensar
Apply for this role ↗

You'll be redirected to Zensar's official application page on oraclecloud.