Data warehouse Developer - Assistant Manager

As a Data Warehouse Developer at State Street, you will play a crucial role in designing, developing, implementing, supporting, and maintaining business-critical software on the Oracle platform (12c, 19c). Your responsibilities will include: - Analysis and manipulation of data to support building new reports and modify existing reports - Good understanding of warehousing concepts such as facts, dimensions, marts, cubes, etc. - Performing code reviews and unit testing of code on SQL and PL/SQL codes - Analyzing SQL and PL/SQL codes, performing bug-fixing, and applying good coding practices - Developing and managing well-functioning databases and applications - Knowledge on DB Cloud services and developing/maintaining Oracle database applications using SQL - Designing and developing database schemas, stored procedures, functions, and triggers using PL/SQL - Good knowledge on cursors and optimizing database performance by tuning SQL queries and PL/SQL code - Working on Proof of concepts and presenting to stakeholders - Completing end-to-end unit and functional testing - Testing software applications to ensure responsiveness and efficiency - Troubleshooting, debugging, and upgrading so…