Informatica CDGC Data Governance Consultant

JSR Tech Consulting; Newark (NJ); On-site; USD 150,000 - 190,000; Full time

Job summary

JSR Tech Consulting in Newark, NJ seeks a senior Data Governance Consultant with expert Informatica CDGC skills to scan, catalog, govern, and publish a complex data estate spanning relational, NoSQL, API and event-driven sources. A key focus is shore up ingestion for MongoDB and AWS DocumentDB where native connectors are absent.

The role involves building end-to-end data lineage, publishing Data Products in Informatica Marketplace, and enabling governance across Kafka, Kinesis, S3, and Power BI

Qualifications

• CDGC expert-level with production experience across scanning, cataloging, lineage and data products.
• Informatica Profiling to assess data quality, completeness and patterns.
• Informatica Data Products & Marketplace—defining and publishing data products.
• NoSQL scanning solutions for sources without native Informatica connectors.
• MongoDB and AWS DocumentDB: schema, connections, metadata extraction.
• API scanning: catalog REST APIs and microservices as governed assets.
• Event processing: integrate Kafka or Kinesis for lineage and governance.
• Data engineering: Python and/or Java for scripting and ingestion.
• Relational databases: Oracle, MS SQL Server, PostgreSQL.
• Data governance concepts: catalog, classification, glossary, stewardship workflows.

Responsibilities

• Design and execute metadata scanning across relational, NoSQL, API, and event-driven source types into Informatica CDGC.
• Implement viable ingestion solutions for MongoDB and AWS DocumentDB using Informatica tooling and APIs.
• Catalog REST APIs and microservices; integrate event-driven sources for lineage tracking.
• Configure connections across Oracle, MS SQL Server, PostgreSQL, AWS S3 and NoSQL platforms.
• Build end-to-end data lineage from sources through AWS S3, Microsoft Fabric, and Power BI.
• Publish Data Products in Informatica Marketplace for governed asset delivery.
• Support curation workflows: classification, glossary association, profiling, stewardship alignment.
• Troubleshoot scanning failures, connectivity issues, and metadata quality gaps.
• Document configurations, ingestion approaches, lineage patterns and Data Product definitions.

Tools

Informatica tooling

Job description

Senior Data Governance Consultant – Informatica CDGC

Rate is Open.

C2C is fine.

About the Role

We're seeking a senior consultant with expert-level Informatica CDGC skills to scan, catalog, govern, and publish a complex data estate spanning relational, NoSQL, API, and event-driven source systems. A significant portion of this work involves non-SQL sources (MongoDB, AWS DocumentDB) where Informatica has no native connectors, requiring a resourceful engineer who can assess available tooling and implement a viable ingestion solution. The consultant will also stand up Data Products in Informatica.

What You'll Do

• Design and execute metadata scanning across relational, NoSQL, API, and event-driven source types into Informatica CDGC
• Implement viable scanning solutions for MongoDB and AWS DocumentDB using Informatica tooling, ingestion APIs, and scripted extraction
• Catalog REST APIs and microservices as governed assets; integrate event-driven sources (Kafka, AWS Kinesis/SQS) for lineage tracking
• Configure connections across Oracle, MS SQL Server, PostgreSQL, AWS S3, and NoSQL platforms
• Build and validate end-to-end data lineage from source systems through AWS S3, Microsoft Fabric, and Power BI
• Define and publish Data Products in Informatica Marketplace for governed, consumable asset delivery
• Support curation workflows: classification, glossary association, profiling, and stewardship alignment
• Troubleshoot scanning failures, connectivity issues, and metadata quality gaps
• Document all configurations, ingestion approaches, lineage patterns, and Data Product definitions for team knowledge transfer

Required Skills & Experience

• Informatica CDGC — expert-level; hands-on production experience with scanning, cataloging, lineage, classification, and Data Products
• Informatica Profiling — hands-on experience running and interpreting data profiling to assess data quality, completeness, and patterns across scanned assets
• Informatica Data Products & Marketplace — defining, publishing, and managing data products
• NoSQL scanning solutions — proven ability to implement metadata ingestion for sources without native Informatica connectors
• Non-SQL databases — MongoDB and AWS DocumentDB: schema structures, connection methods, metadata extraction
• API scanning — cataloging REST APIs and microservices as governed assets in Informatica CDGC
• Event processing — integrating Kafka, AWS Kinesis, or equivalent into a data catalog for lineage and governance
• Data engineering — strong Python and/or Java for scripting and ingestion work
• Relational databases — Oracle, MS SQL Server, PostgreSQL
• Data governance concepts — catalog management, classification, glossary, stewardship workflows

Nice to Have

• Microsoft Fabric or Power BI lineage integration
• Financial services or insurance industry background