ColumbusRecruiter Since 2001
the smart solution for Columbus jobs

Data Warehouse Specialist

Company: Dedicated Tech Services, Inc.
Location: Dublin
Posted on: April 10, 2021

Job Description:

Dedicated Tech Services, Inc. (DTS) is an award-winning IT consulting firm based in Columbus, OH. We now have an opening for a Data Warehouse Specialist in Columbus, Ohio. US Citizens and those authorized to work in the US are encouraged to apply. We are unable to sponsor at this time. Must be able to work remotely initially and then work on site in Columbus, OH when pandemic conditions allow. Must be able to pick up equipment in person in Columbus on day one of the engagement. Direct applicants only, no corp-to-corp candidates, third parties, or agencies, please. Required Skills and Experience : 6+ years of experience with Big Data, Hadoop on Data Warehousing or Data Integration projects. Experience analyzing, designing, developing, and supporting enhancements of ETL and ELT in data warehouse environments with Cloudera Big Data technologies, including Hadoop, MapReduce, Sqoop, PySpark, Spark, HDFS, Hive, Impala, StreamSets, Kudu, Oozie, Hue, Kafka, Yarn, Python, Floom, Zookeeper, Sentry, and Cloudera Navigator along with Oracle, PL/SQL, Unix commands, and shell scripting. Strong development experience in creating Sqoop scripts, PySpark programs, HDFS commands, HDFS file formats (Parquet, Avro, ORC etc.), StreamSets pipeline creation, jobs scheduling, hive/impala queries, Unix commands, scripting and shell scripting etc. Writing Hadoop/Hive/Impala scripts for gathering stats on table post data loads. Strong SQL experience (Oracle and Hadoop (Hive/Impala etc.)). Complex SQL queries and tuning based on Hadoop/Hive/Impala explain plan results. Proven ability to write high quality code. 6+ years of experience building data sets and familiarity with PHI and PII data. Expertise implementing complex ETL/ELT logic. Experience developing and enforcing reconciliation process Develop and enforce strong reconciliation process. Experience developing ETL and ELT design documentation Experience using ETL and ELT standards and practices to establish and use a centralized metadata repository. Experience in data security. Experience designing dimensional data models Basic knowledge of UNIX/LINUX shell scripting. Visio, Excel, PPT, and Word experience Effective communication, presentation, & organizational skills. Familiar with Waterfall and Agile Ability to establish and follow through on projects with strong attention to detail. Ability to work with minimal supervision. Familiar with Project Management methodologies like Waterfall and Agile BS/BA degree or combination of education and experience. Desired Skills and Experience : Effective leadership, analytical and problem-solving skills Excellent written and oral communication skills with technical and business teams. Ability to work independently, as well as part of a team Job Description : We are hiring an experienced Data Warehouse Specialist to work for us as a direct, W2 salaried or hourly employee, and the selected candidate will work on an engagement for our client. You will: Be responsible for enterprise data warehouse design, development, implementation, migration, maintenance, and operation activities for our client. Work closely with the client's Business Intelligence, Data Governance, and Analytics teams. Be one of the key technical resource for data warehouse projects for enterprise data warehouse projects and building critical data marts, data ingestion to Big Data platform for data analytics and exchange with state government and client partners. Work as a member of the client's ITS team. 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 client 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. Update the production support Run book and the Control M schedule document. Create and update design documents, provide detail description about workflows after every production release. Continuously monitor production data loads, fix issues, update tracker document, and identify performance issues. Performance tune ETL/ELT jobs Perform QA check and reconcile 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 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. Why DTS? We're inclusive; celebrate your role, grow in your position, feel the freedom to explore, trust the commitment, experience the opportunity. We're growing, and we need great people to grow with us! Simply put, we're enabled to hire the best. Our Project Delivery, Enterprise Support, Information Security, and Development Services practices are led by DTS consultants who help select our employees and then guide them. What's in it for you? A collaborative, supportive environment where high standards, quality, and excellence are the norm. Why Columbus? It has an exciting Information Technology market, a reasonable cost of living, a low unemployment rate, and a strong quality of life! It's the 14th-largest city in the United States and is home to fifteen (15) Fortune 1000 companies which are all very dependent on IT. Our Vision : By building a clear sense of purpose and strong relationships within Dedicated Tech Services, the staff and leadership team can then aspire to be the technology service provider whose quality services set the standard by which others are measured and that our clients ask for by name. Our Benefits : In addition to the opportunity to work for a caring and supportive company, DTS offers health, vision, and dental insurance, a 401K plan, bonus options, and more! Please visit our web site for more information. Dedicated Tech Services, Inc. is an Equal Opportunity Employer Employment Type: Full Time Years Experience: 5 - 10 years Bonus/Commission: No

