| Senior Database Architect-Columbus, OH-Hybrid-only local at Columbus, Ohio, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1087270&uid= From: Naveen, Halcyon solution [email protected] Reply to: [email protected] Hello Greeting !!! We have an urgent requirement for the below-given role, please revert me if you are available and interested with your updated resume. Title: MCD - Senior Database Architect 1 / SDA (725752) Location: Columbus, OH-Hybrid Duration: long term Contract Hybrid - onsite Tuesday and Thursday The Senior Database Architect will be responsible for Medicaid Enterprise Data Warehouse (EDW) design, development, implementation, migration, maintenance, and operational activities. The candidate will closely with Data Governance and Analytics team. Will be one of the key technical resource for data warehouse projects for various Enterprise Data Warehouse projects and building critical data marts, data ingestion to Big Data platform for data analytics and exchange with State and Medicaid partners. This position is a member of Medicaid ITS and OST closely with the Business Intelligence & Data Analytics team. Responsibilities: Participate in Team activities, Design discussions, Stand up meetings and planning Review with team. Perform data analysis, data profiling, data cleansing and data quality analysis in various layers using Database queries both in Big Data platforms. Eliciting, analyzing and documenting functional and non-functional requirements. Document business requirements, meeting minutes, and key decisions/actions. Lead client meetings and sessions with data-driven analysis to clarify requirements and design decisions. Perform data gap and impact analysis due to new data addition and existing data changes for any new business requirements and enhancements. Follow the organization design standards document, create data mapping specification document, pseudo codes for the development team(s) and design documents. REQUIRED Skill Sets: 8+ 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 DDLs and DMLs 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. Naveen Goud, Senior US IT Recruiter Halcyon Solutions Inc. Direct: Email: [email protected] Naveen Goud | LinkedIn Delivering the very best in IT talent and consulting for private, public and federal sector clients since 1992. Keywords: business analyst information technology Ohio http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1087270&uid= |
| [email protected] View All |
| 02:15 AM 06-Feb-24 |