PUNE · FULLTIME
MSBI Developer 2
Zensar Technologies
Pune · onsite · Posted 20d ago
Sourced from
Undisclosed4–9 yrsfulltimePune
About a minute. You'll make an account on the way through.
agent · working
- Read this posting0.5s
- Found the form on Naukri · 11 questions to answer1.7s
- Decided the answers for all of them2.2s
- Tailor your résumé to this role
- Waiting for you
Section · 01
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.
- Bachelors 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.
- 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.
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
Sourced from naukri
Section · 02
Skills
ssrsTroubleshootingStored ProceduresPerformance TuningSSISPower BiSQLMicrosoftBusiness IntelligenceProduction Support
Section · Company
About Zensar Technologies
Zensar Technologies
IT Services & Consulting
10.0k+
employees
2001
25 years old
Pune, Maharashtra
India
About
Zensar is a global organization that conceptualizes, builds, and manages digital products through experience design, data engineering, and advanced analytics for leading companies.
Industries
IT Services & Consulting
Employee ratings
2,994 reviews
3.7/ 5
Culture
3.5
Career growth
3.0
Work-life
3.8
Employees rate it well for
Work Life Balance442Work Culture366Senior Management300Salary295Job Security229
Find them on