14 jobs found

Job Description Job Description Job Title: Performance Engineer Job Location: Columbus, OH Job Type: Contract Job Description: Design and implement performance test strategies for MDM applications and services. Develop and execute load, stress, endurance, and scalability testing. Analyze system performance metrics and identify bottlenecks across application, database, and infrastructure layers. Validate performance of data ingestion, data synchronization, data matching, and data governance workflows. Work closely with MDM architects, developers, and infrastructure teams to resolve performance issues. Create workload models simulating real-world data volumes and transaction patterns. Monitor system behavior using APM and monitoring tools. Provide performance tuning recommendations for applications, middleware, and databases. Prepare performance test reports and present findings to stakeholders. Support performance testing in CI/CD pipelines. Ensure performance compliance with SLA and NFR requirements. Required Technical Skills Performance Testing Tools JMeter / LoadRunner / NeoLoad / Gatling or similar tools Experience designing distributed load tests MDM & Data Systems EXPERT Experience with MDM platforms such as: Informatica MDM STIBO Reltio IBM InfoSphere MDM Understanding of data governance and data quality workflows Experience testing ETL and data integration pipelines Database & Query Optimization Strong knowledge of SQL performance tuning Experience with relational and NoSQL databases Ability to analyze execution plans and optimize queries Monitoring & Observability Dynatrace / AppDynamics / Splunk / Grafana / Prometheus or similar tools Cloud & Infrastructure Experience with AWS / Azure / GCP environments Understanding of microservices and API performance testing Familiarity with containerized environments (Docker, Kubernetes) Required Qualifications Bachelor's degree in computer science, Engineering, or related field 5+ years in performance engineering or performance testing 3+ years of experience working in enterprise data or MDM projects Strong analytical and troubleshooting skills Excellent communication and documentation skills

