Summary
Overview
Work History
Education
Skills
Timeline
Generic

SARANYA ARUMUGAM

Middle Sackville,NS

Summary

Dedicated Informatica Power Center Developer with 7+ years of experience in designing, developing, and implementing data integration solutions. Proven track record of delivering high-quality ETL processes, optimizing data workflows, and ensuring data accuracy. Seeking to contribute expertise to a forward-thinking organization. To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.

Overview

7
7
years of professional experience

Work History

ETL Informatica Developer

Cognizant Technologies Solutions
01.2016 - 03.2023
  • Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat Files.
  • Proficient in Informatica Power Center versions 10.2, 10.1
  • Extensively used transformations like Router, Filter, Aggregator, Lookup, Union, Joiner, Expression, Update Strategy, Sequence generator...etc
  • Parameterized mappings and increased re-usability.
  • Created procedures to truncate data in target before next run of session.
  • Applied SCD (Slowly changing Dimension) type 1 and 2 to effectively perform Delta Loads.
  • Automated Informatica jobs using UNIX shell scripting.
  • Created test case documents once mapping developed
  • Prepared error handling document to maintain error handling process in future.
  • Skilled in performance tuning, debugging, and optimizing ETL processes
  • Familiarity with data modeling and data profiling.
  • Optimized ETL jobs for performance by fine-tuning mappings, sessions, and workflows.
  • Created and maintained documentation for ETL processes, data mappings, and data lineage.
  • Supported production environments by monitoring ETL processes, resolving issues, and implementing enhancements.
  • Conducted knowledge transfer sessions to train junior developers and team members.

ETL Informatica Developer

Cognizant Technologies Solutions
02.2021 - 03.2023
  • Led design and development of ETL processes using Informatica Power Center to ensure efficient data extraction, transformation, and loading.
  • Worked closely with business analysts and data architects to gather and document ETL requirements.
  • Created and maintained data mappings, transformations, and workflows in Power Center Designer.
  • Developed and optimized SQL and PL/SQL scripts for data extraction and transformation.
  • Implemented error handling mechanisms and data quality checks to ensure data accuracy.
  • Conducted performance tuning to meet stringent SLAs and enhance overall system performance.
  • Collaborated with database administrators to optimize database performance and resolve data-related issues.
  • Provided production support, promptly identifying and resolving data integration issues.
  • Conducted unit testing, integration testing, and user acceptance testing for ETL processes.
  • Adaptable and proficient in learning new concepts quickly and efficiently.

Education

Bachelor of Engineering - Electronics And Communications

Velammal College of Engineering And Technology
INDIA
05.2015

Skills

  • Client Requirements
  • Performance Tuning
  • Production Work
  • Extraction Transformation and Loading (ETL)
  • Business Logic Implementation
  • Mapping Skills
  • Team Meetings
  • Bug Fixes

Timeline

ETL Informatica Developer

Cognizant Technologies Solutions
02.2021 - 03.2023

ETL Informatica Developer

Cognizant Technologies Solutions
01.2016 - 03.2023

Bachelor of Engineering - Electronics And Communications

Velammal College of Engineering And Technology

Similar Profiles

CREATE PROFILE
SARANYA ARUMUGAM