Sr. Data Engineer
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+23 more
Job description
- 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.
Requirements
Application Programming Interface (API), Database Extract Transform and Load (ETL), Informatica, Microsoft SQL Server, Oracle Database, Identity Data Management, SQL (Structured Query Language), Problem Solving Skills, Communication Skills, Offshoring, We are seeking a Senior Data Engineer with deep Informatica PowerCenter, Oracle, and Microsoft SQL Server expertise to design and operate ETL workflows for identity and access management (IAM) data integrations. This is a contract role, 12+ months, fully remote. You will 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 platforms. Success requires strong SQL tuning, robust batch operations, hands-on source-system discovery, and production issue resolution. You must be senior enough to work independently and communicate effectively without direct supervision, and have experience collaborating with offshore teams., * 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.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