Keywords: Dedicated Tech Services, Inc., Columbus , Data Warehouse Specialist, Other , Dublin, Ohio

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Other Jobs


GENERAL UTILITY
Description: As a Fortune 500 company, Packaging Corporation of America PCA is an ideas and solutions company. Our corrugated packaging business seeks to be the leader in helping our customers - large and small (more...)
Company: Packaging Corporation of America
Location: Newark
Posted on: 04/13/2021

Make up to $18/hour - Deliver with DoorDash - Start Delivering Today
Description: Your time. Your Goals. br What is DoorDash br Available in over 4,000 cities in the U.S., Canada, and Australia, DoorDash is about connecting people with possibilities: bigger savings accounts, (more...)
Company: Doordash
Location: Mansfield
Posted on: 04/13/2021

Patient Companion / Patient Support Assistant
Description: Please see below for the relevant information regarding this job and send me your updated resume in a word format: Job: Patient Companion / Patient Support AssistantLocation: Mansfield, OHShift: NightTime: (more...)
Company: InterSources Inc.
Location: Mansfield
Posted on: 04/13/2021


91D Power-Generation Equipment Repairer
Description: Since the Army National Guard uses a plethora of electronic systems, power is essential to success. As the Power-Generation Equipment Repairer, you'll supply the power to run virtually every aspect of (more...)
Company: Army National Guard
Location: Newark
Posted on: 04/13/2021

Package Sorter
Description: Auto req ID: 270323BR br Job Summary FedEx Ground is an essential business that needs people to help us support the economy, handling life-saving medications and other items that keep our communities (more...)
Company: FedEx Ground
Location: Middletown
Posted on: 04/13/2021

1st Shift Reach Truck Operator -" Bonuses and Benefits!
Description: 1st Shift Reach Truck Operator ----- Bonuses and Benefits A well-established company that distributes food product in Monroe/Lebanon that offers GREAT benefits once hired and bonuses. Position Details: (more...)
Company: Staffanation
Location: Middletown
Posted on: 04/13/2021

Lot Associate
Description: Lot Associate 390709871 Middletown, Ohio, US, 45042 Lot Associates assist customers with the loading of
Company: The Home Depot
Location: Middletown
Posted on: 04/13/2021

CDL-A Drivers - Earn $.60 CPM or More - $3K Transition Bonus
Description: Join Our 900 Drivers Earning .60 CPM or More Truck Driver Benefits: 3,000 to 6,000 Transition Bonus Automatic Pay Increases Earn Monthly
Company: Knight Transportation
Location: Newark
Posted on: 04/13/2021

Domino's Customer Service Rep/Pizza Maker - (Lexington Ave) - Competitive Pay - (2233)
Description: Client Service Representative br Why Work for Domino's/What We are Offering Our Great Team Members br --- We are the number 1 pizza company in the world br --- Growth and Career Advancement Opportunity (more...)
Company: Domino's
Location: Mansfield
Posted on: 04/13/2021

Lot Associate
Description: Lot Associate 390708313 Mansfield, Ohio, US, 44901 Lot Associates assist customers with the loading of
Company: The Home Depot
Location: Mansfield
Posted on: 04/13/2021

Log In or Create An Account

Get the latest Ohio jobs by following @recnetOH on Twitter!

Columbus RSS job feeds