Waterfall Relational Database SQL Database Hadoop Cloudera Management Pyspark Hive   Requirement id 118677 Job title Architect Job location in Columbus, OH Skills required Data Analysis, Waterfall, Agile Methodologies, Relational Database SQL Database Hadoop Open Date 19-Aug-2021 Close Date Job type Contract Duration 10 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Architect: Data Analysis, Waterfall, Agile Methodologies, Relational Database SQL Database Hadoop Responsibilities: Our Client in Columbus, Ohio is seeking an experienced Senior Database Architect for a long-term contract role CANDIDATES MUST BE LOCAL TO CENTRAL OHIO OR RELOCATED BY DAY ONE FOR CONSIDERATION The Senior Database Architect will be responsible for Enterprise data warehouse 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 Department ITS and will work closely with the Business Intelligence & Data Analytics team. Detailed Day-To-Day Job Duties to be performed: • 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. 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 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 Hadoop, MapReduce, Sqoop, PySpark, Spark, HDFS, Hive, Impala, Stream Sets, Kudu, Oozie, Hue, Kafka, Yarn, Python, Flume, Zookeeper, Sentry, Cloudera Navigator) along   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 118677 while calling.   Other jobs in OH: Cincinnati (1), Cleveland (1), Columbus (233), Dublin (8), Solon (2), Data Analysis job openings in Columbus, OH Jobs List INS-IT Consultant 1/ ITC1 (687972) Create date: 18-Jul-2022 Start date :08/01/2022 End Date :06/30/2023 Submission deadline :07/21/2022 Client Info :INS Description : Preferred Education College Degree Insurance is seeking a Data Analyst to join our IT Team. We are seeking someone who has Data warehouse experience with ETL data flows, .... (This job is for - Business Analyst Jobs in OH Columbus Consultant - (in Columbus, OH)) Sr. Business Analyst - 58537 Create date: 23-Aug-2021 Note: * Interview:Phone or video call Responsibilities: Our Client in Columbus, Ohio is seeking an experienced Sr. Business Analyst for a contract role CANDIDATES MUST BE LOCAL TO CENTRAL OHIO OR RELOCATED BY DAY ONE FOR CONSIDERATION Sr Business Analyst Job Duties to be performe.... (This job is for - job Jobs in OH Columbus Analyst - (in Columbus, OH)) Senior Database Architect 1/SDA1 - 83944 - SP Create date: 07-Apr-2021 start date:05/03/2021 End date:06/30/2021 submission deadline:4/12/2021 client info :MCD Note: * Interviews: Teams * Position location: remote start from Columbus. Must be able to pick up equipment day 1. * REPOST OF 79316 AND 83070 DO NOT RESUBMIT CANDIDAT.... (This job is for - job Jobs in OH Columbus Architect - (in Columbus, OH)) Senior Database Architect 1/SDA1 - 83070 - SP Create date: 10-Mar-2021 start date:3/29/2021 End date:06/30/2021 submission deadline: Monday 3/15 @ 10 am EST Note: * Interviews: Teams * Position location: remote start from Columbus. Must be able to pick up equipment day 1 Description: job Jobs in OH Columbus Architect - (in Columbus, OH)) Sr. Database Architect - 57840 Create date: 01-Mar-2021 Job industry: Public Sector and Government Responsibilities Our Client in Columbus, Ohio is seeking an experienced Sr. Database Architect for a contract role CANDIDATES MUST BE LOCAL TO OHIO FOR CONSIDERATION The Sr Database Architect will be responsible for Enterprise data warehouse design, deve.... (This job is for - Waterfall Jobs in OH Columbus Architect - (in Columbus, OH))    Data Analysis job openings in other states Jobs List Business Intelligence Developer-Data Analytics Strategy Lead Create date: 18-Dec-2024 No of Submissions: 2 Start date : 1/27/2025 End date : 01/23/2026 Submission deadline : 01/03/2025 Client info: CT DAS Note: * Position Location: Remote * Max Rate for this Position is USD 102.50 Per Hour Description: About the Role T.... (This job is for - job Jobs in CT Hartford Developer - (in Hartford, CT)) Technical Specialist IV - B36991W112 Create date: 28-Aug-2024 No of Submissions : 1 Start date : 09/23/2024 End Date : 09/23/2025 Submission deadline : 09/02/2024 Client Info : Bill Rate : USD 95.00 Per Hour Max Rate : USD 103.00 Per Hour Note: * Position Location : Remote * Candidate must be local or willin.... (This job is for - job Jobs in OR Salem Specialist - (in Salem, OR)) Technical Specialist IV - B36991W111 Create date: 28-Aug-2024 No of Submissions : Start date : 09/23/2024 End Date : 09/23/2025 Submission deadline : 09/02/2024 Client Info : ODOT Bill Rate : USD 95.00 Per Hour Max Rate : USD 103.00 Per Hour Note: * Position Location : Remote Description : Respon.... (This job is for - job Jobs in OR Salem Specialist - (in Salem, OR)) Technical Specialist IV - B36991W110 Create date: 28-Aug-2024 No of Submissions : 1 Start date : 09/23/2024 End Date : 09/23/2025 Submission deadline : 09/02/2024 Client Info : ODOT * Bill Rate : USD 95.00 Per Hour * Max Rate : USD 103.00 Per Hour Note: * Position Location : Remote Description : job Jobs in OR Salem Specialist - (in Salem, OR)) VDOT Business Analyst 4 (742717) Create date: 23-Jul-2024 * Hybrid No of Submissions : 2 Start date : 07/29/2024 End Date : 06/30/2025 Submission deadline : 7/26/2024 Client Info : VDOT Note: * Agency Interview Type : Both Phone and In Person * This position requires onsite 3 days a week with 2 remote * Lo.... (This job is for - job Jobs in VA Richmond Analyst - (in Richmond, VA))    Data Analysis job openings in OH Jobs List Data Engineer Level 2 - 63154 Create date: 11-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 : Data Engineer Level 2 - Position Summary Accountable for developing and delivering technological responses to targeted business outcomes. Analyze, de.... (This job is for - Architecture Jobs in OH BlueAsh Engineer - (in BLUE ASH, OH)) SCM Analyst - 56951 Create date: 18-Dec-2019 Note: * Candidate must be our W2 Employee. * This is a very entry level role, please do not submit senior level candidates. Job Description : Performs data analysis for assigned less complex spend categories, Collaborates with Sr. Level analyst on contract negotiations and project, meets with team to id.... (This job is for - job Jobs in OH Cleveland Analyst - (in Cleveland, OH)) GBT Mid Level Data Analyst - 54527 Create date: 23-Oct-2019 Note: * We should take signed RTR form from the candidate (Candidate RTR form should be only on the name of Apex Systems) Job Description : Position: GBT Data Entry Data Analyst x5 Length: Contract through 5/30/2020 Location: Beachwood, OH Shift: 8a-5p The Global Business .... (This job is for - Operation Jobs in OH Cleveland Analyst - (in Cleveland, OH)) Data Analyst Level 1 - 51181 Create date: 13-Aug-2019 Candidate must be our W2 Employee Description:* our client is seeking a Digital Analyst to work with one of our clients in the Greater Cincinnati area. Job requirements are below: Work cross-functionally to generate actionable channel performance reporting for targeted digital interactions for individuals and h.... (This job is for - ECommerce Jobs in OH Cincinnati Consultant - (in Cincinnati, OH)) Global Master Data - Configuration/Operations - 51165 Create date: 13-Aug-2019 We should submit only GC, GC EAD, L2 EAD, H4 EAD and Citizens. Description:* I have a client that is looking to bring on a Global Master Data candidate to join them on a contract to perm basis. This position will require onsite work in either Cincinnati, OH or Detroit, MI. The candidate in this role will part.... (This job is for - ERP Jobs in OH Cincinnati Consultant - (in Cincinnati, OH)) (Architect: Data Analysis, Waterfall, Agile Methodologies, Relational Database SQL Database Hadoop in Columbus, OH)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)