- Worked on loading the target tables in Teradata database using the business requirements specified in mapping sheets, through BTEQ (Basic Teradata Query) and other tools
- Worked on Machine Learning POC projects using R/Python to implement algorithms for automating manual processes and improved the efficiency of operations
- Developed Unix shell scripts to validate the source file for zero record check, file date check,
duplicate file check, datatype length check and then to load source table from source file
- Developed the stage load scripts using Teradata BTEQ to extract the data from source table columns and to transform them to load the columns in stage table using the complex transformations in Requirement mappings
- Developed target load scripts using Teradata BTEQ to perform SCD (Slowly Changing
Dimension) to categorize the stage table records into Insert, Delete and Update and then to load the target table accordingly
