Remote Mid Level ETL Developer

Post Date

Apr 11, 2023

Location

Cincinnati,
Ohio

ZIP/Postal Code

45202
US
Aug 04, 2025 Insight Global

Job Type

Perm

Category

Software Engineering

Req #

CIN-616298

Pay Rate

$115k - $130k (estimate)

Job Description

A large, commercialized insurance client is seeking a Mid Level MDM Developer to sit fully remote! This person will be joining the MDM team within the data group to help with the creation and management of Enterprise MDM strategy, building of roadmap, and creation and maintenance of MDM multi-domain enterprise level solutions. It is also responsible for providing strategic guidance, tools selection, best practices, and architecture for MDM practice, and leading the initiation and implementation of Master Data Management MDM implementations for their business units. Some additional responsibilities include:



- Applying MDM strategies, requirements and policies, and supporting an MDM implementation on Informatica platform technologies

- Capturing requirements, data analysis, data profiling, development, testing, deployment, and support of MDM solutions

- Analyze and determine how data fits into the Master Data Management (MDM) platform, including changes to data model, data mapping, data cleansing rules, match and merge rules, hierarchies, data standardization rules, Reference data management, and data visualization

- Work closely with data analysts, architects and IT stakeholders on design options, data model changes, integration techniques, data mastering solutions and implement the changes into the Informatica MDM platform

- Develop and maintain ETL codes in MDM/ IDQ ingress and egress process

- Resolve database and data load errors due to data related or other system issues

- Modify C360 UI and backend mapping based on user requirements

- Conducts MDM unit tests, code reviews & deployments

- Coordinate with Informatica Product Support for critical issues

Provide Consultation on MDM Data Model to Business and other IT partners

Required Skills & Experience

5+ years of ETL experience with a strong data background (data quality, data lakes, data lineage, data profiling, data warehousing, etc)

General knowledge of MDM -- no preference on the specific tool but Informatica MDM preferred (IBM MDM, TIBCO, etc)

Experience in data analysis and profiling (understand, analyze and capture data)

Nice to Have Skills & Experience

Experience with Informatica MDM

Experience with Informatica MDM SaaS model

Experience with Snowflake, data-lakes, enterprise data warehouses, Tableau or other BI reporting solutions

Property and Casualty (P&C) Insurance industry experience

Knowledge of XML, Java, JSONs along with API's development and shell scripting

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.