Sr. Data Warehouse Developer (PL/SQL, SQL developer)

Location: Richmond, VA
Date Posted: 12-01-2017
Sr. Data Warehouse Developer (PL/SQL, SQL developer)
Richmond, VA
6 Months
Need Local OR regional &&& F2F
Data Warehouse Developer Role:
Experienced SQL and PL/SQL developer on Oracle database platform.
Deep understanding of data warehouse and star schema
Develop ETL scripts and write PL/SQL code from data model, dataflow diagram and technical design specifications
Ability to work on wide variety of development needs from simple queries to complex queries and multidimensional analysis
Ability to follow best coding standards practices
Expert in performance tuning of ETL/SQL code
Analyze and provide resolutions for production data issues
Familiar with UNIX shell scripting and job automation
Build and implement BI dashboards, analysis using OBIEE
Build reports using BI publisher
Complete Description:
Support for development and maintenance of enterprise Oracle data warehouse to support Business Intelligence and Analytics initiatives.
Experience and Skills:
5 years or more of experience of a database developer in a professional environment
5 years or more of experience in a Data Warehouse and Business Intelligence environment
  • SQL
  • PL/SQL
  • Data Modeling
  • Oracle SQL Developer
  • UNIX
  • Oracle BI Publisher
  • MS Office Proficiency (Word, Excel, PowerPoint, Visio)

Preferred Qualifications:
  • Oracle PL/SQL Developer Certified Associate Preferred
  • Strong business acumen and communications skills
  • Experience in data warehousing for a retail/store environment
Required / Desired Skills:
  • PL/SQL and SQL developer with Oracle experience
  • Understanding of Start Schema data warehouses and data warehouse design
  • ETL script development and execution, including automation in a Linux / Oracle environment
  • Performance tuning and reconciliation of SQL query execution
  • Familiar with UNIX Shell Scripting
  • Experience with OBIEE, BIP and Repository modeling in Oracle OBIEE platform
  • Experience developing report specifications from business requirements and executing the build to design
  • Experience with a mature data modelling tool such as ERWIN or SQL Developer


Technical Recruiter
Key Business Solutions, Inc|| Office: 916 646 2080 Ext 216 || Fax: 916 646 2081 || || G Talk: satya.usstaffing
Notice: This email is not intended to be a solicitation.  Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list. Thank You

this job portal is powered by CATS