Azure DATA ENGINEER Resume New York, NY - Hire IT People

SUMMARY

Experienced in delegating and coordinating development and testing with the Teams
4 + Years of Data Integration/ETL development experience
3+ Years of ETL design using Microsoft SSIS
3+ Years of SQL Server Experience with versions 2014 and/or 2016/2017
3+ Years of BI reporting tools
Understanding of Enterprise Data warehouse data models and dimensional modeling concepts, source to target mapping and Data Integration architecture
MS Office Suite, MS Visio

TECHNICAL SKILLS

SQL Server 2014/2016/2017 , SQL Server Integration Services (SSIS), Azure SQL Database, Azure SQL Datawarehouse, Ploybase, Azure Data Factory, Azure Storage ( Blob), Azure Data Lake, Azure Resource Management Templates (ARM), Microsoft Visual Studio/SSDT, AzCopy, Azure Storage Explorer, PowerBI Desktop

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Azure DATA ENGINEER

Responsibilities:

Create and maintain optimal data pipeline architecture on Azure platform
Develop batch processing solutions by using Data Factory
Ingest data using Polybase
Implement Azure Data Factory pipelines, Triggers and Integration Runtime
Assemble large, complex data sets that meet functional / non - functional business requirements.
Design relational and non-relational data stores on Azure
Design security for source data access. Chose the appropriate authentication mechanism, such as access keys, shared access signatures SAS), and Azure Active Directory (Azure AD)
Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources
Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.

Confidential, Dearborn, MI

SSIS DEVELOPER

Responsibilities:

Developing data links and data loading scripts, including data transformations, reconciliations and accuracies
Have a participated in all phases of Software Development Lifecycle (SDLC)
Have advanced knowledge of T-SQL, ETL and Data Warehousing
Designing BI solutions with Microsoft SQL Server 2014 / 2016
Building state-of-art reports that deliver information in a user-friendly and efficient way
Querying Microsoft SQL Server 2014 / 2016
Looking for root causes in case of solution failures

Confidential, OK

SSIS DEVELOPER

Responsibilities:

Follows change management process to resolve application defects or to implement development enhancements
Identify problems, develop ideas and propose solutions within differing situations requiring analytical, evaluative or constructive thinking in daily work
Document designs and architect data maps, develop data quality components and establish and/or conduct unit tests
Create/maintain design related artifacts i.e. data models, Mapping documents, architecture diagrams, data flow diagrams
Assist business team with BI reporting in conjunction with ETL workload
Evaluating data file submissions and developing/maintaining SSIS packages for ETL processes
New development as scoped and requested by the business

Confidential, El Dorado, AR

JUNIOR SSIS DEVELOPER

Responsibilities:

Communicating design and other technical information both verbally and in written format
Create source to target mappings and ETL design for integration of new/modified data streams into the data warehouse/data marts
Proficient in leading and managing the development resources
Create Dimensional models using ERWIN or other data modeling tools
Proactive and diligent in identifying and communicating scope, design, development issues and recommending potential solutions
Designe, develop, modify, test, implement, and document applications upgrades
Perform Data profiling and analysis of structured and unstructured data
Deliver projects/work on-time, on-budget, and in a way that accomplishes client goals