Oracle Developer with Facets

Description

Oracle PL/SQL Developer with Facets Healthcare
Location Norfolk, VA
Looking for a strong Oracle PL/SQL Developer with Facets experience.
6+ years of experience with Oracle PL/SQL, SQL Server and related technologies.
2+ years of Facets experience, preferably within the healthcare domain.
Experience in Relational database concepts, relational logical modeling, best practices and physical design.
Experience in Design, evaluate and optimize database structures (tables, views, packages and functions) while developing methods or scripts for monitoring database capacity, usage & performance.
Experience in creating Informatica Workflows and/or SSIS packages for complex ETL processes with various sources such as Flat files, SQL server, Oracle, JSON etc.
Experience Working in an Agile Environment and DevOps tool sets such as SVN, RedGate, BitBucket, GIT, bamboo etc.
Mentoring others on coding standards and performs code reviews and provide support along with maintaining their work balance.
Healthcare domain knowledge experience.
Knowledge of Entity Relationship (ER) Diagrams.
Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
Identify columns for Natural Keys in database tables or query results.
Knowledgeable in potential server blocking, deadlocks and write code to avoid those situations.
Design effective, expandable, and efficient ETL Systems.
Ability to tune complex queries to optimize performance.
Proven experience of Data migration and Data expansion.