HireFT
Browse JobsHow it worksPricingSuccess Stories
    Back to jobs
    CS

    CSpring

    Technology

    MDM ETL Expert

    Springfield, United StatesRemoteFull-timePosted 4w ago
    All CSpring jobs

    Job description

    At CSpring, we believe in the power of data to drive decisions and real-world impact. We’re a purpose-driven consulting firm specializing in data strategy, data engineering, and data analytics. Our clients span the public and private sectors, and our work helps them solve complex problems, gain insights, and achieve measurable results.

    We're seeking talented professionals who are collaborative, curious, and committed to making a difference that thrive at the intersection of data, technology, and business strategy. Whether you're passionate about transforming public programs, enabling executive decision-making, or modernizing legacy systems, you'll find meaningful work and purpose here.

    Why You’ll Love Working Here

    • Purposeful Projects – Improve systems that serve real people by delivering smarter data, streamlined processes, and strategic insight.
    • People-First Culture – We’re as committed to your growth as we are to delivering high-impact solutions. You’ll find support, autonomy, and community here.
    • Strategic, Hands-On Work – From data architecture and documentation to client workshops and solution delivery, you’ll influence every step of the process.
    • Collaborative Trust – Our clients rely on us to listen carefully, deliver consistently, and guide wisely. We partner with integrity, curiosity, and heart.

    What You’ll Do

    As the technical lead for, you’ll own design, delivery, and day-to-day operations:

    • Own MDM technical solution delivery, including review of technical documentation to design MDM solutions that meet business needs.
    • Design MDM solution with security by design and privacy by design and align with the Chief Information Security Office (CISO) guidelines.
    • Provide leadership and coordinate or lead work for Informatica Master Data Management and related MDM ETL delivery activities; provide project direction and assign work to MDM ETL Specialists.
    • Use Informatica MDM tool to combine source data from agency sources, applying numerous transformations to the data that are required, applying corrections to the source files, and adding new fields via the change request process.
    • Implement MDM jobs by creating mappings, mapplets, sessions, and workflows, working with ETL transformations including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank and Source Qualifier, Lookup, and Sorter.
    • Automate the staging of data by scheduling scripts to run at optimal times, and schedule and monitor ETL/Informatica jobs in development, system testing, and production environments.
    • Develop proactive processes for monitoring capacity and performance tuning, and document workflows and technical specifications.
    • Troubleshoot production support issues post-release deployment and produce solutions, and troubleshoot server or software issues in coordination with the State IT department.
    • Develop, maintain, and analyze complex SQL queries and scripts used to create data marts in Teradata, and use other software tools such as Python as necessary to enhance MDM and data integration.
    • Work directly with the Quality Assurance and business team to support validation, defect resolution, and unit, integration, and system testing, and provide status updates and meet deliverables to Optum’s leadership and the State Project Managers.

    Job details are sourced from the employer's original posting.

    Open job posting
    CS

    About the company

    CSpring

    This company is a placeholder name and does not have a specific description available.

    View all CSpring jobscspring.com
    Industry
    Technology
    Open roles
    16

    Interested in this role?

    Apply with HireFT

    Free to start — no card required.

    Your fit

    How well do you match?

    Sign in to see how your résumé lines up with this role.