Madhura Karthick

Professional with around 11 years of experience with 5.7 years of specialized expertise in Snowflake DB development with snowsql & data engineering with skills of snow pipe, stream, task and ORACLE DB development, Informatica- IICS for data load. Used AWS, S3 IAM, storage integrations for migration. Implemented Database and Application security, created design documents and solved several use cases in complex application. Hands on experience in all stages of system development efforts, including requirement analysis, design, testing and implementation. Interacted with the business users, collected the requirements, analyzed the requirements, design and recommend solutions. Involved creation of the snow pipe to integrate the data between the AWS cloud to the snowflake DB. Experience in analyzing of existing SQL queries for performance improvements and Suggest new queries. Having knowledge on the time travel, fail safe and also data sharing between the snowflake accounts. Used sequences to generate the data sequence number for the primary key serial of data. Involved creation of the snow stream object to create the audit table data backup of the data whenever the DML is happening on base tables. Used the Clone technique in snowflake database to take the backup of the data whenever needed. Involved oracle PLSQL procedure to data validation in the source side to check the functional data dependency and the technical errors. Coordinate with the team at onsite for a smooth deployment, any change management or production issues. Knowledge in Oracle advance SQL Programming Using Analytical functions, Sub Queries, Joins and so on. Having knowledge in Incident management, Problem management and Change Management.