VENKATA REDDY NARU
Irving,TX
Summary
Experienced development professional knowledgeable about managing data extraction, transformation and loading. Hardworking team player with advanced skills in managing project design and implementation. Proficient in gathering requirements, reducing risk and developing consistent standards.
Effective at performance tuning and problem resolution by applying strong critical thinking, troubleshooting and analytical abilities.
Overview
4
4
years of professional experience
1
1
Certification
Work History
IICS DEVELOPER
Cognizant Technology Solutions, CTS
Hyderabad, Telangana
04.2023 - 07.2024
- Design, develop, and implement data integration solutions using Informatica Intelligent Cloud Services to meet business requirements.
- Analyze data requirements, perform data mapping, and develop data transformation logic to ensure accurate and efficient data integration processes.
- Design and develop workflows using IICS to automate data integration, data synchronization, and data quality processes.
- Conduct unit testing, system testing, and integration testing to validate data integration solutions and ensure adherence to business requirements.Debug and troubleshoot issues as needed.
- Written detailed documentation outlining system architecture, design decisions, and coding conventions used in the project.
ETL Informatica Developer
Cognizant Technology Solutions, CTS
CHENNAI, TN
01.2020 - 07.2023
- Developed ETL process to extract, transform and load data from Oracle database into the Data Warehouse using Informatica PowerCenter.
- Created mappings, sessions and workflows to move data from source systems to target systems using Informatica PowerCenter.
- Tested and validated the loaded data in the target system for accuracy and completeness.
- Optimized existing ETL processes by analyzing performance bottlenecks and implementing best practices in Informatica PowerCenter.
- Performed unit testing of mappings, sessions and workflows developed in Informatica PowerCenter.
- Documented all ETL processes created using Informatica PowerCenter.
- Provided production support for all ETL related issues involving Informatica PowerCenter.
- Designed complex transformations using various transformation objects like Filter,Router, Joiner, Lookup, Aggregator, Sorter in Informatica PowerCenter.
- Identified data quality issues and worked with business users to resolve them in a timely manner.
- Implemented error handling logic for failed ETL loads using error log tables in Oracle Database or flat files generated by Informatica PowerCenter.
- Developed shell scripts to schedule the execution of ETL jobs through Cron scheduler on UNIX platform.
- Migrated existing code base from lower version of informatica to higher version.
- Used Performance tuning techniques such as Partitioning technique and Bulk Loader options available within Transformations section while developing Mapping logic .
- Worked closely with Business Analysts and End Users for gathering requirements and providing technical solutions during design phase .
- Developed SCD Type 1,SCD Type2 and SCD type 3 mappings without errors and migrated them to QA and PROD environment.
Education
Master of Science - Business Analytics
Adelphi University
Garden City, NY05-2025
B.Tech - Computer Science And Engineering
Pace Institute Of Technology And Scineces
Ongole-inida05-2019
Skills
- Informatica PowerCenter
- IICS
- My Sql
- Teradata SQL Developer
- Oracle
- unix
- c
- Core Java
- Python
Certification
- Career Essentials in Generative AI by Microsoft and Linkedin
Timeline
IICS DEVELOPER
Cognizant Technology Solutions, CTS
04.2023 - 07.2024
ETL Informatica Developer
Cognizant Technology Solutions, CTS
01.2020 - 07.2023
Master of Science - Business Analytics
Adelphi University
B.Tech - Computer Science And Engineering
Pace Institute Of Technology And Scineces
Similar Profiles
ANKITA M GANKITA M G
Programmer Analyst at Cognizant Technology Solutions, CTSProgrammer Analyst at Cognizant Technology Solutions, CTS
Nitheena Helen Christy DhinakaranNitheena Helen Christy Dhinakaran
Sr Process Executive at Cognizant Technology Solutions, CTSSr Process Executive at Cognizant Technology Solutions, CTS
Sowmya ArumugamSowmya Arumugam
Associate Projects Lead at Cognizant Technology Solutions, CTSAssociate Projects Lead at Cognizant Technology Solutions, CTS
Nandakumar RameshNandakumar Ramesh
Senior System Executive at Cognizant Technology Solutions, CTSSenior System Executive at Cognizant Technology Solutions, CTS
Kevin Ricardo Freire OrtizKevin Ricardo Freire Ortiz
Clerk – Procurement at Hotel VINClerk – Procurement at Hotel VIN