Oracle developer III

RiVi Consulting Group LLC
Washington, DC
Sep 14, 2019
Sep 23, 2019
Full Time
Position OverviewThe desired candidate will fill in the position of a PL/SQL developer. This person's primary responsibility will be to develop PL/SQL code - procedure, functions, and packages to transform the source data based on business rules and load them in to target tables in the warehouse. Other responsibilities include query analysis & optimization, and maintenance of the data models. Additional responsibilities will include working with Tableau, Business Objects and J2EE technologies.Essential Job FunctionsConduct a detailed discussion with the SMEs and document the understanding of the business requirementsWrite Low Level Design, Unit Testing Plan, and Unit Test case documentationTroubleshoot performance related issuesSupport system and user acceptance testing activities, including issue resolutionResearch problems reported by clients and other stakeholders and recommend fixes and solutions to be implemented after review by SMEsComplete technical documentation to ensure system is fully documentedEducational Qualification And ExperienceBachelor's degree in Computer Science, Engineering, or related discipline, and 2+ years of experience in Oracle development environmentGood PL SQL programming experience in Oracle 11g - creating procedure, packages, functions, and triggersGood experience in development of Data Warehouse, Operational Data Store, and ETL solutionsGood experience with data storage and retrievalGood experience with SQL analysis and query optimizationGood experience with Job SchedulingGood experience with Shell ScriptingBasic experience with Agile/Scrum development methodologyCertification RequirementsOracle CertificationRequired Skills/AbilitiesGood analytical and problem solving abilitiesBasic knowledge of data modeling concepts and methodologies (Kimball) used in a data warehousing environmentGood communication and writing skills with the ability to work in challenging environmentAbility to multi-task their workload assignmentsGood analytical, problem-identification/solving skillsSelf-starter who enjoys working in an international teamFlexibility, creativity and initiativeGood knowledge and experience in PL/SQL, Oracle 11x (latest DB version) and/or SQL server.--RiVi GroupPlease visit our website: