35 jobs found

Job Description Job Description Role: Informatica Developer Location: Austin, TX (Hybrid) Duration: Long Term Need 3 references Previous State experience is highly desirable Responsibilities: Understands business objectives and problems, identifies alternative solutions, performs studies and cost/benefit analysis of alternatives. Analyzes user requirements, procedures, and problems to automate processing or to improve existing computer system Confers with personnel of organizational units involved to analyze current operational procedures, identify problems, and learn specific input and output requirements, such as forms of data input, how data is to be; summarized, and formats for reports. Writes detailed description of user needs, program functions, and steps required to develop or modify computer program. Reviews computer system capabilities, specifications, and scheduling limitations to determine if requested program or program change is possible within existing system. Minimum Requirements: Required Skills 10 years of experience with Informatica tools including PowerCenter, IICS, IDMC, MDM, Axon, EDC, IDQ, Customer360, Supplier360, and Entity360. 10 years of experience establishing Master Data Management (MDM) and Reference Data Management solutions for large enterprise organizations, with expertise in Informatica MDM. 10 years of experience implementing Data Quality rules, validation frameworks, and profiling using Informatica Data Quality (IDQ). Preferred Skills 4 years of experience working with Snowflake and enterprise-scale data platforms. Bachelor's degree in Computer Science, Information Systems, or a related field (equivalent experience accepted); Master's degree or 6 years of relevant experience preferred. 2 years of experience in the Healthcare/Public Health domain. 2 years of experience working with State Government/Public Sector agencies. 2 years of experience developing Python scripts for automation and API integrations.

Job Description Job Description: Position: Senior Data Lineage Developer (Abinitio) Location: Tampa, FL (3 Days onsite/week) Hire Type: Full Time Strong knowledge and good experience in Data Lineage and Metadata Hub. Seeking an experienced Senior ETL Developer to design, build, and maintain complex Abinitio Graphs, Plans, and analytics solutions using Ab initio tools to drive business decisions. They should be able to lead report architecture, optimize SQL query performance, ensure data integrity, collaborate with stakeholders to translate business needs into technical requirements and provide estimate efforts, and ensure timely delivery on committed items and to project manage all aspects of software development according to the Software Development Lifecycle (SDLC). Key Responsibilities: Understanding Business Requirements and Functional Requirements provided by Business Analysts and to convert into Technical Design Documents and leading the development team to deliver on those requirements. Have a good understanding of dependency analysis and its best practices following the established Lineage standards. Verifying Lineage accuracy before promoting the application. Work closely with Cross Functional Teams e.g. Business Analysis, Product Assurance, Platforms and Infrastructure, Business Office, Controls and Production Support. Identify and proactively resolve issues that could impact system performance, reliability, and usability. Demonstrates an in-depth understanding of how the development function integrates within overall business/technology to achieve objectives; requires a good understanding of the industry. Work proactively & independently to address development requirements and articulate issues/challenges with enough lead time to address risks Ability to understand complex data problems, analyze and provide generic solutions compatible with existing Infrastructure. Design, Implement, Integrate and test new features. Take responsibility for successful delivery of the solutions. Mentoring other developers on their implementation as needed, and organizing review activities like design review, code review and technical document review etc. to ensure successful delivery. Explore existing application systems, determines areas of complexity, potential risks to successful implementation. Contribute to continual improvement by suggesting improvements to software architecture, software development process and new technologies etc. Ability to build relationships with business and technology stakeholders. Knowledge/Experience: 7+ Year Software development experience. 3+ Year Oracle PL/SQL or SQL experience 5+ Year ETL Experience (Ab Initio or Informatica). Hands-on experience in developing complex ETL applications. Ab Initio experience is required Proficiency with Oracle PL/SQL or SQL, SQL tuning, writing packages, triggers, functions and procedures. Strong UNIX knowledge. Experience with data conversion / migration Excellent trouble shooting and debugging skills. Knowledge in Abinitio corelate. Worked in Onsite - offshore model. Skills: Strong analytic skills. Excellent communication and internal customer management skills. Excellent written and verbal communication skills. Excellent facilitation skills. Ability to build relationships at all levels.

