Rahul Kumar Singh
Summary
Dynamic Integration Consultant with 11+ years of experience in retail, specializing in enterprise application and data integration. Led the implementation of advanced ETL processes, enhancing system efficiency and streamlining data flow. Proven ability to deliver high-impact solutions that significantly improve business reporting by combining deep technical expertise with strong team collaboration.
Overview
11
11
years of professional experience
Work History
Developer
Tata Consultancy Services Limited
10.2021 - Current
- Conducted a thorough analysis of over 4000+ interfaces slated for migration, identifying dependencies, potential challenges, and optimizing the migration design and plan.
- Led the successful migration of 4000+ interfaces from an on-premises environment to the Azure cloud, ensuring minimal disruption to ongoing operations.
- Implemented an optimized solution to onboard 26 billion records daily from diverse enterprise endpoints (HANA, Oracle, GCP, SAP) into a SaaS platform for retail order generation, leveraging integrations with ADF, AzCopy, and Informatica.
- Implemented impact analysis on requirements collected from stakeholders, identifying potential risks and devising mitigation strategies to ensure a smooth migration process.
- Prepared detailed High/Low level design documents, adhering to standard procedures and specifications, providing a comprehensive blueprint for the migration process.
- Developed integration components by providing various data integration solutions to generate reports in various databases including SAP Hana, Oracle and Teradata
- Ensured 100% data fidelity during the migration of nearly 400 Powercenter interfaces to Informatica Cloud using CDI-PC and Azure Data Factory, while simultaneously reducing data processing time by 20%
- Collaborated closely with stakeholders from various Business Insights Teams in workshops and meetings to comprehensively understand and document project requirements.
- Spearheaded a Proof of Concept (POC) to assess the performance of the new Azure cloud infrastructure, ensuring its suitability for the migration project.
- Built and launched integration workflows for more than 20 enterprise applications, tackling the challenges of integrating complex, heterogeneous database systems.
Technical Lead
Tata Consultancy Services Limited
10.2018 - 10.2021
- Oversee day-to-day integration BAU operations, ensuring the stability and performance of data integration processes.
- Monitor system health, troubleshoot issues, and implement corrective actions to minimize downtime and disruptions.
- Serve as the point of contact for incident resolution related to Informatica systems.
- Lead the investigation and resolution of incidents, collaborating with relevant teams to address issues promptly.
- Conduct regular performance assessments of Informatica environments to identify bottlenecks and areas for improvement.
- Implement optimization strategies to enhance the efficiency and speed of data integration processes.
- Evaluate system capacity and plan for scalability to accommodate growing data volumes and evolving business needs.
- Implement and manage changes to Informatica configurations, ensuring proper testing and documentation.
- Work closely with business stakeholders to ensure data availability as per Service Level Agreements (SLA).
- Ensure Informatica environments comply with security policies and regulatory requirements.
- Implement and monitor access controls, encryption, and other security measures to safeguard sensitive data.
- Lead and manage an L3 team of Informatica administrators and support executives, ensuring effective collaboration and coordination.
- Provide guidance, mentorship, and support to team members, fostering a culture of continuous improvement.
Enterprise Datawarehouse Support
Tata Consultancy Services Limited
06.2014 - 10.2018
- Worked as a support executive in Enterprise data warehouse team.
- Ensure timely availability of data for reports, meeting SLAs and user expectations.
- Collaborate with upstream teams to prevent recurrence and ensure seamless data flow.
- Investigate and rectify batch job failures caused by incorrect data.
- Identify and implement changes to fix recurring data and performance issues
- Analyze and address data issues reported by end-users, providing prompt and accurate responses.
- Collaborate with users to understand reporting requirements and troubleshoot concerns.
- Create accurate and relevant reports, ensuring timely delivery to users.
Education
Bachelor of Science - Computer Applications
Ranchi University
Ranchi, India06-2013
Skills
- Skill: Informatica Powercenter, Informatica Cloud, Shell script, SQL, CA Automic, CDI-PC, Azure Data Factory(ADF)
- Tools Used: ServiceNow, GIT, UC4, Jira, Confluence, Azure Devops
Accomplishments
- Pioneered Cloud Migration :- Migrated 400 interfaces to Informatica cloud, cutting data processing time by 20%
- Migrated 4000+ interfaces from an on-prem Informatica cloud secure agent to Azure based secure agent
- Implemented solution for onboarding 26 billion rows on a daily basis using a range of integration tools.
Timeline
Developer
Tata Consultancy Services Limited
10.2021 - Current
Technical Lead
Tata Consultancy Services Limited
10.2018 - 10.2021
Enterprise Datawarehouse Support
Tata Consultancy Services Limited
06.2014 - 10.2018
Bachelor of Science - Computer Applications
Ranchi University
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Arun PandeyArun Pandey
Head of Digital Innovation, Manufacturing Business at Tata Consultancy Services LimitedHead of Digital Innovation, Manufacturing Business at Tata Consultancy Services Limited
Bhuvana RamamurthyBhuvana Ramamurthy
Project Manager and Scrum Manager(AUS Airline) at Tata Consultancy Services LimitedProject Manager and Scrum Manager(AUS Airline) at Tata Consultancy Services Limited
Aparajita GhoshAparajita Ghosh
SENIOR DATA & BI ANALYST at Tata Consultancy Services LimitedSENIOR DATA & BI ANALYST at Tata Consultancy Services Limited
Ross HolmesRoss Holmes
Developer at DYDX DigitalDeveloper at DYDX Digital