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.</li