Job Description Role- Salesforce Developer (Banking or finance) Location: Charlotte, NC (Hybrid 3Days week) Duration: 12-18 Months Technical Skills Salesforce: Apex, Triggers, Visualforce, Administration, Lightning Integration: Mule ESB, ETL, Informatica, Salesforce Web Services API Database: RDBMS Testing: Automation tools and test suites Other: nCino, Metadata API, Salesforce release management Position Summary: We are seeking an experienced Salesforce Developer to join the Commercial Credit Technology organization. The ideal candidate should have strong Salesforce development, Mule ESB, and enterprise integration experience. The candidate will work within an Agile team to deliver business objectives prioritized during PI Planning. Primary Skills Salesforce (SFDC) Mule ESB / ETL Integration Key Responsibilities: Collaborate with onsite teams to understand business requirements and customize existing technology solutions. Develop, enhance, test, maintain, and debug Salesforce applications. Identify and resolve software defects. Support multiple projects and deadlines. Prepare technical specifications, documentation, and test plans. Develop automated test cases using automation tools. Provide production and weekend on-call support during application releases. Estimate story points, contribute to technical design, and review code. Ensure Salesforce governor limits and best practices are followed. Take ownership of team deliverables and mentor junior team members. Mandatory Requirements: 8+ years of experience on the Salesforce platform. Experience with Mule ESB or ETL integration, including at least 2-4 integrations. Minimum of 3-4 Salesforce implementations for large enterprises, preferably involving Sales Cloud and Service Cloud with significant customizations. Strong experience with Apex, Triggers, Batch Apex, Visualforce, and advanced Visualforce components. Knowledge of Chatter API and Salesforce technical architecture. Strong understanding of Salesforce design and development best practices. Experience with automation tools and developing automated test suites. Salesforce Platform Developer I certification preferred. Ability to provide technical estimates, design solutions, review code, and mentor junior developers. Desired Qualifications: Experience supporting production releases and resolving production issues. Willingness to work flexible hours to support business requirements. Experience with SAFe Agile and onsite/offshore delivery models. Knowledge of enterprise Salesforce release management and Metadata API. Experience integrating Salesforce through Web Services APIs. Experience with Agile/XP methodologies. Understanding of functional testing, test scenarios, and automation scripts. Strong analytical, problem-solving, and communication skills. Ability to work in international virtual teams and fast-paced environments. Knowledge of nCino, Informatica, ETL, and RDBMS. Experience with Salesforce Lightning implementations. Salesforce certification(s) preferred. Requirements Education: B.E./ B. Tech/M.E./M. Tech/BSC/MSC/BCA/MCA (prefer IT/CS specialization) Certifications If Any: At least PD 1 Experience Range: 10 Years

Job Title: Senior Oracle PL/SQL Developer - ETL / Data Modeling / Data Warehouse Location: Newark, DE (Onsite Required) Duration: Contract - 12 months Pay Range: $70.23/hr (W2) Job ID: 410994 About BCforward BCforward is a leading global IT consulting and workforce solutions firm providing services and support to Fortune 500 and government clients. Founded in 1998, BCforward has grown with our customers needs into a full-service business solutions provider. With delivery centers and offices across North America and India, we take pride in building long-term relationships and delivering excellence through innovation, collaboration, and integrity. Job Description We are seeking an Senior Oracle PL/SQL Developer - ETL / Data Modeling / Data Warehouse to join our dynamic team supporting the Location and Space Strategy project in Newark, DE. The ideal candidate will have strong experience in Oracle SQL/PLSQL, data modeling, and ETL and a proven ability to design and optimize conceptual, logical, and physical data models for analytics and data warehousing. Responsibilities: Design conceptual, logical, and physical data models to support analytics and data warehousing. Develop and optimize Oracle PL/SQL code, including procedures, packages, and performance tuning. Collaborate with upstream systems of record and downstream consumers to align data models and flows. Improve data flow, data quality, and data integrity across pipelines and processes. Conduct independent analysis of large datasets to identify patterns and present findings. Enhance legacy processes and define new standards for scalability and reliability. Contribute within an agile, fast-paced development environment with minimal supervision. Required Skills & Qualifications: Very strong Oracle SQL and PL/SQL proficiency, including database performance tuning. Data modeling and architecture expertise for analytics and warehousing. Strong data analysis skills with experience evaluating large datasets and ensuring data integrity. Process improvement experience to streamline data flow and quality. Analytical, problem-solving, and clear communication abilities. Bachelor's degree or equivalent in computer science, mathematics, engineering, finance, or related field. Agile development experience and effective teamwork under minimal supervision. 10+ years of experience in Oracle PL/SQL and ETL-related work. Preferred Skills: Experience with ETL tools such as DataStage, Informatica, or Alteryx. Experience with BI tools such as Tableau or MicroStrategy. Familiarity with job scheduling tools such as Autosys or shell scripting. Strong Excel skills. Why BCforward? At BCforward, we believe in advancing lives and careers. When you join our team, you gain access to: Competitive compensation and benefits. Opportunities for growth with global clients. A supportive, inclusive culture that values innovation and people. Exposure to cutting-edge technologies and projects. About Our Commitment BCforward is an equal opportunity employer. We value diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability, or veteran status. Interested? Apply Now! If this sounds like the right opportunity for you, please apply with your most recent resume.

