Summary
Overview
Work History
Education
Skills
Timeline

Swaroopa Palivela

Visakhapatnam

Summary

Dynamic professional with 5+ years experience in Data warehousing using Informatica Power Centre 9.X/ 10.X.. Adept in designing and building data pipelines. Developed complex mappings in IICS. Managed partnership with Data Integration Hubs. Designed and executed Data Quality Audit/ Assessment.

Overview

3
3
years of professional experience

Work History

Data Engineer

Accenture
12.2019 - 03.2023
  • · Worked on Data Migration from PowerCenter Informatica cloud (IICS).
  • · Created and tested simple/complex mapping task and task flows and debugging issues.
  • · Handling Data Integration Service in IICS.
  • · End to end testing with data validation.
  • · Analyzing and collecting any data mismatch between PowerCenter and IICS using SQL Teradata.
  • · Following JIRA Approach.
  • · Developed complex mappings and Development Task Flows in IICS as part of the conversion project.
  • · Design and Developed complex Informatica Mappings, reusable Mapplets and Transformations (source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner, XML) for different types of tests in research studies on a daily and monthly basis.
  • · Performed installation of Informatica Power Exchange.
  • · Designed and Developed SQL, PL/SQL, and UNIX shell scripting and scheduled jobs using Autosys.
  • · Documented flowcharts for the ETL (Extract Transform and Load) flow of data using Microsoft Visio.
  • · Managed the partnership with Data Integration Hubs around data modeling, data mappings, data validation, hierarchy management and overall security. Provided continuous enhancement and review of MDM matching rules, data quality and validation processes.
  • Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
  • Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
  • Collaborated with cross-functional teams for seamless integration of data sources into the company''s data ecosystem.
  • Automated routine tasks using Python scripts, increasing team productivity and reducing manual errors.

Education

Pydah Kaushik College of Engineering , Vishakapatnam
05.2019

Skills

  • Performance Tuning
  • NoSQL Databases
  • API Development
  • Data Migration
  • Data Modeling
  • Data Warehousing
  • Scripting Languages
  • SQL Expertise
  • SQL and Databases
  • Data Mining
  • Teamwork and Collaboration
  • Organizational Skills

Timeline

Data Engineer - Accenture
12.2019 - 03.2023
Pydah Kaushik College of Engineering - ,
Swaroopa Palivela