SQL Experience Kafka Flume Informatica Administration Shell Scripting Hive Busines   Requirement id 114939 Job title Architect Job location in Columbus, OH Skills required Agile Methodologies, Data Warehouse Environment, Hadoop Developer, SQL Experience Kafka Flume Informatica A Open Date 10-Mar-2021 Close Date Job type Contract Duration 3 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Architect: Agile Methodologies, Data Warehouse Environment, Hadoop Developer, SQL Experience Kafka Flume Informatica A On-site/Remote: On-site Job industry: Public Sector and Government Description: Responsibilities Our Client in Columbus, Ohio is seeking an experienced Senior Database Architect for a contract role CANDIDATES MUST BE LOCAL TO CENTRAL OHIO FOR CONSIDERATION - remote start from Columbus, OH. Must be able to pick up equipment in Columbus, OH DAY ONE. The Sr Data Architect will be responsible for Department 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 Client Department partners. This position is a member of Department ITS and works closely with the Business Intelligence & Data Analytics team. • 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, Ya   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 114939 while calling.   Other jobs in OH: Cincinnati (1), Cleveland (1), Columbus (233), Dublin (8), Solon (2), Agile Methodologies job openings in Columbus, OH Jobs List Business Systems Analyst (IT) III (Senior) - 20230123053730 Create date: 24-Jan-2023 start date:2/13/2023 End date:4+Months from start date submission deadline:1/30/2023 Note: * Job Site: Remote Description: TECHNICAL SKILLS Must Have Data Mapping from source to target tables Experience with Agile methodologies MS Excel.... (This job is for - MS Excel Jobs in OH Columbus Analyst - (in Columbus, OH)) Solutions Analyst - J-11-443-664 Create date: 27-Sep-2019 Description: Must Have: Expertise in requirements elicitation/gathering/validating, requirement integrity, process mapping, technical documentation 5-7 years Facilitating sessions 5-7 years Requirements traceability 5-7 years Solid understanding of the principles of Agile Methodolo.... (This job is for - job Jobs in OH Columbus Analyst - (in Columbus, OH)) ServiceNow Developer - 8612 Create date: 01-Feb-2018 Required Skills: ServiceNow Dev/Config/Platform experience Agile practice understanding Scrum/Kanban exposure OS command line knowledge and Relational DB experience ServiceNow Dev; Java; scripting, Relational DBs (This job is for - ServiceNowSCRUM Jobs in OH Columbus Developer - (in Columbus, OH)) Automated Tester With Data Warehouse Exp. - 8482 Create date: 18-Jan-2018 Agile experience Data Warehouse (Netezza and Oracle) experience Person should have automation experience in a Data Warehouse environment Very strong Ruby experience (This job is for - job Jobs in OH Columbus Tester - (in Columbus, OH)) Requirements Analyst - 5454 Create date: 30-Mar-2017 A Requirements Analyst is needed to fulfill a contract role with our Columbus, Ohio client. The candidate must have technical interest and understanding as the line is very technical in FileNet and Enterprise Content Management. Skills: Line RA knowledgeable of standard Requirements Analyst role, processes and tools (RRC.... (This job is for - RTC Jobs in OH Columbus Analyst - (in Columbus, OH))    Agile Methodologies job openings in other states Jobs List Business Analyst 5 - 129855 Create date: 26-Apr-2024 No of Submissions : 1 Start date : 05/13/2024 End date : 1 Years from projected start date Submission deadline : 5/1 at 10am EST. Client info : DHHS Note : * Interview Process: Virtual Interview via MS Teams video. Please use laptop and be prepared so share screen if asked. Use .... (This job is for - SCRUM Jobs in MI Lansing Analyst - (in Lansing, MI)) Quality Assurance Analyst 4 -129274 Create date: 11-Apr-2024 Start date : 05/06/2024 End Date : At least 3 Years from projected start date Submission deadline : 4/15 at 3:00PM CST Client Info : Job Service Note : * Interview Process: Virtual Teams on-camera. * Duration of the Contract: 3.5 years June 30, 2027, with opportunity for add.... (This job is for - job Jobs in ND Bismark Analyst - (in Bismark, ND)) Project Manager, Int -62451 Create date: 27-Mar-2024 start date : 04/29/2024 End date :03/31/2025 submission deadline : 04/10/2024 client info : TN DOT Note: * Position Location: Remote Description : TDOT is need of a solid, consistent and creative Project Manage.... (This job is for - Project ManagerITIL Jobs in TN Nashville Manager - (in Nashville, TN)) Business Analyst/Quality Test Analyst - 61876 Create date: 08-Feb-2024 Start date : 03/15/2024 End date : 09/27/2024 Submission deadline : 02/14/2024 Client info : NeEDU Note : * Position Location : Remote Description : Bachelors or Associates degree and at least 3 to 5 years of experience r.... (This job is for - Business Analyst Jobs in NE Lincoln Analyst - (in Lincoln, NE)) SYSTEMS ENGINEER - ADVANCED- 11033-1 Create date: 05-Dec-2023 Start date :January 8. 2024 Submission deadline : 12/12/2023 Client Info : Department of Health and Human Services Note : Q) INTERVIEW PROCESS (phone, video or in-person, how many rounds of i/vs, etc)? A) Phone/video conference for initial interview. In-person or video may be used for secondary.... (This job is for - job Jobs in SC Columbia Engineer - (in Columbia, SC))    Agile Methodologies job openings in OH Jobs List Solutions Analyst - J-11-419-518 Create date: 24-Jun-2019 start date:07/08/2019 End date:07/08/2020 submission deadline:6/28/2019 Description: Must Have: Expertise in requirements elicitation/gathering/validating, requirement integrity, process mapping, technical documentation 5-7 years Facilitating sessions .... (This job is for - job Jobs in OH Colombus Analyst - (in Colombus, OH)) SAP Functional Development Lead/Sr. Consultant - 47648 Create date: 22-May-2019 SAP Techno Functional Analyst Our client the nations 2nd largest IT Staffing organization, has an immediate and exciting opportunity for a SAP Techno Functional Analyst for one the Nations Top companies located in the Columbus, Ohio area. This opportunity is for a 8 Month open ended Contract. Applicants must have 5+ years of SAP Fu.... (This job is for - job Jobs in OH Dublin Consultant - (in Dublin, OH)) Sr Business Systems Analyst Agile Methodology - J-11-311-081 Create date: 03-Apr-2018 ROLE: The BSA is a senior level position responsible for high-level analysis of current state, applications development goals, business and end-user needs, eliciting and documenting requirements, and making recommendations Responsibilities include: 1.) Serving as a liaison between business and/or technology groups by identifyi.... (This job is for - ALM Jobs in OH Cleveland Analyst - (in Cleveland, OH)) Cloud Engineer - 32823 Create date: 16-Mar-2018 Client Info : Cardinal Health OH Candidates RTR form should be only on the name of APEX Systems We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens Job Description : : Cloud Engineer --Operations role. Required Skills - communications, operations, scripting powershell, python NoSQL Jobs in OH Dublin Engineer - (in Dublin, OH)) Business Analyst - 31402 Create date: 29-Jan-2018 Job Description : GENERAL RESPONSIBILITIES: Perform Business Analysts responsibilities for projects using agile methodologies and ensuring adherence to established processes and methodologies. Required Skills •Experience working as BA for projects using Scrum methodology/ceremonies •Experience with JIRA (Managing Cards/Epic Structure, Re.... (This job is for - Business AnalystReporting Jobs in OH Dublin Analyst - (in Dublin, OH)) (Architect: Agile Methodologies, Data Warehouse Environment, Hadoop Developer, SQL Experience Kafka Flume Informatica A in Columbus, OH)

Featured Jobs Web Developer (Jobs in Lincoln, Nebraska) ASP.Net JavaScript Manager (Jobs in COLUMBIA, South Carolina) Cloud Manager (Jobs in Lincoln, Nebraska) Standard Engineer (Jobs in Dauphin County, Pennsylvania) SIEM PowerShell C/C++ Python Analyst (Jobs in COLUMBIA, South Carolina) - Consultant (Jobs in Bismarck, North Dakota) SOAP JavaScript XML Written Developer (Jobs in Nashville, Tennessee) Organizational Analyst (Jobs in Richmond, Virginia) Business Analyst Medicaid Manager (Jobs in Lansing, Michigan) Technical Administrator (Jobs in Bismarck, North Dakota)