ETL ELT Data Analysis Developer (Jobs in Columbus, OH)   Requirement id 120016 Job title Developer Job location in Columbus, OH Skills required ETL, Unix Shell Scripting, ELT, Data Analysis Open Date 26-Oct-2021 Close Date Job type Contract Duration 8 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Developer: ETL, Unix Shell Scripting, ELT, Data Analysis Description: Responsibilities Our client in Columbus Ohio is seeking an Enterprise Data Warehouse / Big Data Developer. Local candidates are highly preferred. Candidates are required to report onsite on Day 1 of the assignment. The Technical Specialist will be responsible for the clients 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 client partners. This position is a member of the clients ITS and works closely with the Business Intelligence & Data Analytics team. Objectives: 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.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. 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. Qualifications   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 120016 while calling.   Other jobs in OH: Cincinnati (1), Cleveland (1), Columbus (233), Dublin (8), Solon (2), ETL job openings in Columbus, OH Jobs List Data Warehouse / ETL / Informatica Cloud Specialist - 58729 Create date: 06-Oct-2021 Description: Responsibilities Our client in Columbus Ohio is seeking a Data Warehouse / ETL / Informatica Cloud Specialist. CANDIDATES MUST BE LOCAL TO CENTRAL OHIO OR ABLE TO RELOCATE BY DAY ONE FOR CONSIDERATION. Our client is looking for a Data Warehouse / ETL / Informatica Cloud Specialist to support .... (This job is for - ETL Jobs in OH Columbus Specialist - (in Columbus, OH)) Data Warehouse Designer/Developer - 58707 Create date: 05-Oct-2021 Description: Responsibilities Our Client in Columbus, Ohio is seeking an experienced Data Warehouse Designer / Developer for a contract role. CANDIDATES MUST BE LOCAL TO CENTRAL OHIO OR RELOCATED BY DAY ONE FOR CONSIDERATION. The Data Warehouse Designer/Developer will be responsible for Enterprise data wa.... (This job is for - Hadoop ETL ELT Jobs in OH Columbus Developer - (in Columbus, OH)) ETL Data Warehouse Specialist - 58614 Create date: 14-Sep-2021 Description: Responsibilities **Daily Tasks/Roles expected from this consultant: ** 1.Provide extensive programming support in COBOL, DB2, JCL, VSAM and SAS and implement many complex projects using excellent MVS debugging skills. 2.Strong Data Warehouse Business Knowledge with extensive programming in ETL concepts. 3.WII work.... (This job is for - VSAM ETL Cobol Jobs in OH Columbus Specialist - (in Columbus, OH)) ETL Data Warehouse Developer - 58603 Create date: 09-Sep-2021 Description: During a given day, this position will be expected to: • Work with Business Analysts and potentially business customers to verify requirements • Follow design documents involving source and destination databases • Interpret design documents to understand mapping and transformational requireme.... (This job is for - ETL ELT Python Jobs in OH Columbus Developer - (in Columbus, OH)) FCCS - PR3 (Data Warehouse Software Developer) (661111) Create date: 01-Sep-2021 Start Date :09/27/2021 End Date :06/30/2022 Submission Deadline :9/9/2021 Client Info : FCCS Description : Franklin County Children Services (FCCS) seeks a Data Warehouse Software Developer that also has programmer skills with ETLs (Extract, Transform, Load) from Oracle d.... (This job is for - ETL Jobs in OH Columbus Developer - (in Columbus, OH))    ETL job openings in other states Jobs List Business Intel Technical Lead II -134854 Create date: 17-Sep-2024 Bid Limit Per Vendor : 2 Start date : 10/14/2024 End Date : 06/30/2025 Submission deadline : 9/23/2024 at 4:00PM CST. Client Info : DOT Note : * Interview Process: Teams interview with Camera On * Duration: 6/30/25 with possible extensions * Remote or On-site? Candida.... (This job is for - ETL Jobs in WI Madison TechLead - (in Madison, WI)) NCDPI - SQL/Snowflake - Tableau Developer - Expert (746387) Create date: 09-Sep-2024 No of Submissions : 1 Start date : 09/23/2024 End Date : 03/21/2025 Submission deadline : 09/13/2024 Client Info : Note: * Agency Interview Type : In Person Only * Onsite Description : ***This is an onsite position in Raleigh, NC. Current.... (This job is for - ETL Jobs in NC Raleigh Developer - (in Raleigh, NC)) Data Warehouse Developer III -134848 Create date: 09-Sep-2024 Bid Limit Per Vendor : 1 Start date : 09/23/2024 End Date : 06/30/2025 Submission deadline : 9/11/2024 at 4:00PM CST. Client Info : ETF Note : * Interview Process: 1 round via Microsoft Teams. * Duration: 6/30/2025, likely to extend. * Onsite or Remote? No WI reside.... (This job is for - ETL Implementation Testing Jobs in WI Madison Developer - (in Madison, WI)) Data Warehouse Developer III -134705 Create date: 04-Sep-2024 Bid Limit Per Vendor : 1 Start date : 09/23/2024 End Date : 06/30/2025 Submission deadline : 9/6/2024 at 4:00PM CST. Client Info : ETF Note : * Interview Process: 1 round via Microsoft Teams. * Duration: 6/30/2025, likely to extend. * Onsite or Remote? Candidate MU.... (This job is for - ETLDataloader Jobs in WI Madison Developer - (in Madison, WI)) RHAPSODY DEVELOPER-Consultant - 11216-1 Create date: 28-May-2024 No of submissions : 2 Start date : 6/17/2024 Submission deadline : 6/4/2024 Client info : Health & Environmental Control Department (DHEC) Note : * INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)? - An interview panel will conduct one initial.... (This job is for - T SQL ETL Sql Server 2000 Jobs in SC COLUMBIA Developer - (in Columbia, SC))    ETL job openings in OH Jobs List GCP Data Engineer - 21-02459 Create date: 28-Jul-2021 * client info : Bespin Global Note: * Remote Duration: 8 weeks + (possible extension) Description: We are looking for resources to help build a data warehouse in GCP using BigQuery and Looker! Responsibilities: Basic GCP configuration - Project, roles, security, firewalls, pol.... (This job is for - GCP ETL BigQuery Jobs in OH Colombus Engineer - (in Colombus, OH)) ETL Tester - 72648 Create date: 05-Mar-2021 Note: They are doing a migration project with their systems to SAP. No competition on this opening, Apex is currently owning this role. This role will sit 100% remote and will have to work CST hours. The candidate will have to meet via video with my account manager and then there will be 2 additional video ivs with the client. We have IV times for .... (This job is for - ETL REST Jobs in OH Dublin Tester - (in Dublin, OH)) 84.51 Software Engineer - 71731 Create date: 09-Feb-2021 Candidate must be our W2 Employee. Job Description: SUMMARY: The 84.51° Commercial Platforms/New Ventures team is focused on leveraging Krogers rich data assets to build new businesses and alternative streams of revenue outside of the traditional Kroger enterprise. Things in Commercial Platforms can and do change, o.... (This job is for - ETL JUnit CUCUMBER Jobs in OH Cincinnati Engineer - (in Cincinnati, OH)) SAP BODS Technical Lead - 70452 Create date: 28-Dec-2020 Job Description SAP BODS Sr Technical Lead It is the nations 2nd largest IT Staffing organization, has an immediate and exciting opportunity for a SAP BODS Senior Technical Lead for one of the nations largest Healthcare Logistics and Solutions company in the Columbus, Ohio area. This position is a long term, open ended contrac.... (This job is for - ETL Jobs in OH Dublin TechLead - (in Dublin, OH)) Data Engineer - 66431 Create date: 02-Sep-2020 Note :Upon offer, it is required to show consultants W2 take-home pay in the Exh A. Candidate must be our W2 Employee. Job Description : WILL WORK REMOTE BUT WILL BE REQUIRED ON SITE WHEN THAT TIME COMES PROJECT LIKELY TO BE EXTENDED Data Engineer GENERAL FUNCTION: The .... (This job is for - ETL Jobs in OH Cincinnati Engineer - (in Cincinnati, OH)) (Developer: ETL, Unix Shell Scripting, ELT, Data Analysis 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)