The Data Quality and Integration Developer supports the design, development, execution, monitoring, and improvement of enterprise data quality and data integration processes using Informatica Intelligent Data Management Cloud, including Cloud Data Governance and Catalog, Cloud Data Quality, Cloud Data Integration, Data Profiling, Metadata Command Center, and related governance capabilities. This role will operate within the Data Governance department partnering with data stewards, analysts within the line of business, application teams, database administrators, information security, and compliance stakeholders to identify data quality issues, create reusable rules, support data movement and transformation activities, interpret profiling results, publish quality scores, and support trusted data use across the organization.
Primary responsibilities may include developing and maintaining rule specifications, dictionaries, scorecards, rule occurrences, profiling tasks, exception outputs, integration mappings, data pipelines, transformation logic, and monitoring processes; associating data quality rules to governed assets and glossary terms; reviewing profiling statistics such as null values, distinct values, patterns, inferred data types, value frequencies, and outliers; troubleshooting profiling, integration, mapping, and rule execution failures; documenting repeatable processes; supporting data quality dashboards; and translating technical findings into clear language for business users and governance stakeholders.
Requirements of Skills:
- Hands-on experience with data quality, data profiling, data governance, metadata management, or data cataloging tools; Informatica IDMC, CDGC, CDQ, Data Profiling, and Metadata Command Center experience strongly preferred.
- Ability to create, configure, test, and maintain data quality rules, rule specifications, dictionaries, scorecards, rule occurrences, and reusable data quality assets.
- Strong SQL skills for researching source data, validating profiling results, identifying data anomalies, and supporting root cause analysis.
- Experience supporting data integration activities, including data movement, transformation logic, pipeline execution, mapping validation, and integration troubleshooting across source and target systems.
- Experience profiling structured data sources such as SQL Server, cloud data warehouses, flat files, or similar platforms to assess completeness, validity, consistency, accuracy, uniqueness, and timeliness.
- Ability to interpret profiling statistics, including null counts, distinct and non-distinct values, inferred data types, patterns, value frequency, lengths, minimum and maximum values, and outliers.
- Understanding of how data quality rules connect to governed assets, business terms, technical data elements, classifications, and data quality scores within a governance catalog.
- Ability to troubleshoot profiling, rule execution, connection, runtime, permissions, and source configuration issues in partnership with platform, infrastructure, DBA, and application support teams.
- Strong documentation skills, including the ability to write repeatable procedures, support guides, requirements, issue summaries, and business-friendly explanations of technical data quality findings.
- Strong analytical, problem-solving, communication, and collaboration skills with the ability to work across technical and non-technical teams.
Preferred Skills:
- Experience with Informatica Cloud Data Quality assets such as cleanse, parse, verifier, deduplicate, labeler, dictionaries, mapplets, mappings, or exception records.
- Experience with data governance concepts such as business glossary, data lineage, data classification, critical data elements, policies, stakeholder roles, and governed workflows.
- Experience with Microsoft SQL Server, Azure Synapse, Microsoft Fabric, ADLS Gen2, Power BI, Salesforce, Snowflake, Oracle, or similar enterprise data platforms.
- Familiarity with Secure Agent, runtime environments, advanced cluster concepts, catalog source configuration, metadata extraction, and data profiling prerequisites.
- Experience building dashboards, metrics, KPIs, or reports to monitor data quality trends, exceptions, remediation progress, or governance adoption.
- Experience with Informatica Cloud Data Integration, Informatica PowerCenter, or similar ETL/ELT and data integration platforms is a plus.
- Experience in a regulated industry such as banking, financial services, healthcare, insurance, or another environment with privacy, security, audit, and compliance obligations.
Requirements of Education and Experience:
- Bachelor’s degree in Data Management, Data Science, Computer Science, Information Systems, Business Analytics, Management Information Systems, or a related field preferred.
- Equivalent experience in data governance, data quality, data engineering, analytics, records and information management, information governance, or compliance may be considered in lieu of formal education.
- Four or more years of experience in data quality, data governance, data profiling, data analysis, data integration, data engineering, reporting, or a related data management discipline preferred; level may be adjusted based on candidate experience.
- Experience working with business stakeholders to understand data needs, define quality expectations, validate rules, review exceptions, and communicate results.
- Professional development or certification interest in data management, data governance, data integration, information governance, privacy, risk, compliance, or Informatica IDMC/CDQ/CDGC/CDI is preferred.
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.
Skills Required
- Hands-on experience with data quality, data profiling, data governance, metadata management, or data cataloging tools
- Experience creating, configuring, testing, and maintaining data quality rules, specifications, dictionaries, scorecards, rule occurrences, and reusable assets
- Strong SQL skills for source-data research, profiling validation, anomaly identification, and root-cause analysis
- Experience supporting data integration, data movement, transformation logic, pipeline execution, mapping validation, and troubleshooting
- Experience profiling structured data sources such as SQL Server, cloud data warehouses, or flat files
- Ability to interpret profiling statistics and assess completeness, validity, consistency, accuracy, uniqueness, and timeliness
- Understanding of governed assets, business terms, technical data elements, classifications, and data quality scores
- Ability to troubleshoot profiling, rule execution, connection, runtime, permissions, and source configuration issues
- Strong documentation, analytical, problem-solving, communication, and collaboration skills
- Bachelor's degree in data management, data science, computer science, information systems, business analytics, MIS, or a related field
- Four or more years of experience in data quality, governance, profiling, analysis, integration, engineering, reporting, or related data management
- Experience with Informatica Cloud Data Quality assets such as cleanse, parse, verifier, deduplicate, labeler, dictionaries, mapplets, mappings, or exception records
- Experience with data governance concepts including business glossary, data lineage, classification, critical data elements, policies, and governed workflows
- Experience with Microsoft SQL Server, Azure Synapse, Microsoft Fabric, ADLS Gen2, Power BI, Salesforce, Snowflake, Oracle, or similar platforms
- Familiarity with Secure Agent, runtime environments, advanced clusters, catalog source configuration, metadata extraction, and profiling prerequisites
- Experience building data quality dashboards, metrics, KPIs, or reports
- Experience with Informatica Cloud Data Integration, Informatica PowerCenter, or similar ETL/ELT platforms
- Experience in a regulated industry with privacy, security, audit, and compliance obligations
- Interest in professional development or certification in data management, governance, integration, privacy, risk, compliance, or Informatica platforms
MidFirst Bank Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about MidFirst Bank and has not been reviewed or approved by MidFirst Bank.
-
Healthcare Strength — Health, dental, and vision coverage are available to eligible full‑time and part‑time employees, with company‑paid long‑term disability and an EAP included. Medical plans through Blue Cross Blue Shield and wellness incentives that can lower premiums are highlighted.
-
Retirement Support — A company 401(k) match with a clear formula and a defined vesting schedule provides meaningful retirement support. Eligibility and enrollment timing are specified, reinforcing predictable access to the plan.
-
Leave & Time Off Breadth — Paid vacation, paid sick leave, and paid holidays are emphasized, with a paid community service day also referenced. Time‑off offerings are portrayed as generous across materials.
MidFirst Bank Insights
Similar Jobs
What We Do
MidFirst Bank occupies a rare position within the banking industry. With $41.2 billion in assets, MidFirst Bank is the largest privately owned bank in the country. This combination of size and private ownership provides our customers with a special brand of banking. MidFirst Bank offers a full range of personal, commercial, trust, private banking and mortgage banking products and services. MidFirst is a strong commercial real estate lender and a major servicer of mortgage loans nationally. As a private business ourselves, we understand the unique needs of each business community we serve at each of our locations in Arizona (Phoenix), California (Los Angeles, Orange County, Santa Barbara, San Diego), Colorado (Boulder, Denver, Edwards, Fort Collins), Nevada (Las Vegas), Oklahoma (Oklahoma City, Tulsa, Western Oklahoma), Texas (Dallas, Houston, San Antonio) and Utah (Salt Lake City). Additionally, MidFirst Bank has commercial lending offices in Atlanta, Chicago, Nashville, New York City, Orlando, Raleigh and Southern California. We serve Southern California through 1st Century Bank, a division of MidFirst Bank. We also operate MidFirst Business Credit as a subsidiary of MidFirst Bank. MidFirst Bank provides services that compete with larger banks, while the people and culture truly define the MidFirst Bank difference. MidFirst provides exceptional financial and deeply committed customer service. Team members are loyal in their character, loyal in their personal commitment to customers, and loyal to always doing the right thing. MidFirst customers can always count on working with thoughtful, intelligent, honest professionals who are true to their financial goals. MidFirst Bank is a strong supporter of the communities they serve, investing time and money in important educational, charitable and civic organizations. Copyright © 2025 MidFirst Bank. All rights reserved. Member FDIC. Equal Housing Lender.








