Analysis Hadoop Data Warehousing Design And Development ETL Applications Pyspark SQL   Requirement id 114912 Job title Specialist Job location in Columbus, OH Skills required Analysis, Big Data, Hadoop, Data Warehousing Design And Development Open Date 10-Mar-2021 Close Date Job type Contract Duration 3 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Specialist: Analysis, Big Data, Hadoop, Data Warehousing Design And Development start date:3/15/2021 End date:06/30/2021 submission deadline:Monday 3/15 @ 10 am EST client info : MCD Note: * Interviews: TEAMS Description: The Technical Specialist will be responsible for Medicaid Enterprise data warehouse design, development, implementation, migration, maintenance and operation activities. Works closely with Data Governance and Analytics team. 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 works 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 quality and data ingestion in various layers using big data/Hadoop/Hive/Impala queries, PySpark programs and UNIX shell scripts. • Follow the organization coding standard document, Create mappings, sessions and workflows as per the mapping specification document. • Perform Gap and impact analysis of ETL and IOP jobs for the new requirement and enhancements. • Create jobs in Hadoop using SQOOP, PYSPARK and Stream Sets to meet the business user needs. • Create mockup data, perform Unit testing and capture the result sets against the jobs developed in lower environment. • Updating the production support Run book, Control M schedule document as per the production release. • Create and update design documents, provide detail description about workflows after every production release. • Continuously monitor the production data loads, fix the issues, update the tracker document with the issues, Identify the performance issues. • Performance tuning long running ETL/ELT jobs by creating partitions, enabling full load and other standard approaches. • Perform Quality assurance check, Reconciliation post data loads and communicate to vendor for receiving fixed data. • Participate in ETL/ELT code review and design re-usable frameworks. • Create Remedy/Service Now tickets to fix production issues, create Support Requests to deploy Database, Hadoop, Hive, Impala, UNIX, ETL/ELT and SAS code to UAT environment. • Create Remedy/Service Now tickets and/or incidents to trigger Control M jobs for FTP and ETL/ELT jobs on ADHOC, daily, weekly, Monthly and quarterly basis as needed. • Model and create STAGE / ODS / Data warehouse Hive and Impala tables as and when needed. • Create Change requests, workplan, Test results, BCAB checklist documents for the code deployment to production environment and perform the code validation post deployment. • Work with Hadoop Admin, ETL and SAS admin teams for code deployments and health checks. • Create re-usable UNIX shell scripts for file archival, file validations and Hadoop workflow looping. • Create re-usable framework for Audit Balance Control to capture Reconciliation, mapping parameters and variables, serves as single point of reference for workflows. • Create PySpark programs to ingest historical and incremental data. • Create SQOOP scripts to ingest historical data from EDW oracle database to Hadoop IOP, created HIVE tables and Impala views creation scripts for Dimension tables. • Participate in meetings to continuously upgrade the Functional and technical expertise. * KS Consultant Job Title: Technical Specialist 3 Detailed Day-To-Day Job Duties to be performed:   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 114912 while calling.   Other jobs in OH: Cincinnati (1), Cleveland (1), Columbus (233), Dublin (8), Solon (2), Analysis job openings in Columbus, OH Jobs List DRC-Tester 4/ T4 (748158) Create date: 30-Sep-2024 No of Submissions : 3 Start date : 11/04/2024 End Date : 06/30/2025 Submission deadline : 10/03/2024 Client Info : DRC Note : * 100% Remote Description : ODRC expects a more senior Tester to be extremely well rounded member of a team which plans, constructs.... (This job is for - Analysis Jobs in OH Columbus Consultant - (in Columbus, OH)) Business Systems Analyst IT-III Senior-20230222045827 Create date: 23-Feb-2023 Start date : 3/15/2023 End Date : 7+Months from the start date Submission deadline : 03-01-2023 Note: * Job Site On-Site Description : --------------------------------------------- 5+ years expierence in technolgoy organizations manage multiple IT projects that includes managing.... (This job is for - Analysis Jobs in OH Columbus Analyst - (in Columbus, OH)) COM-Business Analyst 4 /BA4 (682711) Create date: 19-May-2022 Start Date : 05/23/2022 End Date : 06/30/2022 Submission Deadline : 05/10/2022 Client Info : COM Description : Requirement Description: This position will function as a highly skilled BA4 for Ohio Department of Commerces Project Management Team with .... (This job is for - AnalysisVisio Jobs in OH Columbus Analyst - (in Columbus, OH)) COM-Business Analyst 4 / BA4 (668911) Create date: 17-Nov-2021 Start Date :11/29/2021 End Date :06/30/2022 Submison Deadline :11/22/2021 Client Info: COM Description : This position will function as a highly skilled BA4 for Ohio Department of Commerces Division of Liquor Control Team with specific responsibilities that include: Analysis Jobs in OH Columbus Analyst - (in Columbus, OH)) IT Project Manager - 59088 Create date: 15-Nov-2021 Description: Responsibilities Our client in Columbus Ohio is seeking an experience Business Analyst.Responsibilities Our client in Columbus Ohio is seeking an experience Business Analyst. Candidates must be local to central Ohio or willing to relocate by day one of consideration. Job Duties JAD Analysis Planning Jobs in OH Columbus Manager - (in Columbus, OH))    Analysis job openings in other states Jobs List IT Security Analyst 3 - 140719 Create date: 07-Mar-2025 No of Submissions : 1 Start date : 03/24/2025 End Date : 1 Years from projected start date Submission deadline : 3/13/2025 10:00:00 AM Client Info : CIP Note: * Interview Process: Interviews will be held IN PERSON at the Dimondale, MI office. Candidates must be willing to come .... (This job is for - Security Analysis Cybersecurity Jobs in MI Dimondale Analyst - (in Dimondale, MI)) Business Analyst/Consultant IV - 140093 Create date: 14-Feb-2025 No of Submissions : 1 Start date : 04/07/2025 End Date : 06/30/2025 Submission deadline : 2/21/2025 4:00:00 PM Client Info : ETF Note: * Interview Process: 2 rounds via MS Teams. PLEASE NOTE: A real-time screenshot photo of the candidate MUST be uploaded to candidates bid in or.... (This job is for - Analysis Jobs in WI Madison Consultant - (in Madison, WI)) Solutions Architect - 8627969B Create date: 06-Dec-2024 No of Submissions : 1 Start date : 12/23/2024 End Date : 06/30/2025 Submission deadline : 12/11/2024 Client Info : OIT Note: * Position Location : Remote * Max Rate : USD 131.00 Per Hour Description : Position Overview This posit.... (This job is for - Analysis Jobs in CO Denver Architect - (in Denver, CO)) Application Rationalization - 63637 Create date: 14-Nov-2024 No of Submissions : 1 Start date : 11/15/2024 End Date : 12/31/2024 Submission deadline : 11/22/2024 Client Info : Fulton County Description : To Suppliers: This is a Deliverables-based project and your proposal must include your total cost for each deliverable outlined be.... (This job is for - Analysis Jobs in GA Atlanta Consultant - (in Atlanta, GA)) Business Analyst - Advanced-11427-1 Create date: 22-Oct-2024 No of Submissions : 2 Start date : 11/19/2024 Submission deadline : 10/30/2024 Client Info : Department of Health and Human Services Note: Q) INTERVIEW PROCESS(who will conduct i/v, phone or in-person, how many rounds of i/v)? A) The interviews will be conducted by the MMRP team mem.... (This job is for - AnalysisTracking Jobs in SC Columbia Analyst - (in Columbia, SC))    Analysis job openings in OH Jobs List C++ Developer - J-11-426-148 Create date: 17-Jul-2019 Description: 8 to 14 years of experience in real-time embedded software programming in C++ and debugging with emulator, preferably experience with Wind River Workbench and VxWorks real-time operating system. -Knowledge of object-oriented analysis, design, and programming techniques. - One or More of the Following ski.... (This job is for - Analysis Design Jobs in OH MayfieldHeights Developer - (in Mayfield Heights, OH)) Business Info Developer Consultant - 33245 Create date: 30-Mar-2018 Candidate must be our W2 Employee Job Description : Apex Systems, the nations 2nd largest IT Staffing organization, has an immediate opportunity for a Business Info Developer with an organization located in Mason, OH. This is a long term contract role. Responsible for developing and executing more comple.... (This job is for - Analysis Jobs in OH Mason Consultant - (in Mason, OH)) US-Project Manager - Findlay OH - J-11-160-278 Create date: 06-Sep-2016 Start Date :09/01/2016 End Date :12/31/2017 Submission Deadline :09/12/2016 Description : Responsibilities: Leads customer engagement to ensure that it meets all scope, time, budget and quality expectations, through planning, controlling and managing customer projects. Manages corporate, cus.... (This job is for - Analysis Jobs in OH FINDLAY Manager - (in Findlay, OH)) Rd Shift POS Application - J-11-047-413 Create date: 11-Sep-2015 NOTE : Start Date : 09/28/2015 End Date : 12/26/2016 Submission Deadline : 09/17/2015 Client Info : COMSYS Description: It is seeking a 3rd Shift POS Application/Production Support for one of our premier client in the Mason suburb of Cincinnati. This is a 3+ month rolling contra.... (This job is for - Management Analysis Troubleshoot Jobs in OH MASON Consultant - (in Mason, OH)) BI4 Consultant Create date: 05-May-2015 It is seeking candidates for a Business Objects/BI SME role in Loveland/Cincinnati, OH for a 6- 9 month project. Required Skills: · Extensive experience as a Business Objects BI4 SME · Experience migrating BI reports to a cloud environment · Analysis current situation and set vis.... (This job is for - Architect Analysis Jobs in OH Loveland Consultant - (in Loveland, OH)) (Specialist: Analysis, Big Data, Hadoop, Data Warehousing Design And Development in Columbus, OH)

Featured Jobs Time Manager (Jobs in Richmond, Virginia) SSIS Analyst (Jobs in Richmond, Virginia) Analyst (Jobs in Olympia, Washington) - Consultant (Jobs in COLUMBIA, South Carolina) Business Analyst (Jobs in Richmond, Virginia) Consultant (Jobs in Milwaukee, Wisconsin) SQL Java Consultant (Jobs in Columbus, Ohio) Sql Server 2000 Specialist (Jobs in Columbus, Ohio) C# Developer (Jobs in Little Rock, Arkansas) Tableau Communication Consultant (Jobs in COLUMBIA, South Carolina)