Job Description Job Description Benefits: Health insurance Paid time off Tuition assistance Must have current MBI Clearance 9 years of manual and automation testing experience with a Bachelor's degree; Masters or PhD may be considered in addition to just years of experience Roles and Responsibilities: Conduct functional and/or integration testing of multiple programs in an IBM mainframe or client/server environment. Use relevant documentation to construct test cases with predetermined results and test data to verify program functionality and/or interfaces through assigned systems. Review output to determine whether or not the test results fulfill the established requirements, and if necessary, notify the responsible programmers, both verbally and in writing, of errors, omissions, and inconsistencies in the programs and/or documentation. Coordinate test activities with project stakeholders. Coordinate work assignments to ensure timely and accurate completion of testing. Provide inputs on the required testing level of effort for Unified Work Requests. Minimum Experience: 9 years experience IBM Mainframe Test Engineering 3 years of developing and writing SQL scripts Experience with Any Batch scheduler (Control M) Experience with IBM z/OS Mainframe Experience with BMS Experience extracting Member/Subscriber data from the legacy database Experience with creating and modifying JCL Extensive experience with ISPF Experience with Schema's Worked with SME's, SA's, DBA's and CICS SA's to identify and resolve issues Exposure to IBM Rational Tools: ClearQuest, and JAZZ/Rational Team Concert and Rational Developer z Preferred Experience with the following IRS Projects: MeF (Modernized e-File) ITPE (Individual Tax Processing Engine) RRP (Return Review Program), IDOCS (Individual Document Specific Programs), BDOC (Business Document Specific Programs) IMF (Individual Master File) BMF (Business Master File) CADE2 (Customer Account Data Engine 2) Preferred Skills : Preferred Qualifications: Test automation experience (for example Cucumber, Selenium Webdriver, UFT, etc) Experience with the following skills will be considered a significant plus in considering prospective candidates: IBM Mainframe Unisys Mainframe DB2 Informatica Business Objects Knowledge of current IRS tax administration software applications is a significant plus. Experience with TOAD Rational CLM tools (Quality Manager, Team Concert, Doors Next Generation) Microsoft (MS) Office Excel, MS Word, MS Project, MS Visio CTRL-M (server) Adobe Pro SecureCRT, SecureFx IBM Mainframe (TSO and JCL) Java Batch (SpringBatch) Experience with XML and JSON and previous testing experience to include test cases, test data and the software testing life cycle Agile, Iterative and Rapid Development methodologies Performance testing, Cybersecurity testing, and Section 508 compliance testing Experience with IRS tax administration systems Working knowledge of IBM REXX language IBM File Manager skills with maps/templates on ancient data formats/CRL's Experience with IBM File comparison utilities Knowledge of standard IBM Utilities and Rational CLM (i.e. compare utilities, Rational Quality Manager (RQM), Rational Team Concert (RTC), etc.) Software testing or development experience in an IBM mainframe batch processing environment Working knowledge of updating/executing IBM JCL Knowledge of industry standard Performance tools Knowledge of Individual Tax Processing Engine (ITPE) processing Proficiency with Greenplum Database, PgAdmin tool, and SQL

Job Description Job Description Job Title : AWS Informatica Developer Location: Lafayette, LA Type: Permanent Full Time Work Model: Hybrid Responsibilities Develop, enhance, test, implement, and support ETL workflows using Informatica PowerCenter (CDI PC version). Analyze complex business and technical requirements and translate them into technical specifications. Develop and optimize complex Oracle SQL queries supporting data integration and processing. Develop Python scripts and utilities for data processing, automation, and integration. Create and maintain Unix/Linux shell scripts supporting ETL and batch processing. Work with AWS, including Lambda, SNS, and SQS, to support cloud-based data processing and integrations. Work with Amazon Redshift and Redshift Spectrum for large scale data processing and querying. Develop and support Apache Airflow DAGs for data pipeline orchestration and scheduling. Troubleshoot ETL, data pipeline, application, and production issues and perform root cause analysis. Support CI/CD and automated deployment processes, including Jenkins where applicable. Ensure solutions meet established security, quality, compliance, and operational requirements. Collaborate effectively with business and technology teams in a fast-paced financial services environment. Requirements 5+ years of Informatica experience, with strong hands-on expertise in Informatica PowerCenter (CDI PC version). Informatica PowerCenter experience is required; IDMC should not be considered a substitute for the required PowerCenter experience. Strong enterprise ETL and data integration development experience. Advanced Oracle and SQL skills, including complex query development and troubleshooting. Strong Python scripting/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 Skillset: 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. System One, and its subsidiaries including Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan. System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law. Ref: Pittsburgh

Job Description Job Title : ETL Lead Developer Location : Dallas, TX, Pittsburgh, PA, Cleveland, OH (Onsite) Type : Fulltime with Mastech Digital . 6- 8 years of experience working in relational database design with Oracle and Teradata . Proficient in Informatica, with a good knowledge of ETL development . Strong experience in design, building and testing the Extract, Transform, and Load (ETL) applications . Experience working with enterprise data warehouses . Familiarity extracting data from multiple data sources such as DB2, Oracle, and flat files . Familiarity with database stored procedures . Strong SQL experience required . Experience working in Linux environment and Shell scripting . Provide end user support including business queries and requests. . Provides reviews of the deliverables and identifies gaps and areas of improvement. . Maintain in depth and up to date knowledge of standards, guidelines, and industry trends for Data Integration, Data Migration and Architectures. . Fulfil and design the development for logical data models as well as physical data models. . Proposes, designs & codes software solutions to address complex business needs. Oversees technical and procedural documentation required . Provides technical guidance and support to colleagues and solution development . Displays an innovative approach to apply modern principles, methodologies and tools to advance business initiatives and capabilities . Strong agile/scrum development experience . Strong collaboration and communication skills within distributed project teams . Excellent written and verbal communication skills

