Description

Responsibilities

• 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 on target formats, required attributes, data quality rules, delta/full-load behavior, and reconciliation processes.
• 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.
• 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.
• Document end-to-end lineage, schedules, control mechanisms, mappings, and support procedures to enable repeatable delivery across application portfolios.

Qualifications

• Required
  • 6+ years of data integration, ETL, or enterprise data engineering experience.
  • 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 of AI tools such as Claude, Cursor, or Copilot.
• Preferred
  • 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

Key Skills

Education

Bachelor's degree