Shanmugapriyan P.

Key Skills

Software

Micro1

Mercor

Top Subject Matter

No subject matter listed

Top Data Types

Image

Document

Computer Code Programming

Top Task Types

Object Detection

Text Generation

Function Calling

Data Collection

Computer Programming/Coding

Freelancer Overview

• Data Engineer with 7.5+ years of experience in Oracle PL/SQL, ETL pipeline development, and big data systems within banking and financial domains. • Hands-on experience building and optimizing data pipelines handling millions of records, with a strong focus on performance tuning, data validation, and production support (L2/L3). • Worked on IFRS9 (ECL, PD/LGD), ALM, and regulatory reporting systems using Moody’s Analytics, RFO, and CreditLens platforms in production environments. • Known for resolving production issues, improving ETL performance, and ensuring data accuracy across systems. • Experience using Generative AI (GenAI) and OpenAI/ChatGPT for intelligent ETL automation, SQL optimization and data validation. TECHNICAL SKILLS: Programming & Databases • Oracle SQL, PL/SQL (procedures, packages, performance tuning) • Python (Pandas, NumPy for data processing and validation) Big Data & Distributed Processing • Hive, Hadoop, PySpark, Spark SQL Data Engineering & ETL • End-to-end pipeline development, data transformation, data validation • Tools: Dataiku, Paxata, Informatica AI & Intelligent Automation • Generative AI (GenAI) • OpenAI / ChatGPT • Intelligent ETL Automation Performance Optimization • Query tuning, indexing, partitioning • Bulk processing using Bulk Collect and FORALL Workflow & Tools • Autosys, Control-M, Unix Shell Scripting • GitHub, SVN, JIRA Domain Knowledge • IFRS9 (ECL, PD/LGD), Credit Risk, ALM • Moody’s Analytics, RFO, CreditLens