KarthickKumar Mylsamy

Experience

• 

  UST

  Oct 2013 - Sept 2017

  Senior Software Developer

  • Worked on complex mappings using Source Qualifier, Expression, Filter, Router, Lookup, Aggregator, Update strategy, Java transformation, XML Parser transformation, Joiner and Union transformations in Informatica Powercenter.• Worked on command task, Email task, worklets, mapplets and conditional tasks.• Developed an ETL framework to extract data from Operational Data Store (ODS) and load into target tables using Informatica.• Performed performance tuning on ETL mappings using Push down Optimization (PDO) and on SQL queries. • Worked on building/customizing UNIX shell scripts and calling those scripts using Informatica command task.• Developed ETL objects to source the data from MQ (Message Queue) and loaded into staging area using XML parser transformation.• Worked on TPT (Teradata Parallel Transporter) to load the data from Oracle to Teradata table using Informatica.• Created user defined functions in Informatica to handle source data issues.• Developer in ETL frameworks to implement complex logics by creating macros, views in Teradata to build Dimensional, Relational and Fact tables in Enterprise Data Warehouse.• Hands-on experience in Teradata utilities BTEQ, MLOAD, FLOAD, FastExport.• Developed many Fact, Relational and Dimension tables using Teradata macros, views to build Enterprise Data Warehouse for report generation and analysis.• Analysis of data through Teradata Administrator and Teradata SQL Assistant to find the affected components for the given requirement.• Worked on performance tuning of Teradata jobs using Teradata query tuning.• Formulated test cases and coordinated with UAT team for effective testing of the module with HP Quality Center tool.• Creating and testing deployment packages for the delivery using JENKINS tool and SVN.• Familiar with CI/CD in Agile/Scrum methodology.• Worked in Confluence and JIRA for smooth functioning of Sprints in Agile methodology. Show less

• 

  T-Mobile

  Sept 2017 - Nov 2022

  Sr. Data Engineer

  EDIT

• 

  Infosys

  Sept 2017 - now

  • Technology Lead

    Sept 2023 - now

  • Technology Lead

    Oct 2021 - Sept 2023

  • Technology Analyst

    Dec 2020 - Oct 2021

  • Technology Analyst

    Sept 2017 - Dec 2020
• 

  Comcast

  Nov 2022 - now

  Sr. Data Engineer

  Edit