Summary
Overview
Work History
Education
Skills
Timeline
background-images

Deepthilakshmi A Y

Kuala Lumpur

Summary

  • Close to 6 years of experience in ETL Development using Informatica PowerCenter, Teradata, Unix
  • Designed and implemented generic reusable Informatica mapping template
  • Developed and deployed small, medium and complex Informatica mappings
  • Extensively worked on Informatica transformations like Expression, Lookup, Filter, Router and Source Qualifier, etc
  • Worked on Informatica pushdown optimization with Teradata
  • Hands on experience in Informatica Job optimization
  • Resolved performance bottlenecks in various levels like sources, targets, mappings and sessions
  • Well versed with FSLDM Subject Area like Agreement, Party, Product and Event etc
  • Proficiency in using Informatica TPT (Fast Export, Fast load, Multi Load) and Relational connections and External Loader
  • Proficiency in developing SQL with various relational databases like Oracle, Teradata (Fast export, Fast Load, MLoad.)
  • Experienced in optimization of Informatica PDO generated SQL scripts, time/CPU/spool consuming SQL Queries
  • Involved in Database migrations activities
  • Independent
  • Dedicated
  • Diligent

Overview

14
14
years of professional experience

Work History

ETL Developer

Hong Leong Bank(Mission Constituency SDN BHD)
11.2021 - Current
  • Project Type: Enterprise Data Warehouse
  • Common Tools: Hadoop(HIVE), PySpark, Unix Shell Scripting, Controm-m, Teradata, GaussDB, JIRA, Putty, WinScp.
  • Project Summary: Replace Teradata with GuassDB to expand and optimize the current EDW solution and integrate all the relevant data from different source systems. EDW and Data Lake will become the source for both business analytics and reporting
  • Responsibilities
  • Design and implement scalable data pipelines to support batch data processing
    using Informatica, python and Spark.
  • Involved in Database migrations activities
  • Participated in test data preparation activity
  • Analyzed and migrated Teradata script into GaussDB script
  • As part of UAT support, performed root cause analysis and provided findings with team which was reduced failure percent in other TD to GD converted scripts
  • Familiar with dealing with complex Teradata queries, for example debugging 4k lines code and fixing issues
  • Involved in all project update meetings and daily standup calls.

ETL Developer

Cognizant Technology Solutions
01.2013 - 12.2014
  • Project Type : Enterprise Data Warehouse
  • Common Tools: Informatica PowerCenter 9.5, Teradata 13.x, Control-M, UNIX, RTC, Putty, WinScp,
  • Responsibilities:
  • Prepared low-level technical design document and participated in review of the Mapping Templates, Unit Test Plans & Test cases
  • Responsible for mapping Source data into Teradata FSLDM model as per the requirement
  • Responsible for creating Informatica Mapping with PDO
  • Responsible for developing Informatica Mapping with Fast Export(Source: Teradata) and External Loader(Target Oracle)
  • Responsible for Informatica Mapping optimization
  • Worked on optimizing the Teradata SQL to improve the performance of batch - Based on explain plan collected stats to improve the performance of SQL statements
  • Involved in batch status report automation
  • Created and Implemented auto email alerts in case of source file delay
  • Defect fix, Code deploy, and report generation as part of SIT and UAT test support.

Software Engineer

Cognizant Technology Solutions
04.2011 - 12.2012
  • Project Type: Data Warehouse
  • Tools: Informatica PowerCenter 9.6, Oracle 11g, Toad and UNIX.
  • Project Summary: Insurance Group is an American insurer group of automobiles, homes and small businesses and also provides other insurance and financial services products
  • Responsibilities
  • Serving as an ETL Developer for the ETL development/implementation team
  • Involved in Preparing Low level design document
  • Developed small, medium and complex Informatica mappings
  • Created reusable Mapplets and shortcuts
  • Extensively used Informatica debugger to figure out the problems in mapping
  • Also involved in troubleshooting existing ETL bugs
  • Involved in extracting the data from various source systems
  • Providing the weekly statistics to the Managers
  • Responsible for Daily status and Monthly Status Reports
  • Worked extensively on SQL, UNIX
  • Performed unit testing on various development mappings
  • Involved in supporting and maintaining Unix shell script jobs
  • Participated in unit testing and coordinated User Acceptance Testing
  • Provided complete support to test the cycle and verified session logs to identify the errors occurred during the execution, in case of any issues.

Education

Master of Science - Information Technology

MSCIT -

University of Madras

Skills

  • Error handling
  • Data migration
  • PySpark programming
  • Teradata SQL
  • Informatica
  • Shell Script
  • GAUSS DB

Timeline

ETL Developer

Hong Leong Bank(Mission Constituency SDN BHD)
11.2021 - Current

ETL Developer

Cognizant Technology Solutions
01.2013 - 12.2014

Software Engineer

Cognizant Technology Solutions
04.2011 - 12.2012

MSCIT -

University of Madras

Master of Science - Information Technology

Similar Profiles

CREATE PROFILE
Deepthilakshmi A Y