Prakash Kumar

Data Engineer · Greater Bengaluru Area

Senior Data Engineer with 6+ years of experience designing and delivering production-grade data pipelines, ETL frameworks, and warehousing solutions in large-scale IT environments. At Tata Consultancy Services, I engineer robust PL/SQL-based data pipelines serving enterprise clients, ensuring high availability, data integrity, and optimized query performance across complex relational schemas. My work directly supports business-critical reporting and analytics workflows. Earlier at Cognizant, I contributed to end-to-end data engineering projects — from ingestion and transformation to warehousing — working across cross-functional teams to deliver scalable, maintainable data infrastructure. Core expertise: → Languages & Query: PL/SQL, Python, SQL → Big Data & Streaming: Py-Spark → Data Engineering: ETL/ELT pipelines, data warehousing, schema design, data modelling → Environments: Oracle DB, relational databases, enterprise IT systems I'm open to Senior Data Engineer opportunities where I can architect pipelines at scale and drive data quality across the organisation.

Experience

PL/SQL Developer

Tata Consultancy Services · May 2022 – Present

Not yet confirmed

• Senior Data Engineer / PL/SQL Developer
• Tata Consultancy Services · Full-time · May 2022 – Present · Pune, India
• Engineered and maintained enterprise-grade PL/SQL data pipelines processing high-volume transactional data, reducing query execution time and ensuring 99%+ data accuracy for downstream reporting systems.
• Designed and optimised complex stored procedures, functions, and triggers in Oracle DB to support ETL workflows, enabling reliable data movement across staging, transformation, and warehouse layers.
• Collaborated with business analysts and application teams to translate data requirements into scalable database schemas, data models, and pipeline logic for client-facing analytics platforms.
• Performed root-cause analysis on pipeline failures, implemented automated monitoring checkpoints, and cut incident resolution time by standardising error-handling frameworks across the data layer.

Data Engineer

Tata Consultancy Services · May 2022 – Present

Not yet confirmed

• Data Engineer with migration work : Worked on migration of Oracle PL-SQL based application to Azure cloud.
• Databricks Developer: Migrated all PG-SQL components to databricks and created ETL pipelines and databricks jobs.

Programming Analyst

Cognizant · Oct 2019 – May 2022

Not yet confirmed

• Data Engineer (Programming Analyst)
• Cognizant · Full-time · Jan 2021 – May 2022 · Bengaluru, India
• Built and maintained ETL pipelines for data ingestion, cleansing, and transformation across relational database systems, ensuring consistent data availability for analytics and reporting teams.
• Wrote optimised SQL and PL/SQL scripts to extract, validate, and load structured data into data warehouse targets, meeting SLA requirements for batch processing cycles.
• Worked within Agile delivery teams to identify data quality issues early in the pipeline lifecycle, reducing downstream defects and improving overall data reliability.
• Contributed to the design and development of data ingestion frameworks using SQL-based transformation logic, supporting structured data flow from source systems to centralised repositories.
• Assisted in data modelling exercises and schema design to support analytical use cases, improving query performance and enabling scalable data access patterns for reporting tools.
• Gained hands-on experience with ETL processes, database performance tuning, and end-to-end data pipeline delivery within enterprise IT delivery environments.

SQL Developer

Cognizant · Oct 2019 – May 2022

Not yet confirmed

• Programmer Analyst: Create database objects & batch creation in Core Loan applications System.
• Oracle development: Create database objects & batch creation in BCRM applications.

PL/SQL Developer

Cognizant · Oct 2019 – May 2022

Not yet confirmed

• Engineered complete Oracle object suite (stored procedures, packages, triggers, functions, indexes, views, materialised views) powering Core Loan Banking and BCRM applications serving thousands of daily users.
• Automated high-volume data ingestion using SQL*Loader and shell scripts to load, validate, and transform flat-file data into partitioned Oracle master tables — eliminating manual data entry and reducing load errors.
• Delivered business-critical regulatory changes with zero downtime, including COVID-19 Moratorium enhancements directly impacting loan disbursement workflows — completed on tight regulatory deadlines.
• Owned automated reporting infrastructure generating Daily, Weekly, Monthly, and Yearly reports for customer data applications via Autosys-scheduled batch jobs, sustaining defined SLAs with no missed cycles.
• Executed Oracle 11g → 19c database upgrade, validating PL/SQL object compatibility, package integrity, and Autosys job stability post-migration with no production regressions.
• Maintained zero production data-integrity incidents by performing ETL validation, code reviews, and documentation across staging, transformation, and reporting layers throughout the engagement.