AI-Enabled Senior Data Engineer | ETL - Epsilon - Remote
(2022-06)
Project: Auto Cadence (Marketing Automation Platform) Auto Cadence is a flagship marketing automation platform that supports over 70% of U.S. auto dealerships, including high-end brands such as Rolls Royce, BMW, and Volvo. It is responsible for orchestrating omnichannel customer engagement campaigns, including Email, SMS, Phone, Digital, and Letter communications.
- Designed, developed, and maintained high-performance data pipelines supporting omnichannel marketing campaigns (Email, SMS, Digital, Letter)
- Experienced in AI-assisted automation using GitHub Copilot, Amazon Q, and Cursor AI for intelligent code generation, debugging, and SQL optimization
- Built and optimized ETL workflows using Informatica PowerCenter for data ingestion, transformation, and loading from multiple source systems
- Implemented AI-assisted automation techniques to accelerate PL/SQL development, reduce manual coding effort, and improve engineering productivity
- Designed and maintained real-time data pipelines supporting omnichannel customer engagement campaigns across Email, SMS, Digital, and Letter channels
- Developed Python/Pandas-based data ingestion frameworks to process, validate, and load large-scale datasets from multiple source systems into Oracle environments
- Automated repetitive PL/SQL development and query-writing tasks using GitHub Copilot, improving development efficiency and reducing turnaround time
- Supported predictive analytics initiatives by preparing high-quality transformed datasets for downstream reporting and analytics teams
- Worked on cloud-native data processing solutions in AWS environments to improve scalability, reliability, and operational efficiency of enterprise data workflows
- Leveraged Amazon Q and Cursor AI for code suggestions, debugging, and SQL optimization
- Developed and maintained complex PL/SQL packages, procedures, functions, triggers, and database objects
- Implemented bulk collect, partitioning, and parallel processing techniques for large datasets
- Designed and maintained data extraction and transformation processes (ETL pipelines) across enterprise systems
- Scheduled and monitored workflows using Control-M and Autosys
- Provided 24/7 production support, troubleshooting batch failures and resolving performance issues
- Collaborated with cross-functional teams to gather requirements and deliver scalable data solutions
- Optimized the performance of complex SQL queries in Oracle reports as well as queries from the queries
- Optimized Oracle SQL queries and PL/SQL packages, reducing batch execution time by 45%, HINTS, DBMS Profiler for performance tuning of SQL, PL/SQL queries
- Supported code push preparing change for new version release of application support to eod jobs, also involve in Troubleshooting, fixed, and implemented bug fixes and enhancements within tight deadlines
Oracle PL/SQL Developer - Bank of America - Charlotte, NC
(2021-08 - 2022-05)
Project: Entity Scanning Solution (ESS) & Global Utility for Enterprise Screening (GUES) Entity Scanning Solution (ESS) was Bank of America's centralized platform for OFAC screening using Oracle Watchlist Screening (OWS). The project focused on scanning customer and business entity data against government and internal watchlists to identify high-risk entities and ensure regulatory compliance.
- Worked on Analyze, Design, Development, and testing of the application
- Worked as an Oracle Developer to provide basic support to the client for Database and Banking Application. Also, provided support for primary level debugging (application problems)
- Performed key role in migrating Oracle 11g to Exadata Databases
- Worked very closely with front end Java developers, and gathered User Requirement for Sanctions Search Portal
- Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages
- Developed complex mappings using Informatica Power Center Designer to transform and load data
- Developed several Mappings and Mapplets using corresponding Sources, Targets and Transformations
- Involved in Business analysis and requirements gathering
- Designed scalable ETL architecture using Informatica PowerCenter and Oracle PL/SQL to support enterprise-wide data integration and high-volume batch processing
- Assisted in creating fact and dimension table implementation in Star Schema model based on requirements
- Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Developer
- Extensively used various types of transformations such as Expression, Joiner, Update strategy, Aggregator, Filter, and Lookup
- Developed metadata-driven ETL processes to standardize data transformation logic and improve maintainability of enterprise data workflows
- Transferred data from flat files into the database tables using SQL* Loader
- Converted all Oracle ETL Packages to Informatica Mappings and created workflows/sessions
- Supported code push preparing change for new version release of application support to eod jobs, also involve in Troubleshooting, fixed, and implemented bug fixes and enhancements within tight deadlines
- Create/maintain and modify complex database triggers and data migration scripts
Senior Oracle PL/SQL Developer - Fidelity Investments - Jersey City, NJ
(2020-05 - 2021-08)
Project: PB Optimize - Enterprise analytics platform designed for portfolio optimization, hedge fund performance analysis, and financial reporting.
- Worked on analysis, design, development, testing, and implementation of the portfolio optimization application
- Designed and developed data processing and analytics solutions using PL/SQL for large-scale financial datasets
- Integrated Informatica ETL workflows to extract, transform, and load data from multiple financial and market data sources
- Supported enterprise analytics and predictive analytics initiatives using transformed financial datasets and optimized ETL workflows
- Developed Python scripts to automate data ingestion, validation, and transformation processes
- Transferred data from flat files into Oracle tables using SQL*Loader and control files
- Developed and maintained PL/SQL packages, procedures, functions, triggers, and database objects
- Extensively used implicit, explicit, and REF cursors, along with collections, records, and bulk processing techniques
- Designed Power BI financial dashboards for portfolio optimization analysis, fund performance track
