Enquero Dublin , CA 94568
10+ years experience in Data Engineering with specializing in Microsoft SQL Server and SSIS or any other ETL tool.
Hands-on Experience in working on Microsoft SQL Server and SSIS ETL
Prior Applications developments using Microsoft SQL Server as RDMS using agile methodology
Experience in Microsoft SQL Server (DB) performance tuning of SQL.
Experience in Application integration with Microsoft SQL DW and build of analytical views
Experience in data migration from one database or filesystem to Microsoft SQL Server (DB) using SQL Server Integration Services (SSIS). Must have handled a few conversion/integrations with high volume of data e.g. 4TB+.
Ability to perform detailed study of the current processes and gather requirements from business stakeholders
Hands-on in data analysis, data capture, and data mapping.
Ability to work in agile or waterfall delivery environment and work with evolving requirements balancing the short-term and long-term.
Microsoft Azure SQL Database.
Microsoft Azure SQL Data warehouse.
Microsoft Azure Data Factory using Pipeline and SSIS.
Design and modelling of Data warehouse.
Usage of JMeter or any tool for performance benchmarking
Must be able to create Data Flow Diagrams and process flow diagrams
Must be able to create AS-IS and TO-BE (as needed) process documentation along with requirements documentation
Data modelling for OLTP and OLAP
Performance tuning of SQL running on SQL Server/DB
MS Office, Visio fluency and PowerPoint is a must
Microsoft SQL Server, SSIS ETL, Data Warehouse, Pipeline, Azure, Jmeter, Dataflow, AS-IS, OLTP, OLAP, Visio