Senior Data Governance Consultant - Informatica CDGC

Spectraforce
Newark, NJ, United States
5 days ago
Apply on leoforce.us
Prepare application

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Working hours
Regular working hours
Job source

Tech stack

Java (Programming Language) Application Programming Interfaces (APIs) Amazon Web Services Amazon S3 Data Analysis Microsoft Azure Cloud Computing Profiling Information Engineering Data Governance Relational Databases Python (Programming Language)
+16 more
PostgreSQL Microsoft SQL Server MongoDB NoSQL Oracle (Applications) Power BI SQL Databases Data Streaming Microsoft Fabric Data Lineage Complex Event Processing Apache Kafka Restful APIs Amazon Simple Queue Service (SQS) Marketplace Microservices

Job description

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 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., * 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

Requirements

  • 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 in Informatica 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
  • Cloud Platforms - AWS (S3, DocumentDB, Kinesis), Microsoft Azure
  • Data Governance Concepts - catalog management, classification, glossary, stewardship workflows

Nice to Have:

  • Microsoft Fabric or Power BI lineage integration
  • Atacama RDM or Denodo experience
  • Financial services or insurance industry background
  • Informatica CDI experience

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on leoforce.us
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

2:01 min

Migrating existing applications from MongoDB to Postgres

Nikita Shamgunov Nikita Shamgunov · World Congress 2024

2:37 min

Comparing traditional SQL tables versus NoSQL non-tabular databases

Stanimira Vlaeva · JS Congress

1:46 min

Traditional data architecture before Microsoft Fabric

Dr. Alexander Wachtel Dr. Alexander Wachtel +1 · World Congress 2025

3:14 min

Structuring career paths and localized data architectures

Ulrich Wurstbauer +1 · LIVE

Videos

See all

Related articles

See all