Job Description REI Systems' mission is to deliver reliable, innovative technology solutions that advance Federal clients' missions and exceed their expectations. Our technologists and consultants are passionate about solving complex challenges that impact millions of lives. We take a Mindful Modernization approach in delivering our services, including application modernization, grants management, case management systems, government data analytics, and advisory services. This approach, the REI Way, ensures mission impact by aligning our clients' strategic objectives with measurable outcomes through people, processes, and technology. We offer the same commitment to our employees by providing professional development, meaningful projects, and flexibility to spend time with family and friends. We believe employees are at their best when fulfilled in both their professional careers and their personal lives. Learn more at Employees voted REI Systems a Washington Post Top Workplace in 2015, 2016, 2018, 2020, 2021, 2022, 2023, 2024, and 2025! Responsibilities Position Overview REI Systems is seeking experienced Developer / Database Administrators (DBAs) to support a mission-critical Federal Health IT program focused on application modernization, database engineering, data integration, analytics, and cloud-based solutions. The ideal candidate will bring strong hands-on expertise in Oracle SQL, PL/SQL, database development, ETL processes, performance optimization, and AWS cloud technologies. This individual will play a critical role in designing, developing, maintaining, and optimizing enterprise database solutions that support complex federal applications and business operations. The Developer DBA will collaborate with software developers, solution architects, DevOps engineers, data engineers, Product Owners, and Agile delivery teams to implement scalable, secure, and high-performing database solutions. This role also offers opportunities to leverage AI-assisted development tools, intelligent automation, and modern DevSecOps practices to improve engineering productivity, code quality, testing, and operational efficiency. Responsibilities Database Development and Engineering Design, develop, implement, and maintain Oracle database solutions, including stored procedures, packages, functions, triggers, views, materialized views, and sequences. Develop and optimize complex SQL queries and PL/SQL code supporting enterprise applications, reporting, and business processes. Perform database performance tuning, query optimization, indexing, partitioning, and execution plan analysis. Design and maintain database schemas, data models, entity relationship diagrams (ERDs), and database objects. Develop database migration scripts, schema modifications, deployment packages, and automated database release processes. Troubleshoot database performance issues, application integration challenges, and data integrity concerns. Support database administration and operational activities, including monitoring, troubleshooting, and production support. ETL, Data Integration, and Cloud Technologies Design, develop, and maintain ETL workflows, data integration pipelines, and data transformation processes. Develop and support batch processing, data migration, data validation, and reconciliation solutions. Work with Matillion ETL or comparable enterprise ETL tools to develop and maintain data integration pipelines. Support cloud-based data engineering and analytics solutions utilizing AWS services, including Amazon Redshift, Amazon RDS, and Amazon S3. Analyze complex application data models, data mappings, and enterprise data flows. Collaborate with application and data engineering teams to ensure reliable data integration across multiple systems. Support database and application modernization initiatives, including cloud migration and integration efforts. Application Development and DevSecOps Partner with application developers, architects, and technical teams to design efficient database solutions aligned with business and technical requirements. Develop and maintain database unit tests, regression tests, data validation scripts, and deployment verification processes. Support CI/CD pipelines and automated database deployments using modern DevSecOps practices. Participate in code reviews, technical design discussions, and troubleshooting activities. Support production deployments, incident resolution, root-cause analysis, and post-release validation. Maintain technical documentation, including database designs, deployment procedures, data mappings, and operational support guides. AI-Assisted Development and Automation Utilize approved AI-assisted development tools to enhance SQL and PL/SQL development, testing, documentation, and troubleshooting. Identify opportunities to automate repetitive database development, validation, and operational activities. Support AI-enabled software development lifecycle (SDLC) practices to improve engineering productivity and delivery quality. Apply responsible AI practices while maintaining data security, privacy, and compliance requirements. Agile Collaboration and Federal Compliance Participate in Agile ceremonies, including sprint planning, backlog refinement, daily standups, sprint reviews, and retrospectives. Collaborate with Product Owners, Scrum Masters, business analysts, developers, and federal stakeholders to deliver high-quality solutions. Ensure database solutions follow established security, governance, and compliance standards. Support federal cybersecurity requirements and best practices aligned with FISMA, NIST, and FedRAMP, as applicable. Implement secure database development practices, including access controls, audit logging, and data protection measures. Qualifications Minimum of 5 years of professional experience in Oracle database development, database engineering, ETL development, data integration, or related software engineering roles. Strong hands-on experience with Oracle SQL and PL/SQL, including: Stored procedures, functions, packages, and triggers. Complex SQL queries, views, materialized views, and sequences. Query optimization, indexing, execution plans, and performance tuning. Oracle SQL Developer, SQL Loader, or similar Oracle development utilities. Experience designing, developing, troubleshooting, and maintaining enterprise database solutions. Hands-on experience developing ETL workflows, data transformation processes, batch processing, and data migration solutions. Experience working with AWS cloud technologies, including Amazon Redshift, Amazon RDS, and Amazon S3. Experience with Matillion ETL or comparable ETL/data integration platforms. Strong understanding of relational database architecture, logical and physical data modeling, normalization, referential integrity, and transaction management. Experience with database performance tuning, query optimization, and troubleshooting. Experience supporting complex enterprise applications and production database environments. Experience developing database unit tests, regression tests, data validation processes, and deployment verification scripts. Experience supporting production deployments, incident management, root-cause analysis, and issue resolution. Familiarity with CI/CD pipelines, source control, release automation, and DevSecOps practices. Experience using tools such as Git, GitHub, GitLab, Bitbucket, or Azure DevOps. Experience working in Agile/Scrum development environments. Familiarity with AI-assisted development tools and automation practices to improve software engineering productivity. Understanding of secure development practices, data privacy, cybersecurity, and responsible AI adoption. Strong analytical, troubleshooting, problem-solving, and communication skills. Ability to work independently and collaboratively in a fast-paced, mission-driven environment. Must be able to obtain and maintain a Federal Public Trust clearance, with approved adjudication required before onboarding. Preferred Qualifications Previous experience supporting Federal Government IT programs, particularly within Health IT or large-scale enterprise environments. Experience with grants management, financial management, case management, or workflow-driven applications. Experience with Oracle Data Pump, Oracle GoldenGate, Oracle Data Integrator (ODI), Informatica, Talend, Liquibase, or Flyway. Experience with additional database technologies such as PostgreSQL, SQL Server, or MySQL. Experience supporting cloud modernization, database migration, or application modernization initiatives. Knowledge of data warehousing, dimensional modeling, enterprise reporting, and business intelligence technologies. Experience with Power BI, Tableau, Amazon QuickSight, or comparable analytics platforms. Familiarity with AWS cloud-native architectures and enterprise data platforms. Experience supporting data pipelines for analytics, AI, or machine learning workloads. Familiarity with AI-enabled DevSecOps, intelligent automation . click apply for full job details

