Data Engineer: ETL, Data Warehouse & Automation

OhioX; Columbus (OH); Hybrid; USD 118,000 - 222,000; Full time

Benefits offered by this job

Medical/dental/vision

Life insurance

Disability coverage

Paid time off

Nine holidays

401(k) with company match

Pension plan

Casual attire

Job summary

Nationwide in Columbus, OH is seeking a Data Engineer to design, implement, maintain, and support ETL, data warehouses, and enterprise data-integration workflows across relational databases, file systems, and service interfaces using Ab Initio, SQL, PL/SQL, Unix shell scripting, and Teradata/Oracle/DB2.

You will participate in the full SDLC with Jira and HP Quality Center, develop robust data models and processing logic, and ensure production support and performance tuning.

Qualifications

• Master’s degree in Computer Science or Engineering or Bachelor’s with 5 years of experience.
• Experience designing and maintaining ETL, data warehousing workflows.
• Proficiency with SQL, PL/SQL, Teradata, Oracle, DB2.
• Experience with Jira and HP Quality Center for testing activities.
• Unix shell scripting and knowledge of job scheduling tools.

Responsibilities

• Design, implement, maintain, and support ETL and data-warehousing workflows.
• Handle data integration across relational databases and file systems.
• Coordinate testing, deployments, and production support using Jira and HP Quality Center.
• Develop and optimize data models and SQL/PL-SQL processing logic.

Skills

ETL

SQL

Unix shell

C

Education

Master’s degree in Computer Science or Engineering

Bachelor’s degree in Computer Science or Engineering

Tools

Jira

HP Quality Center

Control-M

Autosys

Teradata

Oracle

DB2

HTML

XML

Job description

Nationwide in Columbus, OH is seeking a Data Engineer to design, implement, maintain, and support ETL, data warehouses, and enterprise data-integration workflows across relational databases, file systems, and service interfaces using Ab Initio, SQL, PL/SQL, Unix shell scripting, and Teradata/Oracle/DB2.

You will participate in the full SDLC with Jira and HP Quality Center, develop robust data models and processing logic, and ensure production support and performance tuning.