Title: Data Warehouse / Database Developer
Duration: 6+ Months
PRINCIPAL DUTIES AND RESPONSIBILITIES:
Assist with design, architecture, security & performance tuning for Databases.
Write technical specifications to guide the selection of and integration with different Database systems.
Design, implement, and test the structure and schemas of data warehouse.
Write stored procedures and code to implement extract, transform, and load methodologies.
Design, implement, test, and debug database stored procedures and complex queries to extract, calculate or manipulate information.
Participate in Clients development of strategy, processes, skills, and operational practices for the support Database integration and development.
Develop applications and enhancements from requirements high-level concept meetings Strong understanding of data models and the data dictionary without IDE assistance.
Collaborate with developers, business analysts, and business users in development of new functionality within applications.
Develop ad-hoc queries and reports on demand with short turnaround times as determined by business priorities.
Design applications and support Oracle APEX web application development platform.
Assist in the development of BI/DW architectures coordinated with Client
Bachelors degree in computer science or related field, or equivalent professional experience.
10+ years of experience developing relational database driven online applications
5+ years of Oracle/PL/SQL (Oracle10/11/12) experience
2+ years of SQL Server experience
Proven track record successfully developing Oracle database driven online applications that exceed expectations
Enjoy working in a highly collaborative, Agile-based software development environment
Very good understanding of database design, architecture, security & performance tuning
Ability to develop applications and enhancements from requirements defined not only in functional specifications but also in high level concept meetings Strong understanding of data models and the data dictionary without IDE assistance.
Ability to work effectively in a multi-cultural environment cross-organizationally with and without direct supervision.
Ability to troubleshoot and resolve technical & performance issues in production environment.
Ability to Develop ad-hoc queries and reports on demand with short turnaround times as determined by business priorities.
Advance level skills in PowerShell scripting.
Experience in Oracle APEX (web application development platform) a plus.
Technical understanding and development experience of BI/DW architectures
This individual will possess: the ability to work individually, within a team, and with other groups; strong written and verbal communication skills; a commitment to customer service; ability to work in a demanding, fast paced environment; record of keeping abreast of industry trends and changes in technologies; a concern for accuracy, details and quality; strong interpersonal skills; proven analytical and problem-solving abilities; highly self-motivated and self-directed.
Project management experience.
Higher education experience preferred but not required.
Demonstrated ability to learn new technologies.
This position will have a high impact across the client. Database integration, decisions, planning, and support will have a high impact for various research, education, business units across the Customer.
Data warehouse/ BI, SQL, PL/SQL, Oracle, HTML, XML