Job Description Federal Project - Applicant must be a United States Citizen with the ability to obtain a Public Trust Baer is looking for Oracle Analytic Cloud Developer for a 9-month Federal remote Project Title: Oracle Analytic Cloud Developer Location: Remote (Must be based in US) Duration: 9 months Rate: All-inclusive Alignment: W2 or C2C Overview: The Oracle Analytics Cloud (OAC) Developer is responsible for developing, enhancing, and maintaining reports, dashboards, and data visualizations to support business decision-making. This role focuses on production support, issue resolution, data accuracy, and performance optimization within OAC environments. The ideal candidate has strong expertise in OAC, SQL, data modeling, and data integration, with experience troubleshooting analytics solutions and collaborating with business and technical teams. Description: Develop, enhance, and maintain OAC reports, dashboards, analyses, and data visualizations based on business requirements. Troubleshoot and resolve client-reported issues related to report logic, data discrepancies, access permissions, and performance. Support OAC data models and semantic layers, including subject areas, joins, hierarchies, and calculations. Write and optimize SQL queries to validate data, investigate issues, and improve reporting performance. Perform root-cause analysis and coordinate with data engineering, infrastructure, and business teams to resolve production issues. Implement analytics enhancements and validate reports following data model changes, ETL updates, or platform upgrades. Support data integration processes and troubleshoot data pipeline issues using Oracle Data Integration Cloud Services or similar tools. Maintain technical documentation, troubleshooting procedures, and support records. Assist with OAC administration, including user and role management, environment monitoring, and configuration checks, as needed. Collaborate with cross-functional teams to ensure reliable, accurate, and high-performing analytics solutions. Requirements: 7+ years of advanced experience in Oracle Cloud Infrastructure (OCI), Oracle Analytics Cloud (OAC), Oracle Data Integration Cloud Services, Data Engineering, and SQL. Hands-on experience developing reports and dashboards using Oracle Analytics Cloud (OAC) or Oracle Analytics Server (OAS). Advanced proficiency in OCI, OAC, Oracle Data Integration Cloud Services, Data Engineering, and SQL (P3). Strong knowledge of data modeling, semantic layers, relational databases, and data warehousing. Experience in SQL development, data validation, performance tuning, troubleshooting, and root-cause analysis. Familiarity with ETL/ELT tools such as ODI, Informatica, or Talend. Experience supporting production analytics environments and resolving data and reporting issues. Knowledge of OAC administration and cloud-based data pipelines is preferred. Strong analytical, problem-solving, communication, and documentation skills. Bachelor's Degree Public Trust Security Clearance is the lowest level of additional background screening that the federal government requires for applicants of certain jobs, which includes completing a Standard Form 85 (SF85) form. Company Overview: Baer provides best-in-class engagement experiences for our consultants. Our job requirements are carefully vetted and are typically associated with pivotal programs offering tremendous opportunities to expand your skills leveraging the latest solutions. Baer is an equal opportunity employer including disability/veteran. ALL OPEN JOBS

Job Description Position: Informatica Lead (Netezza) Location: Short Hills, NJ Mode Of Hire: Contract Mode Of Work: Onsite Required Qualifications 8+ years of experience in ETL, data integration, data warehousing, or analytics. 3+ years of technical leadership and offshore team coordination. Strong hands-on experience with Informatica PowerCenter and/or IICS. Advanced SQL Server skills, including stored procedures and performance tuning. Experience with IBM Netezza, dimensional modeling, batch processing, and data quality. Strong communication, problem-solving, stakeholder management, and Agile/SDLC experience. Bachelor's degree in Computer Science, IT, Engineering, or equivalent experience.

Job Description Job Title: Informatica PowerCenter & IDMC (IICS) Developer - Migration Specialist Location: New Jersey - Princeton Local candidate - In-person interview Duration: 6+ months Role Descriptions: CDI-PC / PowerCenter Asset Analysis Analyze Informatica CDI-PC / PowerCenter workflows mappings sessions mapplets worklets parameter files reusable components and dependency structures. Assess current-state conversion readiness identify complexity drivers and document technical assumptions gaps and risks. Review runtime behaviors parameterization patterns file handling logic source/target connectivity and transformation-level dependencies. Analyze B2B service dependencies and EDI-related integration patterns including awareness of 835/837 file format handling where applicable. IDMC / IICS Design and Build Design and create IDMC / IICS assets corresponding to legacy sessions mappings workflows and runtime configurations. Create and validate mapping tasks task flows connections schedules parameters and other IDMC assets required for end-to-end migration. Ensure IDMC implementation aligns with functional intent source-to-target rules transformation behavior scheduling needs and operational controls. Drive configuration consistency naming standards reusable patterns and environment migration practices across the conversion workstream. Complex Transformation Handling Provide deep technical analysis for complex Informatica transformations including Java transformations XML transformations expression/router/lookup/aggregator patterns and reusable transformation logic. Understand and explain how transformations behave in IDMC compared with CDI-PC / PowerCenter including capability differences conversion constraints and required redesign patterns. Identify transformation-specific risks build IDMC-compatible alternatives and guide developers on remediation approaches. Validation Testing and DVO Usage Own technical validation for converted assets including unit testing system integration testing support data reconciliation defect triage and production-readiness checks. Create or review Oracle SQL-based validation queries and compare source/target results to confirm conversion accuracy. Leverage familiarity with Informatica Data Validation Option (DVO) to support repeatable reconciliation and automated validation where applicable. Review logs runtime statistics and failure patterns to troubleshoot issues across CDI-PC IDMC database Unix and file-handling layers. Estimation Planning and Delivery Leadership Estimate conversion and testing effort based on asset complexity including number of transformations workflow dependencies parameterization source/target count B2B/EDI interactions custom logic and testing scope. Break down technical work into actionable tasks and allocate work to team members based on skill complexity and delivery priorities. Track progress identify blockers early coordinate with functional teams and support delivery governance through status inputs and risk communication . Suggest process improvements reusable accelerators. Essential Skills: We are looking for an IDMC Tech Lead to drive the technical analysis design build validation and testing activities for an Informatica CDI-PC to IDMC conversion initiative. The role requires strong hands-on experience across Informatica PowerCenter CDI-PC IICS/IDMC Oracle SQL and Unix with the ability to understand asset complexity estimate effort allocate work guide team members and improve conversion processes.

