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
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 - ,