Data Integration Developer

Title: Data Warehouse Specialist I

Location: BOSTON, MA

Duration: 6 Months 

Job Description:

Data Architecture

• Logical data model adaptation – using skills including Erwin, Business Analysis, Data modeling

• Reconcile logical model with data

• Model the physical data models

• Data profiling – Information analyzer/Excel preferred

Data Analysis, Modeling and Design

• Complete Data Analysis/Mapping

• Model client data

• Make key physical design decisions which will impact how the data is distributed in client’s environment. 

• Enable Data Views via Physical/Virtual marts or via other presentation tools. 

• Maintain metadata within the metadata management tool.

Activities

• High-level design using Business Analysis, Microsoft Azure Platform Knowledge, Blob Storage API Knowledge

• Hadoop cluster configuration using Hadoop big data architecture

• Data ingestion/curation using Pig, Hive, Sqoop or other Hadoop tools

• Update design documents

• Orchestrate data workflows

• Build security and audit controls using Hadoop ecosystem

• Performance tuning of Hadoop ecosystem