Summary
Overview
Work History
Education
Skills
Timeline
Generic

SARANYA ARUMUGAM

Lower Sackville,NS

Summary

Highly experienced Data Integration and ETL Specialist with 8+ years of experience in data engineering, data warehousing, and business intelligence solutions. Adept at using Informatica PowerCenter/PowerExchange. Proven expertise in extracting, transforming, and loading data from various sources, including DB2, Oracle, SAP systems, AWS, and flat files, into cloud and on-premise data platforms. To seek and maintain a full-time position that offers professional challenges utilising interpersonal skills, excellent time management and problem-solving skills.

Overview

7
7
years of professional experience

Work History

ETL Informatica Developer

Cognizant Technology Solutions
02.2016 - 03.2023
  • Created ETL mappings using informatica Power Center to move Data from multiple sources like Flat files, Snowflake from SAP ECC, flat files, and cloud sources, Oracle into a common target area such as Staging, Data Warehouse and Data Marts.
  • Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Filter, Sorter, Union and Router etc. to load the data into staging tables and then to Dimension tables Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent sessions and scheduling them to run at specified time.
  • Involved in performance tuning by optimizing the sources, targets, mappings and sessions.
  • Built Snowflake data models with star/snowflake schemas, handled performance tuning through clustering keys and query profiling.
  • Automated incremental loads using PowerExchange for change data capture (CDC) from DB2 and SAP ECC.
  • Created Mapplet and Re-usable Transformations for applying few logics. Created Connected, Un-Connected & Dynamic lookups (Cache).
  • Worked on Versioning Concepts on Informatica PowerCenter. Implemented incremental loading to from source to Stage.
  • Implemented SCD Type 1 and SCD type-2 Mapping Logic to load to the dimension tables.
  • Implanted Fact load Mapping testing of the existing Informatica workflows/mappings, Fix the bugs, Configuring the Databases connections in Informatica.
  • Implemented file-based integrations using Linux cron jobs and shell scripts to trigger Informatica workflows.
  • Monitoring the Informatica jobs and Troubleshooting . Verifying the data in target database after ETL process
  • Experience in working with business and understand objectives and worked with internal and external project stake holders on data solution design/review
  • Applied incremental Emergency bug fixes to fix any product issues and follow up with Informatica support for any issues.

Education

Bachelor of Engineering - Electronics And Communications

Velammal College of Engineering And Technology
05.2015

Skills

    ETL Tools & Data Integration

  • Informatica PowerCenter, PowerExchange
  • Data Modeling, Workflow Design, Performance Tuning
  • Complex mapping, SCD, Lookup, Aggregator, Joiner transformations

    • Databases & Data Sources

  • DB2, Oracle, Microsoft SQL Server
  • SAP ECC, SAP BW, eHANA
  • Flat files, CSV, Excel, Linux file system

    • Cloud Platforms & Big Data

  • Snowflake
  • AWS S3

    • Programming & Scripting

  • Shell Scripting (Unix/Linux environments)
  • Basic Python for data extraction and automation

    • Other Tools

  • SQL Developer, Putty, WinSCP
  • Version control (Git), Job scheduling (Control-M)

Timeline

ETL Informatica Developer

Cognizant Technology Solutions
02.2016 - 03.2023

Bachelor of Engineering - Electronics And Communications

Velammal College of Engineering And Technology

Similar Profiles

CREATE PROFILE
SARANYA ARUMUGAM