Job Description MUST HAVE: 5+ years in data governance or data management, ideally at a bank or in financial services Uses Collibra every day: business glossary, data definitions, CDEs, ownership and lineage Documents metadata and source-to-target mappings, and traces data from upstream systems to reports Gathers requirements from data owners and stewards and turns them into documentation Comfortable using SQL to profile and validate data Nice to have: Data quality: defining DQ rules, metrics and scorecards, and supporting root cause analysis Collibra workflows: defining approval steps, testing workflows and troubleshooting them alongside developers Collibra certification: Ranger, Data Steward or Data Citizen Regulatory experience: BCBS 239, CCAR, SOX or other banking data requirements Agile/Jira: writing user stories, acceptance criteria and backlog items Other catalog tools: Informatica (Axon/EDC), Alation or Purview Light scripting: basic Python or Excel automation for bulk metadata updates Cloud migration exposure: helping re-catalog data or check lineage after a platform move

Job Description Job Description Job Title: Senior AWS Informatica Developer Duration: Full Time / Permanent Position Location: Lafayette, LA; Knoxville, TN; Birmingham, AL; or Columbia, SC Work Mode: 5 Days Onsite Position Description Systemone is seeking an AWS Informatica Developer to support enterprise data integration and processing solutions within a large-scale financial services environment. This is a hands-on engineering role requiring deep experience with Informatica PowerCenter (CDI PC version), Oracle/SQL, Python, shell scripting, Airflow, and AWS technologies. The engineer will develop, enhance, test, implement, and support complex ETL and data processing workflows across traditional and AWS-based environments. This position requires strong troubleshooting and problem-solving skills, along with experience supporting reliable, secure, and high-volume enterprise data pipelines. Required Qualifications 5+ years of Informatica experience, with strong hands-on expertise in Informatica PowerCenter (CDI PC version). Informatica PowerCenter experience is mandatory. IDMC experience alone is not a substitute. Strong enterprise ETL and data integration development experience. Advanced Oracle and SQL skills, including complex query development and troubleshooting. Strong Python scripting and development skills for data processing and automation. Strong Unix/Linux shell scripting experience. 3+ years of hands-on AWS experience, including Lambda, SNS, and SQS. Hands-on experience with Apache Airflow, including DAG development and data pipeline orchestration. Experience with Amazon Redshift and Redshift Spectrum. Strong troubleshooting, analytical, and root cause analysis skills. Experience supporting enterprise data pipelines and production environments. Ability to work effectively with changing requirements and priorities. Desired Skills AutoSys scheduling experience. Jenkins and CI/CD experience. Additional AWS data services experience. Financial services or other regulated industry experience. Educational Requirements Bachelor's degree in Computer Science, Information Technology, Engineering, or a related technical field. Ref: Pittsburgh

