Summary
Overview
Work History
Education
Skills
Activities
Accomplishments
Certification
Languages
Timeline
Generic

PRATHYUSHA SINGAVARAPU

Hyderabad

Summary

Resourceful ETL Developer with 12+ years experience .Known for high productivity and efficient task completion. Specialize in data warehousing, SQL programming, and data integration techniques. Excel in problem-solving, teamwork, and effective communication to deliver robust ETL solutions. Committed to improving data accessibility and quality through innovative approaches and technical skills.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Technical Lead

Wipro technologies
Hyderabad
08.2021 - Current
  • Created and implemented ETL logics in Informatica Power Center and IICS for seamless data loading into Data warehouse tables
  • Involved in designing several project modules from the ground up.
  • Engaged in unit testing task flows for IICS subsequent to the transition from Informatica PowerCenter
  • Developed Unix scripts and enhanced Python and Batch scripts
  • Utilized Git Hub for checking in objects for Migrations.
  • Utilized Autosys tool for scheduling activities.
  • Implemented UAT deployments via Ansible templates
  • Enhanced work efficiency by actively participating in Agile methodology involving regular progress updates, backlog refinement sessions, product demonstrations and retrospectives
  • Conducted evaluations for Level 1 ETL applicants.

ETL Engineer

Cognizant technology SOLUTIONS
Hyderabad
11.2018 - 07.2021
  • Generated ABAP code in Informatica Power Center to fetch data from SAP BW source application
  • Utilized Automic Scheduling tool to effectively manage scheduling of Informatica jobs and UNIX scripts
  • Troubleshooted and resolved production issues
  • Ensured comprehensive understanding of enhancement requests through effective requirements gathering and analysis
  • Developed and enhanced code
  • Executing test runs and presenting test results for client verification
  • Prepared Change Request documents.
  • Ensured accuracy and completeness of updated Functional and Technical Design Documents
  • Created Pl/SQL procedures to integrate efficient LOT logic into Supply Chain Management operations.
  • Created a unix script to assess changes in data files between PRE and POST states in Kinaxis RR
  • Streamlined operations through automated processes.

ETL Engineer

Cognizant technology SOLUTIONS
Hyderabad
03.2016 - 04.2018
  • Worked on Informatica Data Quality and Informatica Analyst tool to enhance data accuracy.
  • Developed Physical data objects, mappings, workflows and applications in Informatica Developer.
  • Implemented manual PRODUCTION loads by leveraging human task creation in Informatica Developer
  • Implemented MDM logic in Oracle tables by dynamically fetching specific logic for each component through Dynamic SQL transformation in Informatica Developer
  • Managed Informatica Analyst tool to maintain and update reference files
  • Ensured data availability in Informatica analyst by verifying post loads and promptly updating Business Analyst
  • Collaborated with Client to establish and refine new business requirements and enhancements
  • Prepared functional and technical documents through continuous co-ordination with OQM’s on approval and signoff.

INFORMATICA SUPPORT ANALYST

GENPACT INDIA
Hyderabad
01.2013 - 01.2016
  • Monitored and ensured successful loading of data into warehouse tables for over 100 jobs
  • Resolved multiple production data issues by providing practical solutions to enhance customer satisfaction
  • Resolved data issues by analyzing multiple complex mappings
  • Provided technical enhancement code details to the enhancement team
  • Resolved Unix script issues
  • Executed crucial month end activities to ensure the accuracy and validity of monthly data.
  • Bounced informatica server by shutting down and starting up all informatica services in UNIX box during maintenance
  • Aligned services to respective nodes through Admin console
  • Managed production live issues by coordinating with multiple teams.

INFORMATICA DEVELOPER

GENPACT INDIA
Hyderabad
04.2012 - 01.2013
  • Created mappings to efficiently load data from multiple sources to the corresponding DWH tables
  • Implemented SCD type 2 logic in data integration processes
  • Developed logic for loading dimensions and fact tables through Informatica PowerCenter transformations.
  • Developed efficient scripts for seamless file transfer using SFTP
  • Constructed Oracle database objects to facilitate Data warehouse development.

OBIEE DEVELOPER

GENPACT INDIA
Hyderabad
08.2011 - 05.2012
  • Developed Analysis and reports based on Customer requirements
  • Created and presented analysis in dashboards to facilitate data-driven decision-making.
  • Designed and developed diverse visual elements, including pie charts, graphs, prompts, filters, and variables for multiple metrics.
  • Configured iBots utilizing Delivers and Job Manager to schedule and distribute Analytics content via email to business users.
  • Utilized different features such as Drill-Down, Pivot Table, Chart, Column Selector, Tabular with global and local Filters in creating the Reports / Dashboards.

Education

Btech - Computer Science And Engineering

Viswananth Institute of Technology And Management
Visakhapatnam, AP
01.2010

Skills

  • ETL Tools-Informatica Power center,IICS
  • Databases -Oracle,SQLSERVER
  • Scripting Languages-Unix Shell scripting,Python
  • Reporting Tool-OBIEE
  • Scheduling tool-Automatic Scheduler,Autosys
  • Ticketing tools-Service Now,BMC remedy

Activities

  • Completed Informatica Data Engineer Foundation Course in April 2024 and acquired Certification.
  • Completed Azure DP- 203 External Certification in Dec 2023
  • Completed External Certification on Microsoft Azure Data Fundamentals in Dec 2020.
  • Participated in Cognizant internal AI data summit and gained Internal certification on Machine Learning.

Accomplishments

  • Received Innovative Team award in Wipro.

Certification

  • Completed Informatica Data Engineer Foundation Course in April 2024 and acquired Certification.
  • Completed Azure DP- 203 External Certification in Dec 2023
  • Completed External Certification on Microsoft Azure Data Fundamentals in Dec 2020.
  • Being a passionate learner, participated in Cognizant internal AI data summit and gained Internal certification on Machine Learning.

Languages

English
First Language

Timeline

Technical Lead

Wipro technologies
08.2021 - Current

ETL Engineer

Cognizant technology SOLUTIONS
11.2018 - 07.2021

ETL Engineer

Cognizant technology SOLUTIONS
03.2016 - 04.2018

INFORMATICA SUPPORT ANALYST

GENPACT INDIA
01.2013 - 01.2016

INFORMATICA DEVELOPER

GENPACT INDIA
04.2012 - 01.2013

OBIEE DEVELOPER

GENPACT INDIA
08.2011 - 05.2012

Btech - Computer Science And Engineering

Viswananth Institute of Technology And Management

Similar Profiles

CREATE PROFILE
PRATHYUSHA SINGAVARAPU