ACAcme Services
DW Developer
Mumbai ₹4-7 LPA Posted 18 Jul 2025
FULL TIME
Sql Server Integration Services
Azure Sql
Sql Server
Mdx
Job Description
- Develop and support end to end Data Warehouse and Business
- Intelligence solutions for analytics and management teams
- Create complex queries, data transformation, aggregation, stored
- procedures, and triggers
- Consult with business partners such as marketing analysts,
- management, and other developers to clarify program objectives,
- determine scope, identify problems and recommend solutions
- Performance tune ETL, stored procedures, and reports to keep
- databases and applications optimized; identify root causes in case of
- ETL failures
- Perform code reviews, data validation, and system testing for data
- warehouse changes
- Interact closely with members of both IT and the business
- Candidate Specification:
- Expert knowledge of Transact-SQL
- Experience of the following technologies is required: SQL Server
- 2008/12, Azure SQL, SQL Server Integration Services, SQL Server
- Analysis Services
- Experience of BI tools like Power BI, Tableau or any other tool
- Knowledge of Azure Data Factory, Azure Synapse Services would be
- added advantage
- Experience modelling and designing Relational Databases, Star
- Schemas, and cubes
- Ability to innovate, multi-task and set priorities effectively
- Experience in logical and physical data modelling
- Ability to quickly understand both business and technical concepts
- Self-starter with strong verbal and written communication skills
- Experience with using MDX to query Analysis Services cubes