Job Description Job Description Pay Rate Range: $ 46.96 - 50.75/hr. Job Description: Key Responsibilities: •Work with business/data product team to translate given business problem into analytical solution with defined outcomes. •Analyze the data in depth, informatica MFT, using SQLs and other exploratory tools against various platforms such as Bigdata, Oracle, SQL Server and others. •Convert business requirements to functional requirements, with detailed transformation rules for ETL team. This is a very technical hands-on role and mandatory to have Informatica MFT, DBT and snowflake •Work closely with the ETL and data science teams to review the requirements and data integrations. •Understand the requirements from Business and Data Science. Understand the business and business impact on use cases. •Write validation scripts to validate the data loaded by ETL team an assess using MFT / DBT. •Work with IT and business customers to develop and design requirements to formulate technical design. •Skills to understand the right functional domain knowledge of the business to be able to gather right requirements for the design. •Capture meta data, data lineage, reference data management and data quality rules as part of data governance. •Work with team spread across the globe in driving the delivery of projects. Required Skills/Knowledge: •Bachelor's degree in computer science, Engineering, or related discipline. •8 years of solutions development / analysis experience, including 5 years in data management/engineering organization. •Proficient understanding of distributed computing principles and informatica Scripts / MFT •Extensive experience in data analysis and data modeling (table design). •Proficiency in SQLs and data exploratory tools. •Extensive experience writing functional requirements and high-level design documents. •Experience in writing validation scripts to validate the data, data integrations and ETL transformations. •Analytical skills to analyze situations and come to optimal and efficient solution based on requirements. •Strong data analysis and profiling skills. •Data warehouse concepts. •Strong analytical skills related to working with unstructured datasets. •SQL knowledge and data analysis skills for data anomaly detection and data quality assurance. •Excellent communication skills, both written and verbal Preferred: •Experience working on MFT and DBT skills and should posses cloud knowledge. •Strong background or working experience in Insurance Industry as a Lead analyst. •Ability to interact with senior leadership teams in IT and business raise the required defect and track project end to using manual or automation design creation. •Should have good SQL knowledge/ AWS and snowflake. •Should be good in Agile methodologies and SDLC process. Skills:CategoryNameRequiredImportanceExperienceSkillCategoryTest1_MNDigital : SnowflakeYes1>7 years

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 Pay Rate Range: $ 49.24 - 56.81/hr. Position: I nformatica Senior Developer Job Description: Requirements •Strong understanding to build Integration between multiple applications •Very good communication and ability to work independently •Self-motivated to understand requirements and perform analysis around multiple applications •Understanding of workforce management system is a plus •Build technical specs, framework for large integration project Technical Skills •Expert in Informatica •Strong experience in Python and big query •Experience handling high-volume data transformation (XML, JSON, CSV) Competencies: 10 years experience Digital : Informatica BDM Experience: •10 year of experience in Informatica Integration •At least 2 complete Integration ProgramsSkills:CategoryNameRequiredImportanceExperienceSkillCategoryTest1_MNDigital : Informatica BDMYes1>7 years

Job Description Job Description Responsibilities: Design, configure, and develop solutions using the Informatica Data Management Cloud (IDMC) MDM SaaS platform. Build and maintain business entities, data quality rules, cloud data integration mappings, match/merge models, and survivorship logic. Implement advanced data quality rules, business events, and publishing events. Collaborate closely with solution architects and testing teams to ensure compliance with architecture standards, data models, and integration patterns. Support documentation of technical solutions, configurations, and deployment procedures. Participate in all phases of System Integration Testing (SIT) and User Acceptance Testing (UAT). Rapidly resolve issues and optimize integration workflows and MDM configurations. Requirements: 3 5 years of hands-on experience in Informatica Master Data Management (preferably IDMC MDM SaaS). Strong understanding of master data management concepts, data quality frameworks, and cloud-based data integration. Experience configuring match rules, survivorship logic, business entities, and event-driven processes. Familiarity with SIT/UAT cycles and defect resolution in cloud data environments. Excellent analytical and problem-solving abilities. Strong communication skills; able to work independently in a remote setting. Behavioral Skills: Effective team collaboration across technical and QA stakeholders. Adaptability and ability to deliver high-quality work within tight deadlines. Key Skills: Informatica MDM, IDMC MDM SaaS, Cloud Data Integration (CDI), Data Quality (DQ), Match & Merge, Survivorship Rules, Business Entities Configuration, Advanced DQ Rules, Publish Events, Business Events, MDM Design & Development, SIT Support, UAT Support, Data Modeling Alignment, MDM Troubleshooting, Integration Workflows.

