Description

You will design and implement data architectures within data warehouse environments using relational and big data platforms.

Responsibilities

• Design data vault and dimensional models to support complex data warehouse requirements.
• Elicit, analyze, and document functional and non-functional requirements, including business decisions and meeting minutes.
• Perform data profiling, cleansing, and quality analysis across various layers using Oracle and Big Data platforms.
• Identify data anomalies and build datasets while maintaining familiarity with PHI and PII data protocols.
• Lead data migration efforts from relational databases to Hadoop platforms.

Required Skills

• 12+ years of data analysis and architecture experience in Waterfall and Agile methodologies.
• 8-9 years of experience with Oracle, Hive, and Impala for creating DDLs and DMLs.
• 8-9 years of experience with Cloudera Big Data technologies.
• 8-9 years of experience using Erwin Data Model tool, Unix commands, and shell scripting.
• Strong expertise in relational databases and Hadoop big data platforms.
• Proven ability in data vault and dimensional model design.
• Proficiency with Visio, Excel, PowerPoint, and Word.

Preferred Skills

• Experience in healthcare domains.
• Experience migrating data from Oracle to Hadoop.

Key Skills

Education

ANY GRADUATE