Job Description Job Description Position Overview We are seeking a highly experienced Senior Master Data Management (MDM) Developer to lead the technical implementation of our enterprise MDM strategy. This individual will play a critical role in architecting, developing, and delivering a scalable Master Data Management platform that will serve as the foundation for enterprise-wide data governance. The initial focus will be the successful implementation of a Customer Master solution, with a strategic roadmap to evolve into a Multi-Domain Enterprise MDM supporting Customer, Material, Supplier, Asset, and other core business domains. This role combines deep MDM platform expertise, cloud-native integration experience, and enterprise data architecture skills. The ideal candidate will work closely with enterprise architects, business stakeholders, and system integrators to deliver a secure, scalable solution operating within an AWS GovCloud environment. Key Responsibilities Enterprise MDM Solution Design Lead the design and implementation of enterprise-grade Master Data Management solutions. Configure and optimize matching, merging, survivorship, relationship management, hierarchy management, and reference data capabilities. Develop scalable data models capable of supporting future multi-domain expansion. Platform Evaluation & Technical Leadership Lead technical evaluations and Proof of Concepts (PoCs) across leading MDM platforms including Informatica MDM and Reltio . Assess platform capabilities, scalability, integration patterns, and long-term maintainability. Provide architecture recommendations that align with enterprise data strategy. Data Integration & Engineering Design and develop secure, high-performance ETL/ELT pipelines for ingesting master data from Salesforce CRM and other enterprise systems. Develop APIs, integration services, and batch processing workflows. Ensure data quality, consistency, lineage, and governance throughout the integration lifecycle. MDM Configuration & Development Configure: Match & Merge Rules Survivorship Rules Identity Resolution Golden Record Management Hierarchy Management Reference Data Management Crosswalk Management Data Stewardship Workflows Optimize performance for large-scale master data processing. Cloud & Security Deploy and support MDM solutions within a secure AWS GovCloud environment. Implement security, encryption, access controls, and compliance requirements aligned with government standards. Collaborate with infrastructure teams on cloud architecture and deployment automation. Cross-Functional Collaboration Serve as the primary technical lead within a blended delivery model consisting of internal teams, business stakeholders, and external system integrators. Partner closely with Data Governance, Enterprise Architecture, Security, Infrastructure, and Application Development teams. Mentor junior developers and establish development best practices. Enterprise Data Strategy Design Customer Master implementations that naturally evolve into an Enterprise Multi-Domain MDM platform. Contribute to enterprise standards for metadata, data quality, governance, and master data lifecycle management. Support long-term modernization initiatives across the enterprise data ecosystem. Required Qualifications Experience 8+ years of hands-on Master Data Management implementation experience. Proven experience implementing enterprise-scale MDM solutions from design through production deployment. Experience leading technical workstreams on complex MDM implementations. MDM Platforms Hands-on development experience in two or more of the following: Informatica MDM Reltio Informatica Intelligent Data Management Cloud (IDMC) (preferred) Informatica Customer 360 Informatica Product 360 (nice to have) Data Integration Strong experience with: Salesforce CRM integration ETL/ELT development REST APIs SOAP APIs Batch processing Data profiling Data cleansing Data quality Identity resolution Cloud Technologies Experience with: AWS GovCloud AWS Lambda S3 IAM Secrets Manager CloudFormation or Terraform CI/CD pipelines Database & Development Strong knowledge of: SQL Oracle PostgreSQL JSON/XML Python or Java Git DevOps practices Data Management Deep understanding of: Master Data Management Data Governance Data Quality Metadata Management Data Lineage Reference Data Management Golden Record Management Hierarchy Management Preferred Qualifications Experience implementing Customer 360 initiatives. Experience with Enterprise Data Governance programs. Knowledge of Informatica Cloud Data Quality (CDQ). Experience with Data Catalog solutions. Experience integrating MDM with ERP platforms such as SAP or Oracle. Familiarity with Material Master, Supplier Master, or Asset Master domains. Experience working within regulated industries such as Aerospace, Defense, Manufacturing, or Government. Security Requirements Due to the nature of this program and deployment within AWS GovCloud , candidates must: Be a U.S. Citizen . Be eligible to obtain and maintain required government security clearances. Successfully pass all applicable background investigations. What Success Looks Like Within the first 12 months, the successful candidate will: Deliver a production-ready Customer Master implementation. Successfully complete MDM platform evaluation and recommendations. Establish scalable enterprise data models supporting future multi-domain expansion. Build secure Salesforce-to-MDM integration pipelines. Enable a governed, trusted Golden Record supporting enterprise analytics, operational systems, and AI initiatives.

Job Description Job Description Position Qualifications: Bachelor's Degree from an accredited university in Computer Science, Engineering or in a Technology related field, OR equivalent through a combination of education and/or technology experience, OR 12 years of technology experience 7 years of experience identifying technical solutions for complex business problems, identifying the benefits and risks of the solutions and providing recommendations 7 years of experience in Technology, Data Engineering field in architecting, developing end-to-end scalable data applications and data pipelines; work with product manager and scrum masters and lead the team in assisting the story creations and sprint deliverables 7 years of experience leading and developing automated Informatica data pipelines with at least 4 years Informatica cloud (IICS) and relevant knowledge in data profiling, data quality, catalog tools 7 years of experience working in enterprise data warehouse solutions and platforms, and working knowledge of different databases (e.g., RDBMS, Snowflake), S3 Datalake, CICD, Jenkins and AWS cloud technologies 5 years of experience designing, implementing automated data solutions using Snowflake lakehouse; building workflows, developing, and scheduling ETL processes using programming SQL or Python 5 years of experience mentoring another technologist 5 years of experience implementing data solutions by adopting, recommending and improving CICD, change management, data security, auditing processes 4 years of experience working with software engineering best practices across the development lifecycle, including agile methodologies, coding standards, code reviews, source management, build processes and testing AWS or Informatica or Snowflake certification is preferred Experience with Dataiku is a plus.

