Database Architect

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.