ETL Lead

Dallas, TX, US • Posted 9 hours ago • Updated 9 hours ago
Contract W2
Contract Independent
6 Months
No Travel Required
On-site
Depends on Experience
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Apache Kafka
  • BMC Control-M
  • Auditing
  • Database
  • Code Review
  • Data Processing
  • Data Quality
  • Data Migration
  • Optimization
  • Profit And Loss
  • Extract, Transform, Load
  • Root Cause Analysis
  • Informatica PowerCenter
  • Oracle
  • Migration
  • Technical Drafting
  • SQL
  • Recovery
  • PL/SQL
  • Mainframe
  • Streaming
  • Stored Procedures

Summary

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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: RTX1d1245
  • Position Id: 9142610
  • Posted 9 hours ago
Contact the job poster
AD

Akhil Dasari

Recruiter @ ITSYNTAX INC

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.