Data Analytics & ETL Specialist — Hybrid Role

Nationwide Mutual Insurance Company

Scottsdale (AZ)

Hybrid

USD 118,000 - 222,000

Full time

8 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical/dental/vision

Life insurance

Disability coverage

Paid time off

Holidays

401(k) with company match

Pension plan

Business casual attire

Job summary

Nationwide Mutual Insurance Company is seeking a Data Designer/Analyst to perform intensive data analysis, data cleansing, and data modeling to support a Fortune 100 organization. You will review ETL logic in Informatica PowerCenter, create data mapping and visual documentation, and validate mappings against data warehouse models.

The role requires a Bachelor's degree in Computer Science or Engineering and about five years of relevant experience, with opportunities to automate testing using

Qualifications

Bachelor's degree in Computer Science or Engineering required.
5 years of data analysis and data engineering experience.

Responsibilities

Perfom intensive data analysis to inspect, cleanse, transform and model data.
Analyze ETL components in Informatica PowerCenter to map data from source to target.
Create ETL data mapping rules and visual documents using Informatica and IBM Infosphere DataStage.
Write complex SQL queries and profile data to validate mapping accuracy in data warehouses.
Automate frontend testing using UFT/Selenium and mock XML/API/web service calls.

Skills

Data modeling

SQL

Informatica PowerCenter

IBM Infosphere DataStage

UFT/Selenium

SOAP UI

XML/API calls

Education

Bachelor's degree in CS/Engineering

Tools

Teradata SQL Assistant

Job description

The role requires a Bachelor's degree in Computer Science or Engineering and about five years of relevant experience, with opportunities to automate testing using

Get your free, confidential resume review.

or drag and drop your file here.