Sivakami Krishnan

ETL Informatica Developer at PC Financial (SG)
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
North York, Ontario, Canada, CA

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • SAP Certified Application Associate-SAP Access Control 12.0
    SAP
    Nov, 2022
    - Oct, 2024
  • SAP Certified Technology Associate - SAP System Security and Authorizations
    SAP
    Sep, 2022
    - Oct, 2024

Experience

  • PC Financial (SG)
    • Singapore
    • Financial Services
    • 1 - 100 Employee
    • ETL Informatica Developer
      • Jan 2021 - Present

       Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Flat files.  Development of ETL using Informatica 8.6.  Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.  Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.  Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.  Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.  Created various tasks like Session, Command, Timer and Event wait.  Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.  Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.  Analyzed data flows data mapping and data transformations from source to target systems.  Analvzed ETL code stored procedures and shell scripts.  Used Informatica Data Quality to extract transform and load ETL rules and source-to-target mappings to derive additional business rules for data quality checks.  Developed/Enhanced the complex mappings Workflows to Extract Transform Load data from different source systems like Oracle Flat files Excel to Target Oracle systems. Show less

  • IndusInd Bank
    • India
    • Banking
    • 700 & Above Employee
    • ETL Informatica Developer
      • Jan 2020 - Sep 2020

       Gathered requirements from Business users and created a Low level technical design documents using high level design document.  Participated in the Design Meetings and prepared technical and mapping documentation.  Designed Developed and Supported Extraction Transformation and Load ET Processes using Informatica Power Center 9.5 for data migration from source systems.  Written Pre and Post Session SQL commands DDL DML to drotand recreate the indexes on data warehouse  Developed complex Informatica mappings using Unconnected Lookup Sorter and Aggregator and Router transformations for populating target table in efficient manner.  Extensively worked on developing Continuous Change Data CDC.  Developed Slowly Changing Dimension Mappings for Type 1 and Type 2.  Performance tuned the Mappings Tasks Sessions SQL and Scripts to optimize Data-Load performance.  Used data services for data profiling of sources between SQL Server and Oracle sources.  Involved in massive data profiling using IDQ Analyst tool prior to data staging.  Developed process for Teradata using Shell Scripting and RDBMS utilities such as MLoad Fast Load Teradata.  Extensively used pmcmd commands on command prompt and executed UNIX Shell scripts to automate workflows and to populate parameter files. Show less

  • Axis Bank
    • India
    • Banking
    • 700 & Above Employee
    • ETL Informatica / Datastage Developer
      • Dec 2017 - Jan 2020

       Studying the business requirement and worked extensively with Project Manager, BA's and users to effectively capture the user specifications.  Extensively used Data Stage stages namely Data set, Sequential file, Transformer, Aggregate, Sort, Remove Duplicates, Join, Lookup, Change Capture, Funnel, Peek, Row Generator, Filter stages in accomplishing the ETL Coding.  Extensively dealt with change capture techniques for implementing slowly changing dimensions process.  Used Information Analyzer to conduct end to end data profiling and content analysis.  Developed Parallel Jobs which loads Dimension Tables and maintained Surrogate key generation in multiple run.  Developed Subject Area Jobs for performing all the transformations required in the data process for creating the load ready files.  Designed ETL jobs incorporating complex transform methodologies using Data Stage tool resulting in development of efficient interfaces between source and target systems.  Performed unit as well as integrated testing to validate the job designs and check for data reliability Show less

  • Cognizant
    • United States
    • IT Services and IT Consulting
    • 700 & Above Employee
    • ETL Developer / Programmer
      • Jul 2014 - Sep 2014

       Migration project of Informatica PowerCenter version 7.1 to version 9.6.  Installation of Informatica PowerCenter, and configuration domain, Repository and Integration Service.  Informatica PowerCenter management, creating folders, users, groups and assigning roles and permissions.  Tunning processes to improve download times based on best practices.  Development of mapping to extract big volumes data and deliver information.  Construction of tables and data modeling.  Analysis of application requirements in consultant with the business users and other technical team members.  Design of data flows using Informatica PowerCenter.  Responsible for arranging periodic status calls with offshore coordinating development efforts and making sure everything is well organized.  Developing complex Informatica mappings using different types of transformations like Connected and Unconnected  LOOKUP transformations, Router, Filter, Aggregator, Expression, Normalizer and Update strategy transformations for large volumes of Data.  Unit and Regression testing of the Informatica Mappings  Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.  Worked with session logs, Informatica Debugger and Performance logs for error handling when session fails.  Defining Mapping / Session parameters to maintain standards and reusability. Show less

Education

  • Bharathiar University
    Master of Business Administration - MBA, Human Resources Management and Services
    2015 - 2017
  • Sri Krishna College of Engineering and Technology
    Bachelor's degree, Computer Technology/Computer Systems Technology

Community

You need to have a working account to view this content. Click here to join now