Job Description Job Description Senior Healthcare Data Modeler - EDW / Cloud Modernization Location: Remote, Continental U.S. Preferred Location: Central U.S. / Midwest Travel: Occasional Mot open to third parties Position Summary We are seeking a hands-on Senior Healthcare Data Modeler to support a large Enterprise Data Warehouse and cloud modernization initiative. This role will work with complex healthcare datasets and translate business requirements into scalable enterprise data models and solutions. The Senior Healthcare Data Modeler will own the design, governance, and evolution of conceptual, logical, and physical data models supporting the EDW and its modernization. The environment is transitioning from a legacy Teradata EDW toward modern Azure and Snowflake cloud architecture. The ideal candidate brings deep healthcare data modeling experience, expert SQL skills, strong data governance and metadata knowledge, and hands-on experience designing enterprise data models across Medicaid, Medicare, claims, provider, TPL, and member data. Responsibilities Data Architecture & Strategy Develop long-term data architecture strategies, standards, and roadmaps in collaboration with business and technical stakeholders. Lead data architecture, data modeling, and data movement initiatives supporting Medicaid, Medicare, and Commercial healthcare data. Work across healthcare subject areas including claims, provider, TPL, and member data. Define how logical designs translate into physical databases and how data flows through successive architectural layers. Maintain accurate documentation of the enterprise data architecture and environment. Data Modeling & Design Translate complex business requirements into scalable enterprise data models. Design and maintain conceptual, logical, and physical data models across staging, integration, and semantic/presentation layers. Develop dimensional models using Kimball star/snowflake, normalized OLTP/3NF, OLAP, and Data Vault modeling techniques. Implement Slowly Changing Dimensions, role-playing dimensions, dimensional hierarchies, surrogate keys, and data classifications. Define primary and foreign keys, indexes, partitioning, constraints, and referential integrity rules. Create and maintain ERDs, data flow diagrams, and data model documentation using Erwin or comparable modeling tools. Data Governance, Quality & Compliance Ensure data architecture and modeling practices align with healthcare regulatory and security requirements. Oversee source-to-target mapping, data movement, interfaces, and data quality. Maintain data dictionaries, business glossaries, metadata, lineage documentation, and data modeling standards. Support classification and protection of PII and PHI in accordance with applicable healthcare data security requirements. Support Data Quality, Data Profiling, Data Governance, Data Security, Metadata Management, MDM, Data Archival, and Data Migration initiatives. Collaboration & Delivery Partner with Data Architects, ETL/Data Engineers, Business SMEs, BI Developers, and DBAs throughout the architecture and implementation lifecycle. Provide technical recommendations for scalable data warehouse, data mart, data mining, and analytics solutions. Address data challenges involving systems integration, compatibility, and multi-platform environments. Develop testing criteria to ensure the fidelity and performance of data architecture. Communicate risks and issues clearly to project and stakeholder teams. Cloud Modernization & Migration Support modernization of legacy Teradata data models to Azure and Snowflake. Contribute to target-state architectures involving Azure Synapse, Databricks Lakehouse, and Snowflake. Design models supporting Medallion architecture, including Bronze, Silver, and Gold layers. Work with Delta Lake and Parquet patterns. Assess existing data models for modernization, redundancy, performance, and optimization opportunities. Required Qualifications BS or MS in Computer Science, Business Information Systems, Engineering, or a related field. 10+ years of IT experience. 7+ years of data modeling, data strategy, and roadmap experience supporting large, complex healthcare environments. Experience implementing large-scale, end-to-end Data Management and Analytics solutions. 5+ years of healthcare data modeling experience involving Medicaid, Medicare, and/or Commercial healthcare data. 5+ years of experience with Erwin or comparable data modeling tools such as ER/Studio or SQL Developer Data Modeler. Expertise in conceptual, logical, and physical data modeling. Expertise with normalized OLTP, OLAP, MDM, and dimensional modeling techniques. Strong experience with star schemas, Slowly Changing Dimensions, role-playing dimensions, dimensional hierarchies, and data classification. 5+ years of expert-level SQL experience, including complex analytic queries, stored procedures, DDL, DML, DCL, query optimization, and ANSI SQL. 5+ years of experience with Data Quality, Data Profiling, Data Governance, Data Security, Metadata Management, MDM, Data Archival, and Data Migration. Strong knowledge of HIPAA, PHI, PII, and healthcare data security requirements. Strong problem-solving, communication, influencing, and presentation skills. Ability to work independently in a fast-paced environment with multiple concurrent priorities. Preferred Qualifications State Medicaid EDW or MMIS experience. Experience with Medicaid federal reporting programs such as T-MSIS, PERM, MARS, or Quality of Care. Teradata Vantage experience and exposure to modernization of Teradata workloads to cloud platforms. Microsoft Azure experience, including Azure Data Lake Storage, Azure Data Factory, and Purview. Azure Synapse and/or Databricks Lakehouse experience. Snowflake experience, including data object design and performance tuning. Experience with Delta Lake, Lakehouse architecture, or Microsoft Fabric. Experience with Data Vault modeling. Power BI or Tableau experience. Hands-on ETL experience with Informatica, Azure Data Factory, or similar tools. Python or R experience. Exposure to AI/ML or GenAI tools used for data modeling, documentation, or metadata enrichment. Work Arrangement 100% remote within the Continental U.S. Central U.S. / Midwest candidates preferred. Occasional travel may be required. This role works across distributed and matrixed business and technology teams.

