Data Warehouse Analyst

Data Warehouse Analyst jobs in Houston TX

  • Posted on

  • Job type

  • Job category

     Data Warehouse Analyst
  • Location

     Houston, TX
  • Qualification

  • Number Of Openings

  • Pay Rate

    DOE / Per Hour
  • Description

    Design, develop, test, maintain, and support batch applications using Oracle PL/SQL and Unix for Retail Commissions and Amortization.

  • Responsibilities

    • Must be Local local to Houston or willing to relocate to Houston
    • Must have Bachelor’s degree in computer science.
    • Develop Oracle PL/SQL packages, stored procedures, functions, objects, tables, views, synonyms based on requirements.
    • Unit test, System test, Integration test, and Parallel test of the Oracle PL/SQL code.
    • Optimize code by following performance tuning techniques considering the limitations of the current environment.
    • Ensure data produced matches the existing system or meets requirements by doing thorough testing so that any post-production issues are minimized.
    • Use analytics skills to troubleshoot and resolve problems quickly
    • Work with Team Lead and other members of the DW team to understand requirements, follow coding standards, identify source data, and do code reviews.
    • Work effectively in a team environment. Develop a strong working relationship with members of Oracle team, DBA team, and Business.
    • Monitor batch processes daily/weekly and resolve job failures as quickly as possible. Work with ControlM group on re-run/re-start instructions. Willingness to perform this off hours during weekdays and weekends.
    • Provide production support of the application and satisfy requests for data updates, ad-hoc reports or minor enhancements.
    • Communicate status and escalate issues or delays that would impact the deadline as early in the process as possible.