Back to Jobs
Recently postedOther

ETL Lead

ITSYNTAX INCDallas, TX🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationDallas, TX, United States
OraclePL/SQLSQLETLApacheAuditingKafkaReconciliationScheduling

Job description

ETL Lead and Data Modernization professional specializing in the design and delivery of enterprise-scale data migration and integration solutions, with strong expertise in Informatica PowerCenter, Oracle, PL/SQL, Mainframe data processing, and Kafka.

Lead end-to-end modernization initiatives involving migration of legacy Mainframe data into modern Oracle data models, implementing File-to-Database, Database-to-Database, batch, and streaming integration patterns.

Strong hands-on expertise in Oracle SQL and PL/SQL, including development and optimization of complex SQL queries, stored procedures, packages, functions, cursors, bulk-processing routines, exception handling, and database-side transformation logic. Experienced in leveraging PL/SQL alongside Informatica PowerCenter for high-volume transformation, reconciliation, data-quality validation, and performance-critical processing.

Core Technical Profile

Area

Expertise

ETL / Integration

Informatica PowerCenter, Control-M for Job Scheduling

Database Development

Oracle SQL, PL/SQL

PL/SQL Development

Procedures, Packages, Functions, Cursors, Triggers, Bulk Processing

Modernization

Mainframe → Oracle

Integration Patterns

File-to-DB, DB-to-DB, Batch, Streaming

Streaming

Apache Kafka

Database

Oracle

Architecture

Source → Staging → Transformation → Target

Data Engineering

Mapping, Transformation, Data Quality, Error Handling

Reconciliation

Counts, Control Totals, Business Keys, Field-level Validation

Performance

SQL/PL/SQL Tuning, Partitioning, Parallelism, Bulk Loading

Reliability

Restartability, Recovery, Auditing, Operational Controls

Leadership

Architecture, Technical Design, Code Review, Delivery, RCA

Similar jobs