Job Description Job Description Title: Informatica MDM Developer Location: Remote "This is a hands on technical position where the candidate will be responsible for overall implementation of MDM solutions The candidate for this position should have worked on full life cycle of MDM projects in with proven track record of successful implementations Deliver endtoend master data management projects for our customers that includes but not limited to Designing data model MDM Hub configuration designing MDM match rules Performance Improvement E360 Configuration Work closely with customers and architects to understand the project objectivestimelines Comprehensive knowledge of ETL process in MDM space and associated batch and realtime integration including performance tuning Work closely with clients as well as other consultants both at customer sites as well as remote MDM Consultant with 10 years of experience in Information Management Domain and minimum 23 recent full life cycle implementation experience in MDM Solution in various domains Customer Products etc Significant experience of all aspects of the SDLC in the MDM domain is required This is a client facing role MDM Tool Informatica MDM experience is required Skills required Strong business andor technical background in the areas of Master Data Management Data Quality Data Governance Data Integration ETL SoA and Data Security Provide expertise in architecting designing and implementing MDM solutions Perform highlevel architectural planning and proofofconcept where necessary Develop solution outline and support requirements gathering for MDM projects Interface with business and IT stakeholders to identify issues and develop solutions Develop MDM ETL solution architecture and technical architecture Contribute to the analysis of data requirements data integration and perform data mapping Lead Design of the MDM application using MDM tools Configurations and Customizations to the MDM tool and web services Data mapping Function as the Design Authority in technical design reviews Approve code reviews and technical deliverables Plan for development project estimates scheduling and development reviews Assure architectural integrity in MDM solution Maintain compliance with change control SDLC and development standards Develop and review implementation plans and contingency plans Partner with clients to gather necessary understanding of business objectives and processes and provide clients with information about other relevant business factors Good presentation and communication skills required

Job Description Job Description Remote : Informatica powercenter developer with Teradata exp. Most recent project must be Healthcare 10+ years and W2 role H1b transfer is fine H4 EAD,GC,USC Required Qualifications: • 7+ years of experience with Informatica PowerCenter and ETL development. • 5+ years of experience writing complex SQL and performance tuning. • 5+ years of experience with Teradata (v17+), including Fastload, TPT, and Multiload utilities. • 5+ years of Informatica PowerCenter administration experience. • 2+ years of Unix Shell (Bash/Korn) scripting experience. • Strong communication, collaboration, and mentoring skills. • Bachelor's or advanced degree in IT, Computer Science, Mathematics, or a related field. • Strong organizational and time management skills. Preferred Qualifications: • Residing in or near Springfield, IL. • 5+ years of data warehouse development experience. • 5+ years of data modeling experience using ERWIN or similar tools. • 2+ years of experience with Azure Data Factory and Snowflake. • Experience with scripting languages such as Python, R, or JavaScript (React). • Familiarity with Informatica Data Quality (IDQ), Address Doctor, and Metadata Manager. • Experience with Medicaid, Medicare, or healthcare data systems. • Experience working in Agile environments. • Knowledge of BI and data integration technologies across relational and multidimensional systems. Key Responsibilities: • Design and implement ETL solutions using Informatica PowerCenter to extract, transform, and load data from various agency sources. • Automate data staging processes and optimize ETL job scheduling for performance and efficiency. • Administer and support ETL environments, including development and production systems. • Perform repository backups, recovery operations, and system maintenance. • Develop mappings, mapplets, sessions, and workflows using a wide range of Informatica transformations. • Monitor and troubleshoot ETL jobs across development, testing, and production environments. • Write and optimize complex SQL queries and Unix Shell scripts for data marts and interfaces in Teradata. • Collaborate with stakeholders to define requirements, document technical solutions, and support project planning. • Participate in unit, integration, and system testing. • Provide technical support, mentoring, and guidance to team members. • Communicate project status and deliverables to leadership and clients. • Continuously learn and apply new technologies to enhance system performance and capabilities.

