Data Warehouse Developer-W2 - eTek IT Services, Inc.

Job Description:

Responsibilities

• Support the Cost Transfer buildout process in Workday through data transformation exercises primarily performed in Oracle using PL/SQL

• Integration Support – Building out the selection criteria for the integration team to build the integrations into cost and then the process to consume the cost ledger results back into the managerial ledger.

• Data Model (FDM) support - Select and transform hierarchy data to be passed to Workday

• Data Enhancement (higher complexity) – Support the need to pass Essbase budget data to workday by building processes to allocated higher level budget data to bottom level GL Accounts and Cost Centers. Work with Essbase team to get daily data based on varying criteria.

• Data ingestion – Support Proof of concept of data delivery into Snowflake



This role will spend relatively little time in project management/ meetings and the majority of the work will be as an individual contributor.



Skills

• Intermediate to Advanced PL/SQL

• Excellent problem solving skills

• Essbase experience a plus but not required and can be trained

• Workday Prism or Snowflake experience a plus but not required and can be trained



• Responsible for all phases of the software development lifecycle (analysis, design, and implementation).

• Provide application development and maintenance for all phases of the software development lifecycle, including analysis, design, and implementation.

• Design and maintain complex ETL (Extract, Transform and Load) processes that load from both data files and other databases.

• Develop and maintain complex PL/SQL functions and procedures.

• Create and optimize complex SQL queries for reports and applications.

• Provide input to project plans that includes estimates of tasks, duties and technologies for future releases and write technical documentation.

• Provide end user support and problem diagnosis and resolution.

• Perform all assignments in accordance with ESH Q, Security, and business practice requirements and policies.

• Provide expert level development support of PL/SQL functions, procedures, and database architecture.

• Provide advanced SQL tuning skills to complex queries, ETL’s, and data processing.

• Provide advanced support towards the IT needs for financial and/or budget and planning applications.

Qualifications

• Broad experience developing and maintaining custom ETL scripts.

• Comprehensive knowledge and experience with relational database design, techniques, and development methodologies

• Broad experience using SQL, PL/SQL, and Oracle 11g or higher.

• Broad experience developing ETL processes within Oracle database environments and non-Oracle environments using SQL Server, MySQL, File Transfer, or similar technologies.

• Proficient interpersonal skills necessary to effectively collaborate as part of a cohesive development team working with multiple customers and organizations simultaneously with time constraints.

• Proficient written and verbal communication skills necessary to effectively prepare, present and explain technical information to others.

• Significant experience supporting financial and business applications.

• Advanced experience with SQL Tuning and ETL Optimization.

• Significant experience with data virtualization tools such as Denodo.