Database Architect

Job Code : EWC - 1561

   12+ years Data analysis/architecture experience in Waterfall and Agile Methodology in various domains (prefer Healthcare) in a data warehouse environment.

•  Good knowledge of relational database, Hadoop big data platform and tools, data vault and dimensional model design.
•  Strong SQL experience (prefer Oracle, Hive and Impala) in creating DDL’s and DML’s in Oracle, Hive and Impala (minimum of 8-9 years’ experience).
•  Experience in analysis, design, development, support and enhancements in data warehouse environment with Cloudera Bigdata Technologies (with a minimum of 8-9 years’ experience in data analysis, data profiling, data model, data cleansing and data quality analysis in various layers using Database queries both in Oracle and Big Data platforms).
•  Experience (minimum of 8-9 years) in working Erwin Data Model tool, hive/impala queries, Unix commands, scripting and shell scripting etc.
•  Experience in migrating data from relational database (prefer Oracle) to big data – Hadoop platform is a plus.
•  Experience eliciting, analyzing and documenting functional and non-functional requirements.
•  Ability to document business, functional and non-functional requirements, meeting minutes, and key decisions/actions.
•  Experience in identifying data anomalies.
•  Experience building data sets and familiarity with PHI and PII data.
•  Ability to establish priorities & follow through on projects, paying close attention to detail with minimal supervision.
• Effective communication, presentation, & organizational skills.
• Good experience in working with Visio, Excel, PowerPoint, Word, etc.
•  Effective team player in a fast paced and quick delivery environment.
•  Required Education: BS/BA degree or combination of education & experience. DESIRED Skill Sets:
• Demonstrate effective leadership, analytical and problem-solving skills
•  Required excellent written and oral communication skills with technical and business teams.
•  Ability to work independently, as well as part of a team
•  Stay abreast of current technologies in area of IT assigned Establish facts and draw valid conclusions
•  Recognize patterns and opportunities for improvement throughout the entire organization
• Ability to discern critical from minor problems and innovate new solutions