Kyasa Ravali
Informatica, IICS Developer
Hire this person
Send a job offer directly to this candidate
About
Having 10+ years of experience in IT industry with good understanding of data warehousing/ETL and data-modeling concepts (entity relationship, multi-dimensional) coupled with ETL Tool Informatica PowerCenter and IICS. Expert in development and integration of applications which includes developing components, conducting peer review, creating unit test plans, and performing unit testing. Successfully implemented various performance tuning techniques on sources, targets, mappings, and sessions in Informatica.
Experience
Lead Data Analyst - Quess corp
(2025-03)
Associate staff engineer - NAGARRO ENTERPRISE SERVICES Pvt. Ltd
(2019-04 - 2025-02)
Application Development Senior Analyst - Accenture Solutions Pvt. Ltd
(2014-01 - 2019-04)
Developer - Schneider Electric Digital Pvt Ltd.
(2025-03)
People Analytics HR systems project - Integrating the data with the Other systems and creating the Live Dashboards in OAC for Learning Domain
- Designed the data flow in ETL and develop the mappings in IICs with CAI & CDI
- Gathering the requirements from the PO and design the application
- Creating Dashboards in OAC for PRP reporting
- Supporting the Existing production jobs and Handling Production bugs
- Worked closely with the reporting users for report mismatches
Developer - Nagarro Enterprise services PVT LTD
(2022-07 - 2025-02)
FDW (Finance Data warehouse) project for MCKINSEY - Migrate the legacy RDW data to FDW system. Support and Enhancement of FDW (on prem) data and creating reporting views for HANA reporting. Worked on the employee payroll data.
- Designed the data flow in the new FDW system in informatica by checking the old RDW PL/SQL scripts
- Integrating the data from Third party Application using IICS CAI
- Creating calc views in SAP BAS which are used for HANA reporting
- Scheduling the informatica workflows in DAC
- Supporting the Existing production jobs and Handling Production bugs
- Debugging existing mappings /workflows in case of any errors in the reports
Developer - Nagarro Enterprise services PVT LTD
(2020-07 - 2021-05)
GDC (Global Data Consolidation) project for Sony - Consolidate the data from Different FMSCs and loaded data in Redshift using Informatica Cloud.
- To work on the new Enhancements like performance tuning and change requests
- Support the GDC phase-1 and Phase-2 projects
- Monitor the current ETL jobs and analyze the Production issues
- Working with different FSMCs on the data load discrepancies
- Handle all the support activities
Developer - Nagarro Enterprise services PVT LTD
(2019-04 - 2020-06)
SMART project for Sony - Provide a strategic Data Warehouse and Reporting solution for the SMART data and remove the load reporting has on the DB and system resource.
- Understanding the existing SMART Business existing reporting views
- Gathering the data from different source systems like SAP, Files, SQL Server
- Designed the ETL mappings based on the requirements
- Loading the data in Amazon S3 and Redshift for reporting purpose
- Involved in discussion in daily calls with client and onsite team as well
- Coordinated with client to change the requirement for the betterment of the whole process
- Resolved production issues raised by reporting team
- Handled the release with minimal issues
- Scheduled the jobs in control-M tool for support
- Handled production support and given permanent fix for recurring issues
Developer - Accenture Services PVT LTD
(2019-01 - 2019-03)
UCQ (Uniting Care Queensland) project - Migrate the Legacy data to D365 by revising architecture and building new code in Informatica Power center, DIH and IDQ based.
- Analyze the existing flow which is unix scripts and design the new Informatica Flow
- Writing the STTM document and test scripts
- Migrating the data from different Legacy systems to D365 using the Informatica Power center, DIH and IDQ by analyzing the data
Developer - Accenture Services PVT LTD
(2018-09 - 2018-12)
Finland Data Migration project for Adecco - Migrate data from different Legacy systems to Salesforce based on each country data.
- Migrating the data from different Legacy systems to Salesforce (Info) using the informatica cloud by analyzing the data
- Building the mappings in ICS to migrate the data
- Handled immunization process
Developer - Accenture Services PVT LTD
(2014-04 - 2018-08)
AMS ETL Support project for Honda - Manage Product sales, services and coordinating functions of Honda in North America including distribution, marketing and sales of Honda and Acura brand automobiles and Honda power sports products.
- Prepare Technical design document and implementing them as per functional requirement
- Lead the team from offshore in assigning the tasks and resolving the issues
- Implement ETL (Extract-Transform-Load) Code for new requirements and review the code changes
- Responsible for maintenance of proper quality standards in deliverables, version control, defect tracker, error log etc
- Involved in preparation of code deployment and run book documentation for support activities
- Support the ongoing operation issues and involved in project metrics and reporting
- Perform Batch Monitoring and Scheduling with the third-party scheduling tool ZENA
- Resolve the reporting issues raised by different application owners
Developer - Accenture Services PVT LTD
(2017-08 - 2018-02)
CRMS Application project for Honda - Customer Relation Management System for Honda and Acura divisions receiving complaints from customers regarding Motorcycle, power equipment and Automobile parts and services.
Education
Bachelors in Engineering - Electronics and Communication - Sri Padmavathi Mahila university (2009-01 - 2013-12)
Board of intermediate - M.P.C - Sri Chaitanya junior college (2007-01 - 2009-12)
Board of secondary education - New Shathavahana high school (2007-12)
