• Industry :Banking/Finance                                        
• Work Location:JerseyCity,NJ / Plano,TX(Hybrid)
• Job Title :Oracle PL/SQL
• Duration:12-18 Months (Contract)    
• Pay Range : 55$-65$

Must Haves:    

• Hands-On Oracle PLSQL development and Informatica Dev

• Data Warehousing

• Data Modeling

• Some BI reporting background (Tableau, Cognos, MSTR, etc)

• Resource to design, develop, maintain and test software, collaborating with the development team and business partners to ensure successful delivery and implementation of application solutions in an agile environment.

• Should be hands on and able to successfully deliver on time without defects. Ability to analyze, design and support implementation of Oracle PL/SQL, Views, create/modify database tables based on business requirements and specifications

Responsibilities

· Responsible to develop/modify PL/SQL, SQL Views in Oracle

· Responsible to create a new tables/modify existing table structure.

· Performance tuning and good understanding of explain plan

· Normalization, renormalization and star schema

· Develops stored procedures, database triggers and SQL queries

· Must be able to work independently with minimum supervision.

· Responsible to develop test cases and perform unit testing.

· Must be able to interact and co-ordinate with distributed team.

· Must be good in communication skills.

· Responsible to provide regular task status update to the management