Advanced PL/SQL Developer
Work Location Thosuand Oaks, CA
Duration 6 Months and extendible
Mandatory Technical / Functional Skills
Overall IT experience required of upto 8 to 10 Yrs, with a minimum of 6 years of experience in complex PL/SQL Code
development
Should know different database models like Snowflake etc
Should know abt ER diagram and different DB design tools like ERwin
Have experience in designing of database for OLAP and OLTP
Should know transformation of ER diagram to database Tables
Should know Physical and conceptual database design
Advanced SQL: Should know abt latest features of Oracle 11g
Have worked on XML parsing
Worked on analytical functions
Use of collections in PL-SQL
Performance tuning of SQL
Performance tuning of Procedures and functions
Knowledge of Explain Plan, ADDM and AWR
Have worked on Materialized Views
Use of external table and other data loading options
Desirable Technical / Functional Skills Good exposure to the Pharma Domain.
Must possess Excellent Communication skills.
Customer facing role and worked in onsite/offshore model
Total experience in required skill (years)
6 Years in Advanced PL/SQL coding
Work Location Thosuand Oaks, CA
Duration 6 Months and extendible
Mandatory Technical / Functional Skills
Overall IT experience required of upto 8 to 10 Yrs, with a minimum of 6 years of experience in complex PL/SQL Code
development
Should know different database models like Snowflake etc
Should know abt ER diagram and different DB design tools like ERwin
Have experience in designing of database for OLAP and OLTP
Should know transformation of ER diagram to database Tables
Should know Physical and conceptual database design
Advanced SQL: Should know abt latest features of Oracle 11g
Have worked on XML parsing
Worked on analytical functions
Use of collections in PL-SQL
Performance tuning of SQL
Performance tuning of Procedures and functions
Knowledge of Explain Plan, ADDM and AWR
Have worked on Materialized Views
Use of external table and other data loading options
Desirable Technical / Functional Skills Good exposure to the Pharma Domain.
Must possess Excellent Communication skills.
Customer facing role and worked in onsite/offshore model
Total experience in required skill (years)
6 Years in Advanced PL/SQL coding