Job Description Job Description Pay Rate Range: $ 49.24 - 51.51/hr, Job Description: 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. Required Skillset Skill Area Required Capabilities Expected Depth Informatica PowerCenter Mappings, sessions, workflows, mapplets, worklets, reusable transformations, parameter files, dependencies, and runtime behavior Advanced Informatica CDI-PC CDI-PC workflow, mapping, session analysis, parameterization, conversion considerations, and behavioral comparison with IDMC Advanced IICS / IDMC Mapping tasks, taskflows, connections, runtime environments, schedules, assets corresponding to sessions/workflows/mappings, validation, and deployment readiness Advanced Oracle SQL Source/target analysis, complex joins, data validation queries, reconciliation scripts, performance checks, and defect analysis Strong Unix Commands File handling, shell navigation, logs, permissions, grep/sed/awk basics, job support, and parameter/script analysis Strong Python Helpful for automation, validation utilities, metadata extraction, comparison reports, and repeatable migration accelerators Good to have B2B / EDI Awareness Familiarity with B2B services and healthcare EDI formats such as 835 and 837, including file structure awareness and integration considerations Preferred Skill Area Required Capabilities Expected Depth DVO Familiarity with Informatica Data Validation Option for automated data reconciliation and validation Preferred Key Responsibilities 1. 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. 2. 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, taskflows, 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. 3. 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. 4. 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. 5. 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, automation opportunities, templates, and checklists to improve speed, quality, and consistency. 6. Knowledge Management and Team Enablement Prepare and maintain knowledge documentation, technical design notes, conversion playbooks, validation evidence, defect learnings, and implementation standards. Conduct walkthroughs with developers, QA, business analysts, and stakeholders to explain conversion approach, technical decisions, assumptions, and validation outcomes. Mentor team members on CDI-PC to IDMC conversion patterns, transformation differences, IDMC taskflow design, troubleshooting, and documentation practices. Technical Expectations by Workstream Workstream Tech Lead Ownership Key Outputs Discovery and Analysis Lead asset inventory review, complexity assessment, dependency mapping, parameter file review, and gap identification. Analysis notes, complexity ratings, effort estimates, migration assumptions, risk log IDMC Build Guide and review creation of mappings, mapping tasks, taskflows, connections, parameters, and other migrated assets. IDMC assets, build checklist, peer review findings, configuration standards Transformation Remediation Evaluate Java, XML, and complex transformation behavior and define IDMC-compatible design patterns. Remediation design, conversion rules, transformation decision log Validation and Testing Define validation approach, review SQL/DVO reconciliation, support test execution, and drive defect closure. Test evidence, reconciliation reports, defect RCA, sign-off inputs Delivery Governance Estimate, plan, allocate tasks, monitor progress, escalate risks, and improve repeatable delivery process. Task plan, allocation tracker, status inputs, lessons learned, process improvements Knowledge Documentation Document conversion patterns, standards, limitations, and operational knowledge for future support. KT documents, playbooks, runbooks, best-practice guides Minimum Qualifications 8 years of experience in Informatica delivery, with strong hands-on experience in PowerCenter and/or CDI-PC. Practical experience with IICS / IDMC asset creation, validation, and troubleshooting. Strong Oracle SQL skills for data analysis, reconciliation, and defect investigation. Working knowledge of Unix commands for file processing, log review, and operational support. Experience leading technical teams, assigning work, reviewing deliverables, and guiding remediation of complex issues. Ability to understand existing ETL logic, compare behavior across platforms, and translate legacy designs into IDMC assets. Preferred Qualifications Experience in Informatica CDI-PC to IDMC / IICS conversion or modernization programs. Familiarity with B2B services and EDI files, especially healthcare-related 835/837 formats. Experience with Informatica Data Validation Option (DVO) or similar automated data validation tools. Python scripting experience for automation, metadata parsing, comparison reporting, or validation utilities. 5 years of Experience in Design Develop and maintain data integration workflows using Informatica IDMC (Cloud Data Integration (Azure) Cloud Application Integration etc.). 2. Build and optimize ETL/ELT pipelines that ingest transform and load data into Databricks Lakehouse. 3. Proficiency in Linux/Python scripting 4. Collaborate with data architects analysts and business stakeholders to understand data requirements and deliver robust solutions. 5. Implement best practices for data governance metadata management and data quality using Informatica tools. 6. Configure and manage connections between Informatica IDMC and Databricks including secure authentication and data movement strategies. 7. Monitor and troubleshoot data pipelines for performance reliability and scalability. 8. Automate data workflows and orchestrate jobs using Informaticas scheduling and event-driven capabilities. 9. Document technical specifications data flow diagrams and operational procedures. 10. Experience with Peta byte scale data ingestion data migration. 11. Ability to adopt various type of data formats and data sizes. Essential Skills: Informatica IDMC (IICS) Developer Keyword: Azure data factory Databricks Azure Synapse Analytics Python Sql Pyspark Databricks Skills: Informatica Powercentre Experience Required: 10 & Above Skills:CategoryNameRequiredImportanceExperienceSkillCategoryTest1_MNInformatica PowercentreYes1>7 years

