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