DE&A - AIML - Data Science - Data Science (Other)
Job Description
Senior Data Engineer (MSBI)
Must-Have Skills (Core 4)
1. Strong SQL / T-SQL
• Advanced querying, performance tuning, stored procedures, indexing
• Hands-on with SSMS and complex data transformations
2. SSIS (ETL Development)
• Designing and developing ETL pipelines using SSIS
• Handling data migration, transformation, and scheduling jobs
3. Data Warehousing Concepts
• Strong understanding of star/snowflake schema
• Experience in designing fact/dimension models and data marts
4. SSRS / Reporting
• Developing and maintaining reports using SSRS
• Exposure to report optimization and parameterisation
Nice-to-Have Skills (Add-ons 4)
1. SSAS / OLAP Cubes
• Experience with multidimensional/tabular models
2. Power BI / Visualisation
• Dashboard development, DAX basics, data modelling
3. Performance Tuning & Optimisation
• Query tuning, ETL performance improvement, indexing strategies
4. Cloud Exposure
• Azure Data Factory, Azure SQL, Synapse or similar platforms
Optional Add-ons (If you want a stronger JD)
• Experience with DevOps (CI/CD for ETL)
• Exposure to data governance/data quality frameworks
Senior Data Engineer (MSBI)
Must-Have Skills (Core 4)
1. Strong SQL / T-SQL
• Advanced querying, performance tuning, stored procedures, indexing
• Hands-on with SSMS and complex data transformations
2. SSIS (ETL Development)
• Designing and developing ETL pipelines using SSIS
• Handling data migration, transformation, and scheduling jobs
3. Data Warehousing Concepts
• Strong understanding of star/snowflake schema
• Experience in designing fact/dimension models and data marts
4. SSRS / Reporting
• Developing and maintaining reports using SSRS
• Exposure to report optimization and parameterisation
Nice-to-Have Skills (Add-ons 4)
1. SSAS / OLAP Cubes
• Experience with multidimensional/tabular models
2. Power BI / Visualisation
• Dashboard development, DAX basics, data modelling
3. Performance Tuning & Optimisation
• Query tuning, ETL performance improvement, indexing strategies
4. Cloud Exposure
• Azure Data Factory, Azure SQL, Synapse or similar platforms
Optional Add-ons (If you want a stronger JD)
• Experience with DevOps (CI/CD for ETL)
• Exposure to data governance/data quality frameworks
Senior Data Engineer (MSBI)
Must-Have Skills (Core 4)
1. Strong SQL / T-SQL
• Advanced querying, performance tuning, stored procedures, indexing
• Hands-on with SSMS and complex data transformations
2. SSIS (ETL Development)
• Designing and developing ETL pipelines using SSIS
• Handling data migration, transformation, and scheduling jobs
3. Data Warehousing Concepts
• Strong understanding of star/snowflake schema
• Experience in designing fact/dimension models and data marts
4. SSRS / Reporting
• Developing and maintaining reports using SSRS
• Exposure to report optimization and parameterisation
Nice-to-Have Skills (Add-ons 4)
1. SSAS / OLAP Cubes
• Experience with multidimensional/tabular models
2. Power BI / Visualisation
• Dashboard development, DAX basics, data modelling
3. Performance Tuning & Optimisation
• Query tuning, ETL performance improvement, indexing strategies
4. Cloud Exposure
• Azure Data Factory, Azure SQL, Synapse or similar platforms
Optional Add-ons (If you want a stronger JD)
• Experience with DevOps (CI/CD for ETL)
• Exposure to data governance/data quality frameworks
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.