We are looking for a senior SSIS developer to work as a contractor (per direct) able to work autonomously within a (project) team. Someone who can build ETL solutions independently based on functional designs provided by our business analysts, writes technical designs, builds SSIS packages for our new datawarehouse using BIML and has a sound experience with data modeling and data warehousing.
SKILLS AND QUALIFICATIONS
7+ years of experience developing packages using SSIS (SQL Server Integration Services) as ETL tool. Experience with SQL Server 2012 or a higher version is a pre.
Experience of writing complex T-SQL queries and stored procedures
Experience of working with BIML (Business Intelligence Mark-up Language) and generating SSIS packages using metadata.
Sound experience with scheduling and deploying SSIS packages by using SQL Server 2012 catalogue deployment methodology
Significant experience of building SSIS packages for creating slowly changing dimensions of Type 1& 2 dimensions, incremental loads, fact tables, aggregating data, full and incremental loads, de-duplication of records, transforming data and error handling.
Sound experience of ETL Audit and ETL Control
Good understanding of data warehouse concepts, data modeling and database design
Asset management knowledge is a plus
Basic knowledge of writing C# scripts within SSIS
Systematic, disciplined and analytical approach to all work undertaken
Achieving delivery of high quality results
Affinity with IT as well as business processes
Customer and risk awareness
Flexible and pragmatic attitude
Proactive and reliable team player
Er zijn nog geen reacties op deze opdracht.
Je moet inloggen voordat je een reactie kunt plaatsen.