• Developing and maintaining PL/SQL scripts and stored procedures to support data managing and manipulation in Oracle databases• Designing and implementing efficient database structures and optimizing SQL queries for improving performance.• Utilizing Jira and Confluence to managing project tasks, tracking progress, and facilitating communication within the team.• Participating in code reviews, identifying and resolving bugs, and implementing enhancements to ensure software quality.• Conducting unit testing, integration testing, and end-to-end testing to ensure the reliability and stability of software solutions. Applications used : Oracle, Python, JIRA

• Developing and maintaining ETL workflows in an agile environment, ensuring efficient data extraction, transformation, and loading processes.• Automating the ETL processing using CI/CD pipelines and tracking changes made to data pipelines, code and configurations.• Developing and maintaining AWS Lambda functions for data extraction and loading• Creating visualized dashboards using BI tools, exploring insights, and providing business solutions• Performing performance monitoring and tuning and optimization of the databases Applications used : Amazon Redshift, Python, Lambda, Informatica,PowerBI, Confluence

• Designing and Creation of SQL Server Databases objects• Involving in writing SQL queries and creation of tables, Joins, Views, Stored Procedures, Cursors, and triggers in MS SQL Server• Developing SQL scripts and stored procedures for managing data efficiently• Solving project-related problems and identifying opportunities for improvements• Regular monitoring and Resolution of tickets raised by clients Applications used : SQL Server, SQL Server Management Studio(SSMS)