We are seeking a Senior Data Engineer with deep Informatica PowerCenter, Oracle and Microsoft SQL Server experience to deliver secure identity and access management (IAM) data integrations. The engineer will design and operate ETL workflows that extract application accounts, users, roles and entitlements from databases, APIs, and file-based sources; transform them into accurate, auditable outbound feeds; and support delivery to SailPoint or other IAM/identity governance platforms. Success requires strong SQL tuning, robust batch operations and a hands-on approach to source-system discovery and production issue resolution.
Required Skills - 6-7+ years of data integration, ETL or enterprise data engineering experience preferred.
Strong hands-on Informatica PowerCenter mapping, workflow and session development, deployment and troubleshooting.
Advanced Oracle and Microsoft SQL Server SQL development and performance tuning.
Job Responsibilities
Job Duties - ETL and identity data integration
Design, develop, enhance and support Informatica PowerCenter mappings, sessions and workflows for enterprise identity and entitlement data.
Build source-to-target mappings and transformation rules across Oracle, Microsoft SQL Server, APIs and flat-file sources.
Extract, normalize and reconcile user accounts, role assignments, permissions, service accounts and access relationships from legacy and modern systems.
Develop outbound IAM/identity governance feeds, including scheduled access certification files and entitlement data extracts.
Implement reliable, controlled flat-file creation and secure file transfer, including file naming, validation, delivery tracking and exception handling.
Coordinate with SailPoint/IAM teams to agree target formats, required attributes, data quality rules, delta/full-load behavior and reconciliation processes.
Database engineering and operational quality
Develop advanced SQL and database objects for Oracle and SQL Server; tune joins, extraction queries, indexing strategy and ETL throughput.
Investigate source schemas to identify identity and role tables, interpret custom authorization structures and document lineage.
Build workflow scheduling, monitoring, restart/recovery procedures, failure alerts, control totals, audit trails and idempotent reprocessing.
Troubleshoot failed ETL jobs, malformed files, connectivity failures, missing entitlements and source-to-target discrepancies.
Execute data profiling, quality checks, deduplication, completeness testing, reconciliation and system/integration testing.
Partner with DBAs, developers, cybersecurity, IAM and support teams to manage performance, database access and operational stability.
Legacy sources and migration support
Support discovery and integration of legacy feeds and mainframe-derived user/access information where required.
Collaborate with mainframe specialists on DB2, COBOL, JCL and z/OS interfaces and batch extract schedules, without requiring ownership of mainframe program development.
Document end-to-end lineage, schedules, control mechanisms, mappings and support procedures; enable repeatable delivery across application portfolios.
Job Requirements - Required Qualifications & Technical Skills
6-7+ years of data integration, ETL or enterprise data engineering experience preferred.
Strong hands-on Informatica PowerCenter mapping, workflow and session development, deployment and troubleshooting.
Advanced Oracle and Microsoft SQL Server SQL development and performance tuning.
Experience building, validating and scheduling secure flat-file and database-driven ETL interfaces.
Experience with source-to-target mappings, data quality rules, transformation logic, reconciliation and batch restart/recovery.
Familiarity with enterprise security/entitlement data models, or demonstrated ability to map complex reference and relationship data.
Strong incident troubleshooting, stakeholder communication, technical documentation and production-support skills.
Working knowledge with AI tools like Claude, Cursor or Copilot.
Desired Skills & Experience - Preferred Qualifications
Experience integrating identity and access data with SailPoint or a similar IAM/identity governance platform.
Experience developing daily account/entitlement certification extracts and outbound security data feeds.
Knowledge of Informatica Intelligent Data Management Cloud (IDMC), Python or shell scripting.
Exposure to JDBC, REST/SOAP APIs, secure transfer protocols and service-account authentication.
Experience with mainframe data sources (DB2/z/OS), JCL batch outputs, COBOL-based systems or fixed-width flat files.
Familiarity with GCP/BigQuery, cloud data pipelines or insurance-sector data platforms.
NOTES ON MUST HAVES:
MUST-data integration, ETL or enterprise data engineering experience preferred.
MUST- Strong hands-on Informatica PowerCenter mapping, workflow and session development, deployment and troubleshooting.
MUST- Advanced Oracle and Microsoft SQL Server SQL development and performance tuning.
MUST- AI tools like Claude, Cursor or Copilot.
MUST- Experience integrating identity and access data with SailPoint or a similar IAM/identity governance platform.
MUST- Senior enough with ability communicate and work without direct supervision
MUST- Experience working with offshore team
- Blend of skills and can think on feet, have analysis conversations (format for data to go into Identity IIQ)
- Ability to do reverse engineering
- Will use Claude for analysis, develop queries and code but not push to production
NOTES ON THE PROJECT:
"We're upgrading our internal security infrastructure by integrating our applications with Identity IQ. The core goal is to automate access management ensuring employees have the exact permissions they need as they join the company, change roles, or leave. We're looking for someone to help build out these integrations and give our security team better visibility. "
Key Project Details:
The Technical Focus: Managing "CRUD " access (Create, Read, Update, Delete) so the security team has full visibility into privileged actions.
The Full Scope: Out of a portfolio of 108 applications, 34 have been identified as needing remediation to integrate with Identity IQ.
Immediate Phase 1: The team is starting by integrating a priority batch of 10 applications through direct queries to Identity IQ.
Business Impact: Preventing security gaps by ensuring access is instantly updated or revoked as personnel changes happen.