Quick overview
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
- ID
Sr AWS Data Engineer (with ETL, Python, AWS Glue, Lambda, Node.js & Microservices exp)Recently posted
Info Dinamica Inc · Malvern, PA · On-site · Posted 16 Nov 2026 🇺🇸
DynamoDBMicroservicesOracle+18TechnologySalary not listed - PG

Data Engineer – Databricks, PySpark, Cloud | Hybrid - 71701Recently posted
PRIMUS Global Services Inc. · Princeton, NJ · Hybrid · Posted 17 Nov 2026 🇺🇸
SQLScalaApache Spark+4TechnologySalary not listed - PH

Data EngineerRecently posted
Photon · Sunnyvale, CA · Hybrid · Posted 17 Nov 2026 🇺🇸
SQLAWSETL+6TechnologySalary not listed - GE

SQL Server DBARecently posted
Genesis10 · Charlotte, NC · Hybrid · Posted 17 Nov 2026 🇺🇸
SQLShellMicrosoft Office+3Technology$53 - $61/hr - NT
Oracle DBA with Security ClearanceRecently posted
NorthHill Technology Resources · Fairfax, VA · Hybrid · Posted 17 Nov 2026 🇺🇸
MariaDBMongoDBOracle+6TechnologySalary not listed - VI

Sr. Data EngineerRecently posted
Visa · Foster City, California · Hybrid · Posted 17 Nov 2026 🇺🇸
SQLScalaApache Spark+14Technology$131.9k - $204k/yr - VI

Staff Data EngineerRecently posted
Visa · Foster City, California · Hybrid · Posted 17 Nov 2026 🇺🇸
SQLScalaApache Spark+13Technology$156.8k - $251.1k/yr - FA

Systems Engineer (Data Flow/NiFi) Level 2Recently posted Auto Apply
Fantom Corporation · Fort Meade · On-site · Posted 17 Nov 2026 🇺🇸
ApacheComplianceComputer Vision+5TechnologySalary not listed - LS

Senior Database EngineerRecently posted
London Stock Exchange Group · St Louis, MO · Hybrid · Posted 17 Nov 2026 🇺🇸
OracleShellAWS+5TechnologySalary not listed - KT

Senior Data EngineerRecently posted
Kforce Technology Staffing · Atlanta, GA · Hybrid · Posted 17 Nov 2026 🇺🇸
SQLETLAirflow+5TechnologySalary not listed - QT

Data Engineer LeadRecently posted
QUANTUM TECHNOLOGIES LLC · United States · Hybrid · Posted 17 Nov 2026 🇺🇸
DockerSQLGit+12Technology$83/hr - TE
Data Engineer - San Antonio, TX, Dallas, TX, Austin, TX, Houston, TXRecently posted
TechniPros, LLC · San Antonio, TX · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLApache SparkETL+2TechnologySalary not listed
