Tapas Mahato

Results-driven Oracle PL/SQL Developer with 4.7 years of experience in BFSI and financial data engineering, spanning payroll pipelines, transaction processing, and dispute workflows. Proven expertise in developing and optimizing complex PL/SQL packages, stored procedures, and bulk processing routines for high-volume financial data. Currently driving Oracle-to-Snowflake migration and Talend ETL integration at Cognizant.

Skilled in schema change management across DEV/SIT/UAT/PROD environments, cross-team DBA collaboration, and GoldenGate replication-aware DDL design. Strong communicator with full-SDLC ownership from requirement gathering through production support.

Senior PL/SQL Developer at Cognizant Technology Solutions (2024-12 – Present)

Develop and optimize PL/SQL packages, stored procedures, and functions supporting high-volume financial data processing for BFSI clients. Drive Oracle-to-Snowflake migration and manage schema change lifecycle across multiple environments. Collaborate with DBA teams on GoldenGate replication-aware DDL changes. Integrate Talend ETL pipelines with Snowflake for batch data ingestion.

• Develop and optimize PL/SQL packages, stored procedures, and functions supporting high-volume financial data processing for BFSI clients, ensuring sub-second execution on multi-million-row datasets.
• Drive Oracle-to-Snowflake migration — perform data validation, reconciliation, and SQL transformation rewrite, ensuring 100% parity between legacy Oracle and Snowflake reporting outputs.
• Manage schema change lifecycle across DEV / SIT / UAT / PROD environments; assess downstream impact on views, synonyms, and dependent procedures before every DDL deployment.
• Collaborate with DBA teams on GoldenGate replication-aware DDL changes, coordinating nullable column additions and replication lag mitigation strategies.
• Integrate Talend ETL pipelines with Snowflake for batch data ingestion; author Shell scripts to automate job monitoring, log management, and failure alerting.
• Work with Snowflake SQL for complex transformations, aggregations, and reporting logic; translate business rules from HLD/LLD into efficient query patterns.
• Own requirement gathering, UAT support, and production release coordination across cross-functional teams including Java developers and functional analysts.

PL/SQL Developer at Capgemini Technology Services India Limited (2021-06 – 2024-12)

Delivered end-to-end Oracle PL/SQL development across full SDLC. Developed complex database objects including stored procedures, functions, packages, and triggers. Implemented bulk collection patterns and performance optimization strategies. Designed and normalized logical and physical data models.

• Delivered end-to-end Oracle PL/SQL development across full SDLC — from analysis and design through testing, implementation, and post-production maintenance.
• Developed complex database objects: Stored Procedures, Functions, Packages, and Triggers using advanced SQL and PL/SQL constructs for enterprise clients.
• Implemented bulk collection patterns (FORALL / BULK COLLECT) to reduce context-switching and improve batch processing throughput by eliminating row-by-row operations.
• Built and maintained Table Functions, Materialized Views, Analytical Functions, and index strategies (B-Tree, Bitmap, Function-Based) for query performance optimization.
• Leveraged Dynamic SQL, Ref Cursors, External Tables, and Oracle-supplied packages (DBMS_SQL, UTL_FILE, DBMS_SCHEDULER) for flexible, reusable data processing solutions.
• Designed and normalized logical and physical data models; created tables, views, and constraint hierarchies aligned with 3NF design principles.
• Contributed to cross-functional dashboard development, ensuring data accuracy and timely delivery for business reporting in high-pressure, deadline-driven environments.

Bachelor of Technology in Electronics & Communication Engineering – Maulana Abul Kalam Azad University of Technology (MAKAUT) (2016-07 – 2020-07)