UAT Hadoop Oracle Architect (Jobs in Columbus, OH)   Requirement id 132242 Job title Architect Job location in Columbus, OH Skills required UAT, Test Plans, Hadoop, Oracle Open Date 28-Feb-2022 Close Date Job type Contract Duration 4 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Architect: UAT, Test Plans, Hadoop, Oracle Description: Responsibilities Our client in Columbus Ohio is seeking a Senior Database Architect for a contract role. Candidates should be local to central Ohio or willing to relocate by day one for consideration. The Senior Database Architect will be responsible for data warehouse design, development, implementation, migration, maintenance, and operational activities. The candidate 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 partners. 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 Oracle and 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. Create logical & physical data models. Review and understand existing business logic used in Oracle and Hadoop ETL platforms to verify against the business user needs. Review PySpark programs that are used to ingest historical and incremental data. Review SQOOP scripts to ingest historical data from Oracle database to Hadoop IOP, created HIVE tables and Impala view creation scripts for Dimension tables. Assist Business Analyst to create Test Plan, Design Test scenarios, SQL scripts (prefer Oracle and Hadoop), test or mockup data, executes the test scripts. Validate test results and records as well as log and research defects. Analyze production data issues, report problems and find solutions to fix the issues, if any. Create incidents and tickets to fix production issues, create Support Requests to deploy code for development team to UAT environment. Participate in meetings to continuously upgrade the Functional and technical expertise. Establish priorities & follow through on projects, paying close attention to detail with minimal supervision. Create and present project plan, project status and other dashboards as necessary. Perform other duties as assigned. Requirements Experience in analysis, design, development, support and enhancements in data warehouse environment with Cloudera Bigdata Technologies (with a minimum of 8+ 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+ years) in working Erwin Data Model tool, hive/impala queries, Unix commands, scripting and shell scripting etc. 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 years experience). Experience in analysis, design, development, support and enhancements in data warehouse environment with Cloudera Bigdata Technologies (with a minimum of 8-9 yea   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 132242 while calling.   Other jobs in OH: Cincinnati (1), Cleveland (1), Columbus (233), Dublin (8), Solon (2), UAT job openings in Columbus, OH Jobs List System Test Lead - 59013 Create date: 26-Oct-2021 Description: Responsibilities Our client in Columbus Ohio is seeking a Systems Test Lead. Local candidates are highly preferred. Candidates are required to report onsite on Day 1 of the assignment. A Systems Test Lead plays the lead tester role and is responsible for overseeing the effort for testing, val.... (This job is for - UAT Implementation Jobs in OH Columbus Consultant - (in Columbus, OH)) Software Tester - 58148 Create date: 10-May-2021 Our Client in Columbus, Ohio is seeking an experienced Software Tester for a long-term contract role Note: * CANDIDATES MUST BE LOCAL TO CENTRAL OHIO FOR CONSIDERATION DESCRIPTION: Participate in design sessions to help support UAT Review ST and E2E test cases from multiple vendors.... (This job is for - UAT SLAs Jobs in OH Columbus Tester - (in Columbus, OH)) Mid-Level QA Tester - 62837 Create date: 01-May-2020 Candidate must be our W2 Employee. Candidate must be local : Yes We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens. Job Description : Primary Responsibilities: Responsible for the planning, integration, test casing, scripting and execution of all testing to ensure proper coverag.... (This job is for - UAT ETL Jobs in OH Columbus Tester - (in Columbus, OH)) Sr. QA - 62836 Create date: 01-May-2020 Candidate must be our W2 Employee. Candidate must be local : Yes Job Description : Primary Responsibilities: Responsible for the planning, integration, test casing, scripting and execution of all testing to ensure proper coverage. Schedules and leads test deliverables review sessions as.... (This job is for - UAT QA ETL Jobs in OH Columbus Consultant - (in Columbus, OH)) Program Manager 2/PM2 - 65046 Create date: 12-Sep-2019 Start Date : 9/16/2019 Submission Dead Line : Wednesday, September 18th at 10:00a Client Info : DAS Note: * Interviews: In person only * Duration: On-going Description: This position will function as a highly skilled Business Process Analyst for the Ohio DAS OIT wit.... (This job is for - UAT Jobs in OH Columbus Manager - (in Columbus, OH))    UAT job openings in other states Jobs List ABC - Business Systems Analyst (750352) Create date: 02-Dec-2024 No of Submissions : 2 Start date : 12/16/2024 End Date : 06/30/2025 Submission deadline : 12/5/2024 Client Info : ABC Note: * Agency Interview Type : Web Cam Interview Only * Hybrid Description : 3 days/week ON SITE required from Day 1. No Exceptions.... (This job is for - UAT Jobs in VA Mechanicsville Analyst - (in Mechanicsville, VA)) Senior Quality Assurance Analyst 4 - 128135 Create date: 18-Mar-2024 Start date : 04/15/2024 End date : 12/31/2024 Submission deadline : Friday, 3/22, 3:00PM CST. Client info : DHHS Note : * Interview Process: Virtual through Teams * Duration of the Contract: December 31, 2025, with option to extend. * Onsite or Remote? Remote only..... (This job is for - UAT Jobs in ND Bismark Analyst - (in Bismark, ND)) Project Manager III - 127034 Create date: 09-Feb-2024 Start date : 02/26/2024 End date : 06/30/2024 Submission deadline : 2/12 at 4:00PM CST. Client info : DPI Note : * Interview Process: 1 hr. virtual * Duration of the Contract: Through 6/30/24, possibility of extensions * Onsite or Remote? Candidates MUST be WI reside.... (This job is for - UAT Jobs in WI Madison Manager - (in Madison, WI)) IA-DOM-HHS-ELIAS-QAT2-Manual Tester (722488)` Create date: 24-Oct-2023 Hybrid Start date :11/20/2023 End Date :06/30/2024 Submission deadline :10/27/2023 Client Info :DHS-IMHI: Department of Human Services Description : The client is requesting resources who are local to the Des Moines area. The client has no interest in resources that are looking to .... (This job is for - UAT MS Excel Jobs in IA DesMoines Tester - (in Des Moines, IA)) NCDOT Specialist- Mid Level (705787) Create date: 09-Mar-2023 start date : 04/10/2023 End date : 04/09/2024 submission deadline : 03/15/2023 client info : NCDOT Note : * *Remote mostly; onsite would be requested in advance and the candidate would be expected to be onsite. So not a true hybrid where it is on a regular basis * Hybrid UAT Jobs in NC Raleigh Specialist - (in Raleigh, NC))    UAT job openings in OH Jobs List UAT Test Lead Create date: 25-Sep-2018 Description: Our Columbus, Ohio client is currently seeking a LOCAL UAT Test Lead to fulfill a contract role. The goal of the Domestic Order Management System project is to modernize the digital platform and improve strategic capability. The position will involve providing UAT and organizational change management expertise. He or she wil.... (This job is for - UAT Jobs in OH Reynoldsburg TechLead - (in Reynoldsburg, OH)) Test Lead Create date: 27-Feb-2015 * Call Bala before submitting any resumes to DAS Description: ·Very Strong Communication ·Very Strong Organization ·Has run projects as a test lead before, ability to run testing meetings and present data to larger groups of people ·Can manage a group of testers onshore/offshore ·Ability to escalate and com.... (This job is for - UAT Jobs in OH Mason TechLead - (in Mason, OH)) Performance Test Lead Create date: 25-Feb-2015 * Call Bala before submitting any resumes to DAS Lux is in need of a strong test lead to start in the next couple of weeks. It is for an LC Kronos project, that will run approx.. 4 months. The req will be in the tool on tomorrow if not sooner. Need someone: · Very Strong Communication · Very Strong Organi.... (This job is for - UAT Jobs in OH Mason TechLead - (in Mason, OH)) (Architect: UAT, Test Plans, Hadoop, Oracle in Columbus, OH)

Featured Jobs Agile Analyst (Jobs in Lansing, Michigan) MS Office Written Analyst (Jobs in Lansing, Michigan) SDLC Kanban Manager (Jobs in Austin, Texas) SMS WLM JCL Consultant (Jobs in ANDERSON, South Carolina) JSON Analyst (Jobs in Richmond, Virginia) Cloud Architect (Jobs in Columbia, South Carolina) Web Services SQL Architect (Jobs in Denver, Colorado) Bachelors Analyst (Jobs in Lansing, Michigan) IT Project Management Agile Budgeting Manager (Jobs in Raleigh, North Carol SSIS Analyst (Jobs in Richmond, Virginia)