Sakthivel Chinnusamy

Experience

• 

  HCL Technologies

  Dec 2021 - Aug 2024

  Software Engineer

  Project Domain : Manufacturing Environment : Oracle 11g, WindowsRole : ETL DeveloperDescription:The main objective of the truck manufacturing industry's production process is supported by a sophisticated database management system that facilitates efficient operations, inventory management, and financial transactions. With comprehensive tracking of variants, factory codes, truck details, stocks, and invoices, the industry is equipped to meet customer demands while maintaining high standards of quality and reliability.Roles and ResponsibilitiesUnderstanding the requirements from the business. Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Mapplet Designer and Mapping Designer. Develop the mappings using needed Transformations in Informatica tool according to technical specifications Created complex mappings that involved implementation of Business Logic to load data in to staging area. Used Informatica reusability at various levels of development. Developed mappings/sessions using Informatica Power Center for data loading. Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Stored procedure, Joiner, Router, Sorter and Union. Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor. Building Reports according to user Requirement. Extracted data from Oracle then used for data warehousing. Implemented slowly changing dimension methodology for accessing the full history of accounts. Optimizing performance tuning at source, target, mapping and session level Participated in daily status meetings, as well as formal walk through among various teams and documenting the proceedings Show less

• 

  KGiSL

  Oct 2024 - Mar 2025

  Associate

  ROLE: ETL DevelopmentDomain: BFS(Banking, Finance and Insurance) Domain project.

• 

  Infosys

  Apr 2025 - now

  Technology Analyst