Summary
Overview
Work History
Education
Skills
Certification
Websites
Timeline
Generic

Pesara Rajkumar Reddy

Hyderabad

Summary

Experienced ETL Informatica Developer with 11+ years in Requirement Analysis, Development, Testing, Support, and Maintenance of Data Warehousing/Integration and Migration projects in Financial, Insurance, and Retail sectors. Ready for Principal Consultant role, skilled in strategic solutions and project management. Known for collaborative approach, tangible results, stakeholder engagement, and change management expertise. Proactive and adaptable mindset for success in varied project settings.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Principal Consultant -IICS/CDI, CAI,B2B) Developer

Huron Consulting Group
01.2021 - Current
  • Collaborated with business partners and technology teams to define the scope and requirements for technical implementations.
  • Led projects and served as an escalation point, mentoring and guiding junior and less experienced developers.
  • Configured new partners on the IICS B2B platform, delivering end-to-end development solutions using CDI/CAI aligned with partner requirements.
  • Developed B2B solutions handling transactions in X12 and EDIFACT formats, utilizing AS2, VAN, and SFTP connectivity, and performing conversions to/from SAP IDOC file formats.
  • Managed code migration and deployment across Development, QA, and Production environments.
  • Designed and implemented developer transformations including Mapplets, Xmap DP, and Hierarchy Parser for complex data processing.
  • Created CDC mappings to synchronize data from multiple SQL Server sources into Snowflake databases.
  • Configured CDC log-based settings on SQL Server to enable efficient Change Data Capture implementations.
  • Executed CDI and CAI workflows to transfer data from SharePoint Online to SQL Server and Transcard applications.
  • Utilized IICS CDI components such as Task Flows, Synchronization and Replication Tasks, Mappings, Mapplets, and diverse connections (Relational, SAP IDOC, FlatFile, SharePoint Online).
  • Applied various transformations including Source, Target, Expressions, Lookups, Hierarchy, Sorter, Filter, Router, Transaction Control, and Mapplets to optimize data integration processes.

Senior Software Engineer

Ness Technologies Pvt Ltd (FTI-ECS)
01.2017 - 01.2019
  • Utilized a wide range of cloud transformations including Aggregator, Expression, Filter, Joiner, Connected and Unconnected Lookup, Router, Sequence Generator, Sorter, and Union to build efficient data workflows.
  • Performed Informatica performance tuning by identifying and resolving bottlenecks across sources, targets, mappings, and sessions to optimize overall system efficiency.
  • Designed and implemented Data Integration Hub (DIH) solutions using Informatica DIH tool to centralize and streamline data distribution.
  • Configured Topics, Publications, and Subscriptions within the DIH console to facilitate seamless data publishing and subscription workflows.
  • Collaborated closely with business stakeholders to ensure high-quality, accurate data delivery within the Enterprise Warehouse (EW) for reliable reporting.
  • Prepared detailed Change Request documents to track production changes, securing necessary approvals before deploying code to production environments.

Associate Consultant

Capgemini Technology Service Ltd (CAN-WCEDI, RnA)
01.2014 - 01.2017
  • Managed end-to-end production support activities, including 24/7 monitoring, incident resolution, user ticket handling, and on-call support to ensure uninterrupted ETL operations.
  • Designed and developed complex Informatica PowerCenter mappings implementing Slowly Changing Dimensions (SCD) Type 1 and Type 2 for accurate dimension data loading and historical data management.
  • Followed Agile development methodologies, collaborating closely with cross-functional technology teams to accelerate deliverables and maintain seamless project workflows.
  • Performed detailed optimization and troubleshooting of ETL workflows in PowerCenter to enhance performance, reduce runtime, and ensure data accuracy.
  • Configured and integrated IBM Infosphere CDC for real-time data replication from Claims source systems to target databases, supporting critical business processes.
  • Analyzed business requirements to design, develop, and validate PowerCenter mappings in alignment with requirement documents; regularly updated progress and status to team leads and stakeholders.
  • Composed clear, concise technical communication for business users to bridge understanding gaps, provide project updates, and coordinate meetings effectively.
  • Directly involved in the technical build-out, enhancement, and support of query tools, relational databases, and ETL processes using Informatica PowerCenter.
  • Mentored and coached junior developers and support staff by conducting knowledge transfers (KT), resolving break-fix issues, and providing continuous technical guidance to ensure team readiness and effectiveness.

Education

MTech - CSE

Osmania University
01.2021

BTech - CSE

JNTU
01.2013

Skills

  • IICS Integration (CAI,CDI,B2B)
  • Informatica PowerCenter expertise (9x,10x)
  • Python Programming
  • SQL-Oracle, SQL -Server, Snowflake
  • Unix
  • PLSQL

Certification

  • Oracle SQL Certified Developer
  • Certified ITIL Foundation.
  • Informatica PowerCenter Certified Developer
  • IICS Foundation Certified Developer.
  • INS-21 Certified Developer

Timeline

Principal Consultant -IICS/CDI, CAI,B2B) Developer

Huron Consulting Group
01.2021 - Current

Senior Software Engineer

Ness Technologies Pvt Ltd (FTI-ECS)
01.2017 - 01.2019

Associate Consultant

Capgemini Technology Service Ltd (CAN-WCEDI, RnA)
01.2014 - 01.2017

BTech - CSE

JNTU

MTech - CSE

Osmania University

Similar Profiles

CREATE PROFILE
Pesara Rajkumar Reddy