Involved in a data model by reverse engineering highly complex Athena views. Built and managed Database infrastructure for client on AWS Aurora and Built an EDW system from scratch with ODS, DWH and Data Mart layers incorporating over 70 objects. Creating DDLs, Stored Procedure scripts for automating the entire EDW data load process and Worked with Core Lake team to ingest data from delimited/ fixed width file/excel sheets/EDI files and load into EDW system for further processing. Unit testing, deployment and Code control using Git, Jira documentations for stories or defects and Confluences for documenting and recording functionality, adopted Agile Scrum methodologies. Process data from S3 to Snowflake Datawarehouse, by defining stages, streams, pipes and at merging stored procedures and Resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues etc.

The responsibilities include Creating Tables, Procedures, Views, Analysis the Data, and Monitoring the Dell Boomi for the data and correcting the data and reprocess the data in Dell Boomi. Creating Lambda Functions for the S3 files to PostgreSQL Tables (ETL) and Snowflake Datawarehouse, by defining stages, streams, pipes and at merging stored procedures.

The responsibilities involve client interaction to get the business and Analysis of functional requirement and defining of database objects and implementing and supporting highly scalable Database & data warehouse solutions. Developed advanced T-SQL and PL/PGSQL code, including stored procedures, functions, triggers, indexes, and views. Proficient in querying complex JSON data and optimizing SQL query performance through analysis of execution plans and statistics usage. Designing and implementing ETL & ELT packages with different types of sources, destination, transformations AWS Glue using PySpark and Variety of file manipulation and movement activities in S3 with various file formats and consumption of data from files in S3, through AWS Lambda functions using Python. Migration from PostgreSQL, S3, Snowflake Datawarehouse, by defining stages, streams, pipes and at merging stored procedures and Resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues etc.

The responsibilities include Creating Tables, Procedures, Views, Analysis the Data, and Monitoring the Dell Boomi for the data and correcting the data and reprocess the data in Dell Boomi. Creating Lambda Functions for the S3 files to PostgreSQL Tables (ETL) and Snowflake Datawarehouse, by defining stages, streams, pipes and at merging stored procedures.

Analysis of functional requirement and Developed complex T-SQL and PL/PGSQL code such as Stored Procedures, functions, triggers, Indexes and views for the application and Querying complex XML and JSON Data. Indexing Design, Implementation and Maintenance (monitoring of usage and re-designing) and Performance tuning of complex SQL Queries by analyzing the execution plans, statistics usage, DMVs etc... implementing ETL & ELT packages with different types of sources, destination, transformations, using SSIS and Migrating data and database objects across versions and database engines and Resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, security issues etc.