Job Description Job Description Must Have Skills Hands-on experience migrating Informatica workflows to IDMC. Strong understanding of ETL, SQL, and Unix. Ability to lead a team working on the migration of Informatica PowerCenter workflows to IDMC. Ability to identify migration issues and compatibility challenges and provide appropriate solutions. Role Summary We are seeking an experienced Informatica PowerCenter (PC) and Informatica Intelligent Data Management Cloud (IDMC/IICS) Developer to support the migration of enterprise data integration solutions from Informatica PowerCenter to IDMC. The ideal candidate will have strong ETL development experience, hands-on expertise in both PowerCenter and IDMC services, and experience assessing, migrating, and optimizing ETL workloads in cloud environments. Key Responsibilities Analyze existing Informatica PowerCenter mappings, workflows, sessions, and reusable objects for migration to IDMC. Design, develop, test, and deploy ETL/ELT solutions using Informatica Cloud Data Integration (CDI) and other IDMC services. Perform end-to-end migration activities from PowerCenter to IDMC, including mapping and workflow assessment, conversion and redevelopment of ETL logic, parameter and configuration migration, validation and reconciliation, and performance optimization. Review and compare DEV, QA, and PROD environments to identify configuration, parameter, and code differences. Validate production configurations and dependencies to ensure accurate migration. Migrate and optimize complex transformations, workflows, task flows, and reusable components. Work with source and target systems including Oracle, SQL Server, and flat-file integrations. Troubleshoot migration issues and resolve data quality, performance, and connectivity challenges. Create migration documentation, technical specifications, and deployment procedures. Collaborate with architects, business analysts, and support teams throughout the migration lifecycle. Perform unit testing, system integration testing, and production validation. Role Description1. 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. 2. 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, taskflows, 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. 3. Complex Transformation Handling Provide technical analysis for complex Informatica transformations, including Java transformations, XML transformations, expression/router/lookup/aggregator patterns, and reusable transformation logic. Understand transformation behavior 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. 4. 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. 5. 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 and 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. Desirable Skills Azure Data Factory Databricks Azure Synapse Analytics Python SQL PySpark Keyword: Azure Data Factory Databricks Azure Synapse Analytics Python SQL PySpark Databricks Skills: Informatica PowerCenter Experience Required: 10 years

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.

Job Description Job Description Senior Data & Analytics ArchitectEnterprise Data Warehouse Modernization Remote 12+ Month Contract Candidates must be authorized to work in the United States without sponsorship. Not open to third-party firms, consulting companies We are seeking a Senior Data & Analytics Architect to lead a large-scale Enterprise Data Warehouse (EDW), reporting, and analytics modernization initiative. This is a hands-on architecture leadership role responsible for defining technical strategy, solution architecture, modernization roadmaps, and engineering execution across enterprise data, reporting, and analytics platforms. Key Responsibilities Lead end-to-end architecture for enterprise data warehouse, reporting, analytics, and data integration solutions. Drive modernization of legacy ETL processes, SQL code, Unix/Linux scripts, and manual workflows into scalable Python-based solutions and automation frameworks. Translate complex business, operational, and regulatory requirements into scalable and maintainable technical designs. Design architecture across databases, APIs, application services, orchestration, scheduling, security, monitoring, and cloud platforms. Build proof-of-concepts and evaluate technology options to support architectural decision-making. Lead enterprise reporting and analytics initiatives, including data quality, reconciliation, drill-down reporting, and reporting modernization. Establish engineering best practices utilizing Azure DevOps, CI/CD pipelines, source control, code review processes, and deployment automation. Partner with infrastructure, cloud, security, analytics, and engineering teams to deliver enterprise-scale solutions. Develop architecture diagrams, technical specifications, implementation plans, operational models, and modernization roadmaps. Mentor architects, engineers, ETL developers, BI developers, analysts, and testers. Present technical recommendations, risks, and strategic solutions to executive leadership and key stakeholders. Required Qualifications Bachelor's degree in Computer Science, Engineering, Information Systems, or a related discipline, or equivalent professional experience. 10+ years of experience in Data Architecture, Analytics Architecture, Solution Architecture, or Enterprise Architecture roles. Proven success architecting and delivering enterprise data warehouse, analytics, reporting, and transaction-processing solutions. Strong hands-on Python development experience. Advanced SQL development, optimization, and troubleshooting expertise. Experience designing data-intensive applications, APIs, databases, security frameworks, job scheduling, and monitoring solutions. Experience with enterprise BI and reporting tools such as Power BI, Tableau, BusinessObjects, SAS, or similar platforms. Experience implementing Azure DevOps, Git-based source control, branching strategies, CI/CD pipelines, and automated deployment processes. Experience leading cross-functional engineering and analytics teams. Excellent communication and stakeholder management skills. Preferred Qualifications Healthcare payer, Medicaid, managed care, or health insurance experience. Experience supporting CMS, Medicaid, regulatory, or federal reporting initiatives. Experience with cloud migration and modernization programs. Hands-on experience with Azure, Azure Data Factory, Databricks, Azure Data Lake Storage, Snowflake, or similar cloud data platforms. Experience with Informatica, Teradata, or enterprise ETL and data integration technologies. Strong data modeling experience, including conceptual, logical, physical, dimensional, and transactional models. Experience leveraging AI-assisted engineering, automation, testing, or code conversion within enterprise environments. Knowledge of HIPAA, PHI, PII, and regulated data environments. Preferred Technical Stack Python SQL Azure Azure Data Factory (ADF) Databricks Snowflake Teradata Informatica Power BI Tableau BusinessObjects Azure DevOps CI/CD Data Warehousing Analytics Data Integration Enterprise Architecture Additional Requirements 12+ month contract opportunity. 100% remote position. Candidates must reside within the Continental United States. Candidates must be authorized to work in the United States without sponsorship. Not open to third-party firms, consulting companies, C2C arrangements, or vendor submissions. Direct applicants only. Why Join Us Lead enterprise-scale data and analytics modernization initiatives. Influence architecture strategy and technology direction. Work with modern cloud and data platforms. Drive transformation from legacy technologies to scalable, automated solutions. Collaborate with senior leadership and high-performing technical teams.

