DDL Pyspark Big Data Documenting Requirements Visio MS Word PHI Architect (Jobs   Requirement id 111985 Job title Architect Job location in Columbus, OH Skills required Data Analysis, Relational Database, DDL, Pyspark Big Data Documenting Requirement Open Date 01-Dec-2020 Close Date Job type Contract Duration 3 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Architect: Data Analysis, Relational Database, DDL, Pyspark Big Data Documenting Requirement On-site/Remote: On-site Description: Responsibilities Our client in Columbus, Ohio is seeking an experienced Senior Database Architect Position will be remote to start, but is expected to move onsite to downtown Columbus, Ohio location. Candidates must reside within 50 miles of Columbus, Ohio The Data 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 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 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. • Experience in analysis, design, development, support and enhancements in data warehouse environment with Cloudera Bigdata Technologies (Hadoop, MapReduce, Sqoop, PySpark, Spark, HDFS, Hive, Impala, Stream Sets, Kudu, Oozie, Hue, Kafka, Yarn, Python, Flume, Zookeeper, Sentry, Cloudera Navigator) along with   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 111985 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 - 58521 Create date: 19-Aug-2021 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, impl.... (This job is for - Waterfall Jobs in OH Columbus Architect - (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))    Data Analysis job openings in other states Jobs List 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)) VDH Data Scientist REMOTE II (742629) Create date: 17-Jul-2024 Remote No of Submissions : 3 start date :07/01/2024 End date :06/30/2025 submission deadline : 7/22/2024 client info : VDH Note: * Agency Interview Type: Web Cam Interview Only Description : *local candida.... (This job is for - job Jobs in VA RICHMOND Consultant - (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, Relational Database, DDL, Pyspark Big Data Documenting Requirement in Columbus, OH)

Featured Jobs Windows Engineer (Jobs in Clifton Forge, Virginia) Stakeholders AGILE Manager (Jobs in Richmond, Virginia) JavaScript Power Consultant (Jobs in Richmond, Virginia) Cybersecurity IT Analyst (Jobs in Richmond, Virginia) Peripherals IT Consultant (Jobs in Petersburg, Virginia) Filing Consultant (Jobs in Winchester, Tennessee) MS Office Consultant (Jobs in COLUMBIA, South Carolina) - - Consultant (Jobs in Bismarck, North Dakota) Scheduling Written Consultant (Jobs in Murfreesboro, Tennessee) GPO Brocade Manager (Jobs in COLUMBIA, South Carolina)