Tuning SQL queries, maintaining data integrity and data consistency, performance tuning and query optimization.
Write Complex SQL (Oracle or SQL Server) Queries/Functions or Procedures to meet the business Requirements.
Become a subject matter expert (SME) in regard to the functional and technical capabilities of Data Warehouse and its connected systems .
Data analysis, design and development of databases for business applications data warehouse environments.
Create SSIS packages to load data into Data Marts and Data warehouse.
Support and maintain all aspects of the data warehouse platform used for data visualization.
Nice to have: Alteryx, Reporting (Tableau/Power BI/SSRS), SSAS
Experience designing and building complete ETL/SSIS processes moving and transforming data for ODS, Staging, and Data Warehousing
Experience with Dimensional modelling
Experience on SSIS & stored procedures, and designing and optimizing tables and processes for ETL migration
SQL development experience
Well versed on change management processes using TFS and promoting code between environments Dev/Test/QA/Production.
Databases: SQL Server 2016/2014/2012/2008 R2, Azure, Postgresql and Oracle
Programming Languages Needed: C#, VB.Net, TSQL, PL/SQL