Summary
Overview
Work History
Education
Skills
Timeline
Generic

VIGNESH BALAJI KUAMARASAMY

Plano

Summary

Dynamic Senior Informatica Developer with TATA Consultancy Services, specializing in ETL development and data warehousing. Proven expertise in Informatica PowerCenter and Oracle Retail Merchandise applications, enhancing system performance and efficiency. Adept at collaborating with cross-functional teams to deliver innovative solutions, demonstrating strong analytical skills and a commitment to excellence in every project.

Overview

14
14
years of professional experience

Work History

Senior Informatica Developer , Oracle Retail Consu

TATA CONSULTANCY SERVICES INC
Plano
07.2023 - Current
  • Deployed business logic frameworks for model implementation.
  • Worked with business analysts to gather and define project requirements.
  • Documented all ETL processes created using Informatica PowerCenter.
  • Identified, debugged, and fixed system bottlenecks and problems.
  • Provided production support for all ETL-related issues involving Informatica PowerCenter.
  • Created mappings, sessions and workflows to move data from source systems to target systems using Informatica PowerCenter.
  • Analyze, research, design and write specifications for maintenance of the new Oracle purchase order management system.
  • Develop standards, procedures, and a checklist to meet business requirements.
  • Performance monitoring, tuning, troubleshooting, reorganization, and security implementation.

ETL Informatica Developer

TATA CONSULTANCY SERVICES
Chennai
03.2019 - 06.2023
  • Designed complex transformations using various transformation objects like Joiner, Lookup, Aggregator, Sorter in Informatica PowerCenter.
  • Performed unit testing of mappings, sessions and workflows developed in Informatica PowerCenter.
  • Implemented error handling logic for failed ETL loads using error log tables in Oracle Database or flat files generated by Informatica PowerCenter.
  • Supported and department staff by designing and managing data extraction procedures.
  • Reviewed data warehouse system details, such as execution time and storage, to improve efficiency.
  • Analyzed, researched, designed, and wrote specifications for the maintenance and enhancement of modules in Oracle Retail Merchandising applications: Oracle Item, Oracle Retail Sales Audit (ReSA), and Oracle Purchase Order Management.
  • Maintained databases, designed new structures/ data modeling / pl/sql packages/ procedures / views / function for
    development and data migration from production to reports.

ETL Informatica Developer

TATA CONSULTANCY SERVICES
Chennai
03.2015 - 02.2019
  • Worked with business analysts to gather and define project requirements.
  • Created mappings, sessions and workflows to move data from source systems to target systems using Informatica PowerCenter.
  • Used Performance tuning techniques such as Partitioning technique and Bulk Loader options available within Transformations section while developing Mapping logic .
  • Implemented error handling logic for failed ETL loads using error log tables in Oracle Database or flat files generated by Informatica PowerCenter.
  • Performed unit testing of mappings, sessions and workflows developed in Informatica PowerCenter.
  • Optimized existing ETL processes by analyzing performance bottlenecks and implementing best practices in Informatica PowerCenter.
  • Produced technical specifications and design documentation.
  • Coordinated with DBA team for creating new databases, tablespace configurations, user accounts creation and privileges management, when required for development purpose or migration purpose across different environments.
  • Maintenance and enhancement of modules in Oracle Retail Merchandising applications - Oracle Retail Predictive Application (RPAS), Oracle Assortment Planning Item Planning (APIP), Oracle Location Planning store clustering (LPSC).
  • Maintain databases, design new structures/ data modeling / pl/sql packages/ procedures / views / function for development.
  • Provided technical support to project teams and members and associates

Linux System Engineer, ETL Informatica Support

TATA CONSULTANCY SERVICES
CHENNAI
01.2011 - 02.2015
  • Created user accounts and managed permissions on the file system level for multiple users.
  • Provided technical guidance for system development and troubleshooting.
  • Performed regular maintenance tasks such as patching, security updates, log reviews, backups.
  • Developed scripts to automate various system administration tasks.
  • Worked closely with development teams to ensure smooth deployment of their applications.
  • Developed shell scripts for scheduling jobs in UNIX environment.
  • Developed Informatica mappings to perform validations, data transformations and loading of data into target systems.
  • Tuned sessions by changing session properties like buffer size, commit interval, to improve performance of the load process.
  • Provided support during migration activities by troubleshooting production issues.
  • Worked on Debugging existing mappings and resolving issues in mapping logic.
  • Performed Data Cleansing operations using SQL queries and PL and SQL functions for transforming the data from source to target systems as per requirements.
  • Involved in creating technical design documents related to ETL projects.

Education

BACHELORS - Electronics And Communications Engineering

ANNA UNIVERSITY
CHENNAI
07-2010

Skills

  • Informatica PowerCenter
  • ETL development
  • Data warehousing
  • UNIX shell scripting
  • Data modeling
  • Oracle RMS
  • PL/SQL Programming
  • Teradata
  • Scheduling tools
  • IBM DB2

Timeline

Senior Informatica Developer , Oracle Retail Consu

TATA CONSULTANCY SERVICES INC
07.2023 - Current

ETL Informatica Developer

TATA CONSULTANCY SERVICES
03.2019 - 06.2023

ETL Informatica Developer

TATA CONSULTANCY SERVICES
03.2015 - 02.2019

Linux System Engineer, ETL Informatica Support

TATA CONSULTANCY SERVICES
01.2011 - 02.2015

BACHELORS - Electronics And Communications Engineering

ANNA UNIVERSITY

Similar Profiles

  • Victor Mejores

    Victor MejoresVictor Mejores

    Senior Process Associate at TATA Consultancy Services IncSenior Process Associate at TATA Consultancy Services Inc

  • Vrunda Chindhade

    Vrunda ChindhadeVrunda Chindhade

    HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited

  • Sreya Basu

    Sreya BasuSreya Basu

    Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)

  • Natalia Gurau

    Natalia GurauNatalia Gurau

    Freelance Fashion Illustrator at Anastasya FitFreelance Fashion Illustrator at Anastasya Fit

  • Sheridan Butler

    Sheridan ButlerSheridan Butler

    Legal Assistant at LoBue Law, PLLCLegal Assistant at LoBue Law, PLLC

CREATE PROFILE
VIGNESH BALAJI KUAMARASAMY