Looking for a strong data warehouse designer and implementation engineer for short-term assignment.
***If you don't have this skill, please don't apply. ****
You will be required to provide specific examples from prior work and might be required to attend a technical interview.
Please read the job description thoroughly before applying. In order to be successful, you must have #1. Strong data warehouse design and implementation background. #2. intimate knowledge of implementing ETLs using SQL Server 2012 is essential.
Task #1: You will be required to review and finalizing our data warehouse design strategy, data model and star schema (dimensional model) resulting from a data transformation ( from AS/400 system data being brought into SQL server 2012. You don’t need to know AS/400, but if you do it will be great.)
Task #2: You will create, and enhance our ETL, using SQL server 2012 SSIS. We are running SQL server 2012 platform, So, prior knowledge in either SQL server 2012 or 2005 with complex SSIS work would be a great plus. SQL development in SQL stored procedures, T-SQL, SSIS Expression builder will be critical to have.