Ritesh Raj
LinkedIn: https://www.linkedin.com/in/ritesh-raj-2b2ba0113/
Email: riteshraj.mit@gmail.com Ph: +91-7892524031
Profile
Data Engineer with 5 years of experience in designing scalable solutions, developing custom
pipelines, and driving R&D projects, POCs, and Data Governance initiatives.
Experience
Data Engineering and Governance | Swiss Re, Bangalore | August-2022-Present
· End-to-End ETL Implementation: Designed and implemented a Java Spring Boot web application to
streamline metadata and systems data integration into Collibra DGC as part of a robust ETL process.
Leveraged SQL for data transformation and materialized views to optimize batch refresh processes,
boosting data discovery efficiency by 70%.
· API Development for Analytics Integration: Developed OAuth2-authenticated REST APIs to extract
datasets from Collibra DGC, enabling seamless analysis and reporting in the Palantir Foundry
Platform, driving actionable insights and operational efficiency.
· Data Governance and Metadata Management: Conducted in-depth analysis of data, metadata
landscapes, and architecture while aligning with stakeholder objectives to design and maintain a
comprehensive data catalog in Collibra DGC, ensuring adherence to data governance principles.
· Custom Workflow Development: Developed tailored Collibra workflows using Flowable BPMN,
leveraging core, workflow, catalog, and assessment APIs to automate operations like role and
relationship management, catalog updates, and metadata curation, enhancing user engagement and
governance efficiency.
· Performance Optimization: Built a Java-based bpmn compiler implementing XML SAX Parser to
extend Groovy functionality in Collibra workflows, improving logging clarity and reducing debugging
efforts by 90%, significantly enhancing workflow reliability and maintainability.
· Certified Workflow Engineer from Collibra (Certificate No. LP13365)
Data Engineer | TATA Consultancy Services, Mumbai | October-2018-June2022
· Data Integration and Warehousing: Extracted and processed data from diverse sources (JSON, TSV,
CSV, REST APIs) using Informatica, Java, and SQL, implementing SCD Type 2 logic to efficiently
warehouse datasets in Oracle DB.
· Liquidity Risk Analysis: Conducted analysis and validation of wholesale, retail banking, and High-
Quality Liquidity Asset data for Liquidity Coverage Ratio calculations under BASEL III norms.
Streamlined validation processes using Informatica’s Java transformations for accuracy and efficiency.
· End-to-End Pipeline Development: Built a secure, cost-effective data pipeline to extract sensitive
trading data from REST APIs, parse JSON responses, and encrypt using AES 256-bit encryption,
reducing operational costs by $1,000. Automated pipeline execution with Autosys and batch scripting
for seamless workflows.
· Data Cataloging: Cataloged 3rd-party and trading datasets from the Data Warehouse in Collibra,
enhancing data governance and discoverability.
Education
2014-08 - 2018-05 Bachelor of Technology: Civil Engineering | CGPA : 7.75/10
Manipal Institute of Technology - Manipal , Karnataka
2013-04 – 2014-04 12th | Science|79%
Jawahar Vidya mandir Shyamali
2011-04 – 2012-04 10th |CGPA-9.8/10
Jawahar Vidya mandir Shyamali
Skills and Tools
· Business Analysis and solutioning
· Programming languages: Java, C#, SQL, Python, Groovy
· Tools and software: MS office, Informatica Power center, Toad for Oracle, Collibra DGC
Achievements
· Selected as an Indian Navy officer with the Officer Rank of Sub-Lieutenant and was amongst the 36
selected candidates out of 10000 in India with selection ratio being <1% and cleared the Indian Navy
Entrance Test and SSB.
· Received multiple On-Spot Awards from Tata Consultancy Services for solutioning and resolving
critical errors.
Page 2
