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 --- Apply    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 - 64266 Create date: 15-Apr-2025 Start date : 05/05/2025 End Date : 12/26/2025 Submission deadline : 04/18/2025 Client Info : CT OEC Note: * Position Location : Hybrid * Its a Part Time at office position. 25 hours per week , 2 days at office. Max $65. Feel free to send up-to 3 profiles Description :.... (This job is for - Jira Jobs in CT Hartford Analyst - (in Hartford, CT)) Systems Software Programmer (Project Lead)-11625-1 Create date: 28-Mar-2025 Start date : 5/1/2025 Submission deadline : 4/4/2025 Client Info : Department of Social Services Note: Q) INTERVIEW PROCESS A) PANEL INTERVIEW Description : SCOPE OF THE PROJECT: THE CFS PROJECT IS PART OF THE DEPARTMENT OF SOCIAL SERVICES (DSS) AND IS RESPONSIBLE FOR DEV.... (This job is for - job Jobs in SC COLUMBIA Consultant - (in Columbia, SC)) Project Manager Expert - 63600 Create date: 05-Nov-2024 No of Submissions : 3 Start date : 12/02/2024 End Date : 01/31/2026 Submission deadline : 11/11/2024 Client Info : NeDHHS Note: * Position Location : N/A Description : The Expert Project Manager (PM) is responsible for planning, leading, org.... (This job is for - Communication Jobs in NE Lincoln Manager - (in Lincoln, NE)) Quality Assurance Analyst 4* -134723 Create date: 04-Sep-2024 No of Submissions : 2 start date : 10/14/2024 End date : At least 3 Years from projected start date submission deadline : 9/10 at 3:00PM CST. client info : Job Service Note: * Max Bill Rate on Rate Card: $59.72/hour but flexible up to $101.50/hour for the right candidate .... (This job is for - job Jobs in ND Bismark Analyst - (in Bismark, ND)) Software Test Analyst 3 -131446 Create date: 05-Jun-2024 Bid Limit Per Vendor : 1 Start date : 07/08/2024 Submission deadline : 6/11/2024 at 10AM EST. Client Info : MDOT Note : * Interviews: MS Teams video interview with camera ON. * Duration: 1 year with possible extension Position location: Lansing, MI. Hybrid work schedule – 2 days/.... (This job is for - ImplementationWaterfall Jobs in MI Lansing Analyst - (in Lansing, MI))    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 VITA Manager (Jobs in Richmond, Virginia) AutoCad - Consultant (Jobs in Chicago, Illinois) outlook SharePoint MS Office Troubleshoot Analyst (Jobs in Colonial Heights NIST Cyber Architect (Jobs in Lansing, Michigan) Jira Analyst (Jobs in Richmond, Virginia) Analyst (Jobs in Columbia, South Carolina) - Consultant (Jobs in Columbia, South Carolina) Advanced Analyst (Jobs in Richmond, Virginia) JavaScript C# Developer (Jobs in Madison, Wisconsin) SAML Specialist (Jobs in Raleigh, North Carolina)