DeveloperJobs.io
← Back to all jobs

Job Description

Mindex is seeking a Data Engineer to help migrate Informatica pipelines into Maia (Matillion) and Snowflake. This role focuses on converting, testing, and validating data workflows, while also building reusable pipeline components and supporting cutover readiness.

Responsibilities

  • Convert Informatica pipelines to Maia (Matillion) and Snowflake using the Solution Lead’s factory-style patterns, including the creation of reusable shared jobs, templates, and validation utilities.
  • Increase conversion throughput by removing bottlenecks and manual steps, verifying AI-generated output, and incorporating proven improvements into shared team patterns.
  • Design and optimize Snowflake pipelines and downstream objects to improve performance, reliability, and day-to-day operational ease.
  • Build and support ingestion pipelines for on-premises systems and Azure SQL Server, as well as files, APIs, and MongoDB.
  • Profile source data and investigate legacy behavior to identify edge cases, using SQL and Python to compare outputs against legacy results and resolve discrepancies.
  • Coordinate migration sequencing, testing standards, and sign-off criteria with technical leads and client SMEs.
  • Document migration logic, assumptions, test evidence, and go-live readiness so stakeholders can review and verify decisions.
  • Develop a repeatable migration workflow, and communicate progress and risks early and often to support key project milestones.
  • Apply an AI-first mindset by leveraging AI-assisted tools and technologies to increase productivity, accelerate problem-solving, improve quality, automate routine tasks, and drive innovation.

Requirements

  • BS degree in Computer Science, Data Science, Engineering, or a related field preferred, or an equivalent combination of education and experience.
  • 3+ years of hands-on experience with advanced SQL and Python for data processing and pipeline support.
  • 2+ years designing, building, and supporting ETL/ELT pipelines, including reusable components and workflow improvements.
  • 2+ years of Snowflake experience, including dynamic tables, views, performance tuning, and schema design.
  • Experience with data ingestion and replication tools, including connector setup, authentication, and integration across diverse sources strongly preferred. Informatica or Maia (Matillion) experience is a plus.
  • Ability to profile data from complex source systems, test and verify pipeline outputs, and independently resolve data issues.
  • Proactive and curious approach, including the ability to work independently, communicate clearly, and ask for help when blocked.
  • Uses AI to augment expertise and decision-making while maintaining ownership, accountability, and professional judgment for final outcomes.
  • Identifies opportunities to use AI to streamline workflows, reduce manual effort, improve efficiency, and increase business value.
  • Stays current on emerging AI capabilities, tools, and best practices and proactively applies relevant improvements in the workplace.
  • Demonstrates ethical, secure, and compliant use of AI technologies while protecting confidential, customer, and company information.

Technologies

  • Informatica
  • Maia (Matillion)
  • Snowflake
  • SQL
  • Python
  • ETL
  • ELT
  • Azure SQL Server
  • MongoDB
  • dynamic tables

Benefits

  • Fully Remote Work Environment
  • Flexible Time Off
  • Medical, Dental, and Vision Insurance
  • 401(k) with Company Match
  • Company-Paid Life and Disability Insurance
  • Professional Development Opportunities

Compensation

USD 90,000 - 140,000 per year.

Additional Information

  • Applicants must be authorized to work for any employer in the United States.
  • Mindex is unable to sponsor employment visas at this time.

Physical Requirements / Conditions

  • Prolonged periods sitting at a desk and working on a computer.
  • No heavy lifting is expected. Exertion of up to 10 lbs.

Similar Jobs