Test Data Architect

Healthcare Triangle, Inc.; Minneapolis (MN); On-site; USD 120,000 - 180,000; Full time

Job summary

Healthcare Triangle, Inc. in Minneapolis is seeking a Test Data Architect to lead enterprise test data strategy across complex systems, focusing on data modeling, integration patterns, and secure test data provisioning.

You will partner with business, product, architecture, development, testing, and operations teams to design data models, mappings, and data quality controls, ensuring readiness for functional, regression, and performance testing.

Qualifications

• Bachelor's degree or equivalent practical experience.
• Strong experience in data analysis, data architecture, database design, test data management, quality engineering, or software delivery.
• Proficiency writing and optimizing SQL queries for data discovery, validation, reconciliation, and troubleshooting.
• Experience analyzing relational databases, mainframe data structures, files, batch jobs, APIs, and downstream data consumers.
• Ability to translate business rules and system behavior into clear data requirements, mappings, and test data needs.
• Strong communication skills and experience in Agile delivery environments.

Responsibilities

• Partner with business stakeholders, Product Owners, SMEs, analysts, and development teams to understand data requirements, source systems, data mappings, and data consumption needs.
• Translate business requirements and rules into data models, mappings, and data integration specifications.
• Define and implement test data strategies supporting functional, regression, and performance testing across environments.
• Design and govern reusable test data patterns, provisioning approaches, masking, synthetic data, and environment refresh processes.
• Demonstrate understanding of data modeling concepts including entities, attributes, relationships, schemas, keys, indexes, and constraints.
• Read, interpret, and analyze ER diagrams, database schemas, data dictionaries, and end-to-end data flow diagrams to identify data dependencies.

Skills

Data analysis

Data architecture

Database design

Test data management

Quality engineering

Software delivery

SQL

Relational databases

Mainframe data

APIs

Data mappings

Data requirements

Test data needs

Communication

Agile

Education

Bachelor's degree or equivalent practical experience

Tools

DB2

Oracle

SQL Server

PostgreSQL

Easytrieve

COBOL

JCL

VSAM

Job description

Job Title

Test Data Architect

Location

Minneapolis, MN

Duration

Long Term

Job Description

Interviews will be highly technical, focusing on enterprise data architecture, data modeling, integration patterns, high-quality application testing, modernization, mainframe data structures, files, batch jobs, APIS, and downstream data consumers, collaboration with engineering and business teams. The Test Data Architect is responsible for defining, designing, and governing test data strategies that enablehigh-quality application testing, modernization, and delivery across complex enterprise systems.This role partners with business, product, architecture, development, testing, and operations teams to understand data requirements, analyze source systems, design data models and mappings, and ensure secure, reliable, and fit-for-purpose test data is available across environments.This position requires strong data analysis, database design, test data management, and enterprise integration knowledge, with preferred experience in banking, payments, credit card, deposits, lending, customer, and account data domains.

Key Responsibilities

• Partner with business stakeholders, Product Owners, SMES, analysts, and development teams to understand business processes, data requirements, source systems, data mappings, and data consumption needs.
• Translate business requirements, processes, and rules into logical and physical data models, source-to-target mappings, and data integration specifications.
• Define and implement test data strategies that support functional, regression, integration, performance, automation, and modernization testing needs.
• Design and govern reusable test data patterns, test data provisioning approaches, masking strategies, synthetic data solutions, and environment refresh processes.
• Demonstrate strong understanding of data modeling principles, including entities, attributes, relationships, schemas, primary and foreign keys, indexes, constraints, and overall database design.
• Read, interpret, and analyze Entity Relationship Diagrams, database schemas, data dictionaries, and end-to-end data flow diagrams to identify data dependencies and business impact.
• Perform data discovery, analysis, and data mining across multiple databases, tables, files and source systems using SQL, Easytrieve, and other data query and extraction tools.
• target mappings, and data integration specifications.
• rules into logical and physical data models, Define and implement test data strategies that support functional, regression, integration, performance, automation, and modernization testing needs.
• Design and govern reusable test data patterns, test data provisioning approaches, masking strategies, synthetic data solutions, and environment refresh processes.
• Demonstrate strong understanding of data modeling principles, including entities, attributes, relationships, schemas, primary and foreign keys, indexes, constraints, and overall database design.
• Read, interpret, and analyze Entity Relationship Diagrams, database schemas, data dictionaries and end-to-end data flow diagrams to identify data dependencies and business impact.
• Perform data discovery, analysis, and data mining across multiple databases, tables, files and source systems using SQL, Easyretrieve, and other data query and extraction tools.
• Validate data quality, integrity, consistency, and accuracy by analyzing data relationships transformation logic, reconciliation results, and business rules across systems.
• Develop an understanding of data movement and integration patterns, including real-timeand batch processing, event-driven architectures, APIs, messaging queues, data pipelines, and file-based interfaces. Collaborate with architecture, development, testing, and operational teams to supportdata analysis, problem resolution, impact assessments, test automation enablement, and system modernization initiatives.
• Collaborate with architecture, development, testing, and operational teams to supportdata analysis, problem resolution, impact assessments, test automation enablement, and system modernization initiatives.
• Ensure test data solutions comply with data privacy, data protection, retention, classification, and regulatory requirements for sensitive customer and financial data. Document data models, test data design patterns, source-to-target mappings, provisioning processes, standards, and best practices for repeatable enterprise use.
• Ensure test data solutions comply with data privacy, data protection, retention, classification, and regulatory requirements for sensitive customer and financial data.
• Document data models, test data design patterns, source-to-target mappings, provisioning processes, standards, and best practices for repeatable enterprise use.

Required Qualifications

• Bachelor's degree in Computer Science, Information Technology, Data Management,Engineering, or a related field, or equivalent practical experience.
• Strong experience in data analysis, data architecture, database design,test data management, quality engineering, or software delivery.
• Proficiency writing and optimizing SQL queries for data discovery, validation, reconciliation, and troubleshooting.
• Experience analyzing relational databases, mainframe data structures,files, batch jobs, APIs, and downstream data consumers.
• Ability to translate business rules and system behavior into cleardata Data Structure, database design, test data management, quality engineering, or software delivery.
• Proficiency writing and optimizing SQL queries for data discovery, validation, reconciliation, and troubleshooting.
• Experience analyzing relational databases, mainframe data structures, files, batch jobs, APIs, and downstream data consumers.
• Ability to translate business rules and system behavior into clear data requirements, mappings, and test data needs.
• strong communication skills with the ability to explain complex data concepts to technical and non-technical stakeholders.
• Experience working in Agile delivery environments and collaborating across product, engineering, quality, architecture, and operations teams.

Preferred Skills & Technologies

Databases DB2OracleSQL Server .PostgreSQLData Analysis & Query ToolsSQLEasyretrieveSPUFIBasic understanding of COBOL, JCL, and VSAM datasets

Contact

Subash US Staffing

7901 Stoneridge Dr, Ste 220, Pleasanton, CA 94588

Ph: / Email: