TANISHK CHATURVEDI

Contributing to a Data Migration project from Oracle to Snowflake cloud Data Warehouse. Using Qlik to extract data in real-time and Matllion for creating robust Data Pipelines supporting BI, end-client reporting on Tableau / Cognos. Understanding the flow of Informatica and Alteryx workflows and converting them into Matillion mappings by building the various transformation jobs to define the complex SQL logic and making the Matillion components compatible. Worked on building the CDC and DELTA Detection logic and tested IUD operations that majorly helped in 60% performance optimization for the client. Hands-on experience with SCD type 2, STREAMS, developing complex Stored Procedures, and on multiple data source scenarios like flat file, database, Salesforce Integration, API, Hyper files, etc. Created various orchestration jobs for loading data using Connectors (S3 load, Salesforce Query, Integrations, Query components). Worked on orchestration for Implementation of notification and audit framework and worked on Scheduling the job in Matillion. Creating SQL scripts that are used to compare Matillion output data with the snapshot of client prod data. Unit Test cases for Row count, Column nullability, value, format by generating hash values. Performed Incremental and Integration testing. Led 2 projects including SFDC and managed a team of 8-11 employees.