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