Description
Role and Responsibilities:
- Develop and maintain new and existing ETL or data feed processes using SQL Server Integration Services (SSIS) and T-SQL.
- Develop and maintain Business Intelligence (BI) solutions using technologies such as SSRS.
- Design and implement solutions that meet key requirements for audit, data quality, performance, scalability and security.
- Design and implement solutions that handle multiple data -sources in the same data model.
- Design and develop SSAS cubes.
- Develop and maintain new and existing ETL or data feed processes using SQL Server Integration Services (SSIS) and T-SQL
Desired Skills:
- Strong development experience using the Microsoft BI stack (SQL Server R2).
- Strong T-SQL development experience.
- Strong experience with SSIS developing end to end ETL processes for large scale data warehouse.
- Familiar with using other data sources in SSIS like Sybase, Oracle, flat files, web services and message queues.
- Working knowledge and experience of using SSRS.
- Strong experience with SSIS developing end to end ETL processes for large scale data warehouse.
- Knowledge of Datamodelling techniques (Kimball preferred).
- Knowledge of Business Objects a plus.