Client: Bank

Position: Oracle PL/SQL

Location: Jersey City (Hybrid 3 day in a week onsite, 2 day remote)

Duration: 12 months (possible extensions)

Must Haves:   

• Hands-On Oracle PLSQL development and Informatica
• 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 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

Primary Skill:

• Oracle SQL / PLSQL

Secondary Skill:

ETL/Database testing

Required Skills:

• Strong in Oracle version 11.x & above
• Experience in Procedures, Functions, Packages, views, Materialized Views, Indexes, Triggers, Constraints, Snapshots, Synonyms, Sequences, Database Links, Bulk collect, Forall, ref cursor, partition tables, Analytical functions, collections,
• Any version control tool (SVN/Bitbucket)

Desired Skills:

• Informatica, Autosys
• Unix Concepts
• Experience on SDM Adoption / Horizon onboarding tools (Bit Bucket, Datical, Jenkins)
• Agile best practices

Pay Range: $65/hr - $68/hr 

You can reach me on dimpy.sachdeva@collabera.com or 973-381-7135