Job Description Job Description 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 Working under the guidance of the MDM Technical Lead, you'll provide hands-on technical development and delivery support for MDM services: Use the Informatica MDM tool to combine source data from agency sources, applying required transformations, applying corrections to the source files, and adding new fields via the change request process. Support MDM development and operational activities using working knowledge of Informatica MDM. Automate the staging of data by scheduling scripts to run at optimal times, enhancing overall system performance and efficiency. Implement MDM jobs by creating mappings, mapplets, sessions, and workflows. Work with different ETL transformations, including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank and Source Qualifier, Lookup, and Sorter. Schedule and monitor ETL/Informatica jobs in development, system testing, and production environments. Troubleshoot post-release production support issues and develop solutions. Develop, maintain, and analyze complex SQL queries and scripts used to create data marts in Teradata. Work directly with the QA team to support defect resolution, validation, and testing of MDM-related processes. Participate in project discussions to document and recommend alternative technical solutions or requirements, and in unit, integration, and system testing. Requirements: What You Bring 5+ years of experience in MDM, ETL/ELT, data engineering, or data integration development. 3+ years of hands-on Informatica MDM implementation experience. Experience developing ETL mappings, mapplets, sessions, workflows, transformations, scheduling, monitoring, and troubleshooting Informatica jobs. SQL experience, with large MDM and DBMS enterprise relational platforms. Experience with data quality, matching, unique client/member identifier, standardization, reconciliation, and data governance concepts. Experience supporting ETL/MDM operations, performance tuning, issue resolution, and SDLC delivery. Experience with Python programming for scripting, automation, testing, or data processing support. Bachelor's degree in Computer Science, Data Analytics, Information Systems, Engineering, or equivalent experience. If your experience got you here another way, apply anyway. Preferred Qualifications Experience working in other MDM tools, including cloud-native MDM solutions. Experience working in State government, public sector, or regulated environments. Experience with Agile/Scrum sprint development and iterative/incremental delivery. Experience with healthcare, Medicaid, claims, eligibility, provider, or Health and Human Services data. Exposure to interoperability formats such as X12, EDI, XML, JSON, APIs, or HL7/FHIR. Exposure to cloud data platforms or modernization initiatives such as Azure, ADF, Databricks, Snowflake, or Data Lake. Experience with on-prem-to-cloud migration, MDM modernization, or EDW / ETL modernization initiatives. Exposure to automation, AI/ML, GenAI, or LLM-assisted engineering for development, testing, documentation, profiling, or data quality. Ability to operate in a telecommute environment and matrix organization with minimal direction. Come Build With Us At CSpring, we unlock the potential of people and data. If you're ready to lead meaningful projects, collaborate with passionate teams, and grow your career in a people-first consulting environment- apply today!

Job Description Job Description Informatica MDM Developer - ETL / SQL Remote - Continental U.S. Contract Opportunity (not open to third parties) Central U.S. / Illinois / Midwest candidates preferred Occasional travel may be required Position Overview We are seeking an experienced Informatica MDM Developer to support a large-scale Master Data Management environment. This is a hands-on development role focused on Informatica MDM, ETL/data integration, SQL, data quality, and Python automation. The developer will build and support MDM solutions, Informatica workflows and data loads, troubleshoot production issues, support testing and defect resolution, and help maintain reliable MDM operations. Key Responsibilities Develop and support solutions using Informatica MDM. Integrate data from multiple source systems to support a unified client/member view. Develop Informatica mappings, mapplets, sessions, workflows, and transformations. Work with transformations including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank, Source Qualifier, Lookup, and Sorter. Schedule and monitor Informatica/ETL jobs across development, system testing, and production environments. Automate data staging and processing through scripting. Develop, maintain, and analyze complex SQL queries and scripts. Work with large enterprise relational databases and Teradata. Support data quality, matching, standardization, reconciliation, and data governance processes. Troubleshoot production and post-release issues and develop solutions. Work directly with QA teams on defect resolution, validation, and testing. Participate in unit, integration, and system testing. Participate in technical discussions and recommend solutions or requirements. Use Python for scripting, automation, testing, or data processing support. Required Qualifications 5+ years of experience in MDM, ETL/ELT, data engineering, or data integration development. 3+ years of hands-on Informatica MDM implementation experience. Hands-on experience developing Informatica mappings, mapplets, sessions, workflows, and transformations. Experience scheduling, monitoring, and troubleshooting Informatica jobs. Strong SQL experience working with large MDM and enterprise relational database platforms. Experience with data quality, matching, unique client/member identifiers, standardization, reconciliation, and data governance. Experience supporting ETL/MDM operations, performance tuning, issue resolution, and SDLC delivery. Python experience supporting scripting, automation, testing, or data processing. Bachelor's degree in Computer Science, Data Analytics, Information Systems, Engineering, or equivalent experience. Preferred Qualifications Experience with other MDM platforms, including cloud-native MDM solutions. State government, public-sector, or regulated-industry experience. Healthcare, Medicaid, claims, eligibility, provider, or Health and Human Services data experience. Agile/Scrum experience. Exposure to X12, EDI, XML, JSON, APIs, or HL7/FHIR. Exposure to Azure, ADF, Databricks, Snowflake, Data Lake, or similar cloud data platforms. Experience with MDM, EDW, ETL, or on-premises-to-cloud modernization initiatives. Exposure to automation, AI/ML, GenAI, or LLM-assisted engineering. Ability to work independently in a remote, matrixed environment. Work Arrangement 100% remote within the continental U.S. Central U.S., Illinois, or Midwest location preferred. Occasional travel may be required.