Job Description Job Description Job Description:Please strictly adhere to the following resume naming convention: ALL CAPS, NO SPACES B/T UNDERSCORES PTN_US_GBAMSREQID_CandidateBeelineID i.e. PTN_US SKIPJOHNSON0413 MSP Owner: William Bristol Location: See Below Duration: 6 months Role Overview 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. Required Skillset Skill Area Required Capabilities Expected Depth Informatica PowerCenter Mappings, sessions, workflows, mapplets, worklets, reusable transformations, parameter files, dependencies, and runtime behavior Advanced Informatica CDI-PC CDI-PC workflow, mapping, session analysis, parameterization, conversion considerations, and behavioral comparison with IDMC Advanced IICS / IDMC Mapping tasks, taskflows, connections, runtime environments, schedules, assets corresponding to sessions/workflows/mappings, validation, and deployment readiness Advanced Oracle SQL Source/target analysis, complex joins, data validation queries, reconciliation scripts, performance checks, and defect analysis Strong Unix Commands File handling, shell navigation, logs, permissions, grep/sed/awk basics, job support, and parameter/script analysis Strong Python Helpful for automation, validation utilities, metadata extraction, comparison reports, and repeatable migration accelerators Good to have B2B / EDI Awareness Familiarity with B2B services and healthcare EDI formats such as 835 and 837, including file structure awareness and integration considerations Preferred Skill Area Required Capabilities Expected Depth DVO Familiarity with Informatica Data Validation Option for automated data reconciliation and validation Preferred Key Responsibilities 1. 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. 2. 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, taskflows, 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. 3. 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. 4. 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. 5. 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, automation opportunities, templates, and checklists to improve speed, quality, and consistency. 6. Knowledge Management and Team Enablement Prepare and maintain knowledge documentation, technical design notes, conversion playbooks, validation evidence, defect learnings, and implementation standards. Conduct walkthroughs with developers, QA, business analysts, and stakeholders to explain conversion approach, technical decisions, assumptions, and validation outcomes. Mentor team members on CDI-PC to IDMC conversion patterns, transformation differences, IDMC taskflow design, troubleshooting, and documentation practices. Technical Expectations by Workstream Workstream Tech Lead Ownership Key Outputs Discovery and Analysis Lead asset inventory review, complexity assessment, dependency mapping, parameter file review, and gap identification. Analysis notes, complexity ratings, effort estimates, migration assumptions, risk log IDMC Build Guide and review creation of mappings, mapping tasks, taskflows, connections, parameters, and other migrated assets. IDMC assets, build checklist, peer review findings, configuration standards Transformation Remediation Evaluate Java, XML, and complex transformation behavior and define IDMC-compatible design patterns. Remediation design, conversion rules, transformation decision log Validation and Testing Define validation approach, review SQL/DVO reconciliation, support test execution, and drive defect closure. Test evidence, reconciliation reports, defect RCA, sign-off inputs Delivery Governance Estimate, plan, allocate tasks, monitor progress, escalate risks, and improve repeatable delivery process. Task plan, allocation tracker, status inputs, lessons learned, process improvements Knowledge Documentation Document conversion patterns, standards, limitations, and operational knowledge for future support. KT documents, playbooks, runbooks, best-practice guides Minimum Qualifications 8 years of experience in Informatica delivery, with strong hands-on experience in PowerCenter and/or CDI-PC. Practical experience with IICS / IDMC asset creation, validation, and troubleshooting. Strong Oracle SQL skills for data analysis, reconciliation, and defect investigation. Working knowledge of Unix commands for file processing, log review, and operational support. Experience leading technical teams, assigning work, reviewing deliverables, and guiding remediation of complex issues. Ability to understand existing ETL logic, compare behavior across platforms, and translate legacy designs into IDMC assets. Preferred Qualifications Experience in Informatica CDI-PC to IDMC / IICS conversion or modernization programs. Familiarity with B2B services and EDI files, especially healthcare-related 835/837 formats. Experience with Informatica Data Validation Option (DVO) or similar automated data validation tools. Python scripting experience for automation, metadata parsing, comparison reporting, or validation utilities. Role Descriptions: 5 years of Experience in Design Develop and maintain data integration workflows using Informatica IDMC (Cloud Data Integration (Azure) Cloud Application Integration etc.).2. Build and optimize ETL/ELT pipelines that ingest transform and load data into Databricks Lakehouse.3. Proficiency in Linux/Python scripting4. Collaborate with data architects analysts and business stakeholders to understand data requirements and deliver robust solutions.5. Implement best practices for data governance metadata management and data quality using Informatica tools.6. Configure and manage connections between Informatica IDMC and Databricks including secure authentication and data movement strategies.7. Monitor and troubleshoot data pipelines for performance reliability and scalability.8. Automate data workflows and orchestrate jobs using Informaticas scheduling and event-driven capabilities.9. Document technical specifications data flow diagrams and operational procedures.10. Experience with Peta byte scale data ingestion data migration.11. Ability to adopt various type of data formats and data sizes. Essential Skills: Informatica IDMC (IICS) Developer Desirable Skills: Azure data factory Databricks Azure Synapse Analytics Python Sql Pyspark Databricks . click apply for full job details

