Description
Sr. Developer - MS SSIS & TSQL
Brussels
3-months contract
Experience: overall 6+ years in Data Warehouse & ETL
Job Description:
- Participate in the development and support of MSBI applications
- Obtain and understand requirements from business analyst or customer
- Troubleshoot code and performance issues
- Analyze source data, understand relationships, constraints, keys etc..
- Create SSIS packages, building medium to complex transformations and create SSAS multidimensional cubes using SQL Server R2 or higher
- Test SSIS packages & Cubes as per the requirements
- Interpret written business requirements and technical specification documents
- Create and maintain technical design documentation
Desired Skills & Experience
ü Should have strong fundamentals in ETL and Data warehouse concepts
ü Experience in building application using SQL Server R2 or higher
ü Experience in creating SSIS packages, procedures and schedules
ü Technically strong at SSIS, SSAS concept, Cube Design & Build
ü Understand and write medium to complex MDX queries
ü Should be able write SQL queries for SQL Server and Oracle
ü Strong Hands on experience in Procedure/Function/SSIS packages
ü Knowledge in effort estimation, planning and monitoring tasks to completion
ü Communicate/coordinate with multiple teams to understand requirements and challenges
ü Should have excellent written and verbal communication skills
ü Must have good analytical and communication skills
ü Good to Have - Advanced SQL and SSIS certification