Soundarya
Professional Summary:
- Having overall 5.6 years of experience and 3 years in the field of data warehousing, Informatica PC & Reltio MDM.(ETL)
- Diligent and Hardworking in Informatica Power Center, Oracle SQL and UNIX having experienced in analysis, design, development and maintenance of business applications in Data Warehousing environments.
- Strong hands-on Informatica Designer and configuring sessions/workflows using Workflow Manager and monitored jobs using workflow Monitor.
- Developed mappings in Informatica to Extract/load data from various sources/target using different transformations like Source Qualifier, Expression, Joiner, router, filter, rank, union, sequence generator and aggregate transformations.
- Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
- Proficiency in developing SQL with various databases like Oracle, SQL Server.
- Experienced in doing the process of extraction, transformation and loading data from multiple sources like OLTP systems into data marts using Informatica Power Centre.
- Good experience in working on Service Now, CSM (Ticketing Tools).
- Good experience in implementing Change Requests (CRs).
- Having good experience in production support and maintenance of application.
- Having Good Knowledge in UNIX Commands
- Created Impact analysis document, Unit Test Cases, Deployment documents.
- Constructive skill in writing Joins, Sub Queries, Views and Sequences.
- Effectively made use of Indexes, Constraints, Analytical functions.
- Excellent ability to handle multiple tasks and work well in a team environment.
- Highly flexible and capable of learning new tools and applications.
Working Experience:
- Currently working as Software Engineer from April-2022 to till date.
- Worked as Analyst in Equifax Analytics Pvt.Ltd, Bangalore from Jan 2021 to Mar 2022.
- Worked as IT Recruiter Sellcraft Global Solutions Pvt. Ltd, Bangalore from April 2018 to Oct 2020.
Technical Skills:
Operating Systems
: Windows All Versions
ETL Tools
: Informatica PC 10.2, 9.5,9.6 & Reltio MDM
Languages/Technologies
: SQL, SAS
Database
: Oracle 10g/11g,12C, SQL Server
Tools
: SQL*Plus, SQL Developer, Putty, Toad, WinSCP, Service Now , CSM and Postman API
Project summary:
Project #1
Project Name
: Roche
Client
: IQVIA
Role
: Software Engineer
Duration
: April 2022 to Till Date
Team Size
: 6
Technologies
: Reltio MDM, Informatica Power Center 10.4.1, SQL, Postman API, Oracle 12C, Putty, Oracle SQL developer,UNIX, WinSCP.
Description:
The Objective of the project is to extract a single golden record out of multiple info received from different sources by applying the MDM logics using Reltio and share to integrated downstream systems which is used by Business/Clients.
Responsibilities:
- Enhancements and Change Requests are being implemented.
- Mainly working on Change requests which are raised by COL’s in CSM ticketing tool.
- Prepared Unit test cases and technical specifications.
- Analyzing source and Target systems based on requirement specification.
- Verified session logs to identify the errors occurred during the ETL execution.
- Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
- Gathered business requirements from Data Analyst.
- Developed mappings using various transformations like Router, Filter, sequence generator, joiner, aggregate tra