The candidate will be responsible for designing, developing, enhancing, and supporting scalable Business Intelligence and data integration solutions. The role requires strong SQL development skills, experience building ETL workflows, developing enterprise reports, optimizing database performance, and working with large volumes of data.
Responsibilities
- Design, develop, test, deploy, and maintain MSBI solutions using SSIS, SSRS, SSAS, and SQL Server.
- Develop and maintain complex ETL/ELT workflows using SQL Server Integration Services (SSIS).
- Extract data from multiple data sources, transform it according to business requirements, and load it into data warehouses/data marts.
- Develop efficient T-SQL queries, stored procedures, functions, views, triggers, and scripts.
- Design and develop enterprise reports using SQL Server Reporting Services (SSRS).
- Develop parameterized, drill-down, drill-through, and interactive reports.
- Work with SQL Server Analysis Services (SSAS) for analytical and multidimensional/tabular solutions.
- Design and maintain data warehouses, data marts, fact tables, and dimension tables.
- Apply dimensional modeling concepts including Star and Snowflake schemas.
- Implement data validation, reconciliation, cleansing, transformation, and error-handling processes.
- Analyze and optimize complex SQL queries and stored procedures for better performance.
- Troubleshoot ETL job failures, data issues, and production defects.
- Maintain logging, auditing, exception handling, and restart/recovery mechanisms for ETL processes.
- Develop dashboards and analytical reports using Power BI where required.
- Work with business analysts and stakeholders to understand reporting and data requirements.
- Collaborate with Data Engineers, DBAs, QA teams, and application development teams.
- Participate in code reviews, unit testing, system testing, and deployment activities.
- Follow coding standards, version-control practices, and release-management processes.
- Provide production support and perform root-cause analysis for BI and data-related issues.
- Work in Agile/Scrum teams and participate in sprint planning, daily stand-ups, reviews, and retrospectives.
Qualifications
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline.
- 4+ years of relevant experience in MSBI/Business Intelligence development.
- Strong hands-on experience with SQL Server, T-SQL, SSIS, and SSRS.
- Good understanding of SSAS and Data Warehousing concepts.
- Experience in ETL design, development, testing, and production support.
- Strong SQL development and performance-tuning skills.
- Experience working with large datasets and complex data transformations.
- Strong analytical, troubleshooting, and problem-solving capabilities.
- Experience working in Agile/Scrum environments.
- Good written and verbal communication skills.
- Ability to interact effectively with technical teams and business stakeholders.
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.
— Sarah J.
·
Marketing Manager
★★★★★
Verified
