Informatica Architect

1 week ago

Albany, United States InterSources Full time
Job Title: Informatica Architect
Work Location: Albany, NY (40% Remote)
Duration: 27 months contract

Position Summary:
Mandatory Qualifications:
  • Level III- More than seven (7) years of experience working on complex projects with 2 or more years in a leadership role as an Architect
  • More than ten (10) years of hands-on professional experience as an Architect in multiple Master Data Management (MDM) projects architecting, planning, designing, developing, implementing, testing, and integrating successful MDM solutions including data cleansing, data ingestion pipelines, matching, merging, deduplication, hierarchy management, standardization, automation, and orchestration of enterprise Master and Reference data such as Clients and Providers data to create the single version of the truth (e.g., golden record) and to create a Common Client Index (CCI) and a Master Provider Index (MPI) to support applications and data sharing in batch and real-time modes
  • More than ten (10) years of hands-on professional experience using Informatica Master Data Management (MDM) Hub to build data models and configure rules to implement MDM solutions. This includes but not limited to Informatica MDM architecture, MDM Hub Workbenches, Informatica Data Director, Provisioning Tool, ActiveVOS, Customer 360, Informatica Master Database, Operational Reference Store (ORS) Database, Services Integration Framework (SIF), Queries Tool, Packages Tool, BPM workflow, Data Encryption, Hierarchy Manager, Mappings tool, audit trail, delta detection, message queues tool, JMS messages, and Batch Jobs
Desirable Qualifications:
  • Ten (10) or more years of hands-on professional experience building landing tables, staging tables, and base objects to develop a comprehensive master data model such as the party data model, client/customer data model, or provider/vendor data model in Informatica MDM Hub to support MDM solutions
  • Ten (10) or more years of hands-on professional experience creating data profiling rules, data cleansing rules, data match rules (exact match, fuzzy match), merge options, auto-merge rules, manual merge rules, un-merge rules, validation rules, and trust rules in Informatica MDM and Informatica Data Quality products
  • Seven (7) or more years of hands-on professional experience in Informatica MDM Hub load process, landing process, staging process, consolidate process, exception handling process, and publishing process
  • Seven (7) or more years of hands-on professional experience in designing, developing, and maintaining integrations between Informatica MDM solutions and other systems using APIs, web services, message queues, Java Message Service (JMS), ESB, Kafka, and ETL tools
  • Seven (7) or more years of hands-on professional experience using tools such as Informatica PowerCenter or Informatica Data Quality to export, transform and load data from source databases (e.g., Oracle) and flat files into the Informatica MDM landing tables
  • Seven (7) or more years of hands-on professional experience integrating Informatica MDM solutions with medium to large scale, high volume OLTP and OLAP systems such as Case Management systems, Enrollment and Eligibility systems, Financial Management systems, Child Support systems, Court Hearings systems, or similar systems
  • Five (5) years or more of hands-on experience using data modeling software (e.g., Erwin Data Modeler) and developing complex SQL queries, Oracle PL/SQL packages, stored procedures, functions, views, complex joins, indexes, triggers, external tables, roles, grants, permissions, DDL, and DML
  • Seven (7) or more years of hands-on professional experience in data analysis, metadata cataloging, creating, and maintaining documentation including technical specifications, data mappings, data dictionary, data lineage, data flow diagrams, and high-level and low-level design
  • Domain knowledge and experience in health and human services, especially in Integrated Eligibility System programs such as PA, TA, SNAP, HEAP, TANF, etc.
  • Knowledge and experience in applying data management concepts such as data architecture, data quality, metadata management, Data Warehousing and Business Intelligence, data integrity, data integration and interoperability, data governance, data security, data storage and operations
About Us:
InterSources Inc, a Certified Diverse Supplier, was founded in 2007 and offers innovative solutions to help clients with Digital Transformations across various domains and industries. Our history spans over 16 years and today we are an Award-Winning Global Software Consultancy solving complex problems with technology. We recognize that our employees and our clients are our strengths as the diverse talents and opportunities they bring to the table enable us to grow as a global platform and they are causally linked with our success. We provide strategic and technical advice, and we have expertise in areas covering Artificial Intelligence, Cloud Migration, Custom Software Development, Data Analytics Infrastructure & Cloud Solutions, Cyber Security Services, etc. We make reasonable accommodations for clients and employees and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud partner company. We align strategy with execution and provide secure service solutions by developing and using the latest technologies that thrive our resources to deliver industry-leading capabilities to our clients and customers, making it convenient for our clients to do business with InterSources Inc. Our teams also drive growth by refining technology-driven client experiences that put the users first, providing an unparalleled experience. This results in strengthening the core technologies of clients, enabling them to scale with flexibility, create seamless digital experiences and build lifelong relationships.

  • Informatica Master Data Management

    2 weeks ago

    Albany, United States Manpower Group Inc. Full time

    There is government form to be complete – So resume is due no later than 11/29/2024 to be considered MDM Architect Designated Work Location: 40 N Pearl Street, Albany, NY Anticipated Duration of the Engagement: 27 months Consultant must be based in Albany, NY, or the surrounding states. Client is willing to do Webex but must work on site- 1 week on site...

  • MDM Architect

    2 weeks ago

    Albany, United States DCM INFOTECH LIMITED Full time

     Mandatory Qualifications: Level III- More than seven (7) years of experience working on complex projects with 2 or more years in a leadership role as an Architect More than ten (10) years of hands-on professional experience as an Architect in multiple Master Data Management (MDM) projects architecting, planning, designing, developing, implementing,...

  • Master Data Management Architect

    7 days ago

    Albany, New York, United States InterSources Full time

    About UsAt InterSources Inc, a Certified Diverse Supplier, we've been driving digital transformations for over 16 years. As an Award-Winning Global Software Consultancy, we help clients tackle complex problems with innovative technology solutions.Job OverviewWe're seeking a seasoned MDM Solutions Expert to join our team. This is a long-term contract...

  • Data Management Architect Lead

    6 days ago

    Albany, New York, United States Experienced Recruiting Partners Full time

    About the RoleWe are seeking an experienced Data Management Architect Lead to join our team at Experienced Recruiting Partners. This is a full-time, 27-month contract role based in Albany, NY.The salary for this position is estimated to be around $140,000 - $180,000 per year, depending on experience.Job Description:Collaborate with cross-functional teams to...

  • Data Modeling Architect W/ OBIEE 11G

    1 week ago

    Albany, United States GovServicesHub Full time

    Job DescriptionJob Location:  Available to work On-Site, Albany, NY. Job Description: /Skills Set: SkillRequired /DesiredExperienceexperience with developing and maintaining logical and physical dimensional data models, building data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema, etcRequired6...