Job Description Job Description 8-10+ years of experience in ETL development using Informatica PowerCenter . Strong understanding of data warehousing concepts , dimensional modeling, and star/snowflake schemas. Experience with SQL, PL/SQL , and performance tuning of database queries. Knowledge of data quality, data governance, and best practices in ETL development. Strong analytical, problem-solving, and communication skills. Experience with version control systems and ETL deployment processes.

Job Description Job Description Informatica IDMC Consultant Location - New Jersey (3 Days WFO) Pay Rate: Market- based on exp. Long term Sr. ETL Developer. Design, develop, test and deploy the code in the QA and production environment as per the requirement. 1. Requirement analysis and design 2. Coding and unit testing 3. Integration Testing 4. User acceptance testing support 5. Hyper care support 6. Transition to support team Key Responsibilities: Develop ETL processes using Informatica Cloud Data Integration, including constructing mappings, tasks, task flows, schedules, and parameter files. Ensure adherence to ETL and ELT best practices and maintain ETL mapping documentation. Understand and apply database designs and SQL effectively. Familiarize with SDLC and Agile methodologies to enhance project delivery. Good to have experience in SAP and Workday integration Utilize strong problem-solving and analytical skills to conduct root-cause analysis. Communicate effectively in both verbal and written forms to all organizational levels. Collaborate with team members and maintain strong interpersonal relationships. Demonstrate dedication to quality work with strong organizational skills and attention to detail. Handle support activities, including ticket creation and resolution using Jira and ServiceNow. Required Skills: 8 years of experience in Informatica, with at least 2 years of experience in IDMC. Strong experience in ETL tools, particularly IDMC as the primary tool and Informatica as secondary. Good understanding of ETL and ELT best practices. Proficient in database designs and SQL.

Job Description Job Description Informatica MDM Platform Lead Role Overview As a Senior MDM Informatica Platform Support Specialist, you will play a critical role in supporting and optimizing Master Data Management (MDM) platforms powered by Informatica. You will be responsible for ensuring the stability, performance, and scalability of MDM solutions that underpin essential data-driven processes in the Life Sciences and Healthcare sector. Your expertise will directly contribute to the reliability and quality of data that informs clinical, operational, and strategic decisions across the organization. Responsibilities Oversee the end-to-end support and maintenance of Informatica MDM platforms, including troubleshooting, performance tuning, and incident resolution. Collaborate with cross-functional teams to ensure data integrity, security, and compliance with healthcare regulations. Monitor system health, conduct root cause analysis, and implement preventative measures for recurring issues. Manage platform upgrades, patch installations, and configuration changes with minimal downtime and maximum data protection. Develop and maintain documentation for standard operating procedures, support processes, and knowledge base articles. Assist in data integration activities, including data migration, synchronization, and transformation to maintain consistency across systems. Provide senior-level escalation support for complex platform issues and mentor junior team members. Engage in capacity planning and recommend enhancements to improve platform efficiency and scalability. Support disaster recovery planning and execution, ensuring business continuity for critical data assets. Participate in regular audits and compliance checks to align platform operations with industry standards and organizational policies. Skill Requirements Minimum of 7 years experience in Informatica MDM platform support, administration, or development. Deep technical expertise in Informatica MDM, including Hub Console, Data Director, and IDD configurations. Strong understanding of data governance, data quality, and master data management concepts in the Life Sciences and Healthcare domain. Proficiency with database technologies (Oracle, SQL Server), data integration tools, and scripting languages (Shell, Python). Experience with platform monitoring tools, ticketing systems, and ITIL-based support processes. Excellent analytical, problem-solving, and communication skills. - Proven track record in handling incident and change management in a regulated environment. Informatica certifications (such as Informatica MDM Administrator or Developer) are highly desirable. Experience supporting cloud-based MDM deployments (AWS, Azure, or GCP) is a plus. Working knowledge of regulatory frameworks such as HIPAA, GDPR, and GxP. - Familiarity with DevOps methodologies and automation tools for platform management. Ability to work in a global, multicultural team and support on-call or off-hours as needed.