Description
Position: Microsoft Certified Solution Associate
Location: Stockholm, Sweden
Duration: 4 - 6 months
Job Description:
- Very strong hand-on experience is SSIS
- Good experience in developing solutions using the MSBI stack particularly in SSIS
- Very strong Database related concepts for example procedures and packages using PL/SQL, Indexes, performance tuning,
- Implementation end to end packages that must include variables, parameters, expressions, exception handling, transactions, Script task, Script component using C#
- Perform data profiling and source to target mappings (while capturing ETL and business metadata) for populating different styles of dimensional schemas.
- Fact ETL, Dimension ETL and advanced including slow changing dimensions and late arrivals
- Conduct appropriate functional and performance testing to identify bottlenecks and data quality issues.
- Collaborate with business users, other data services team members, and other developers throughout the organization to help everyone understand issues that affect the data warehouse