Back to Job Search

Technology - Data Warehouse Specialist (Remote)

  • Location: Jacksonville, 32202
  • Job Type:Contract

Posted 12 days ago

Our client is seeking a Technology - Data Warehouse Specialist for a contract job opportunity! 

TITLE: Technology - Data Warehouse Specialist
TERM: 12 Months Duration
LOCATION: Jacksonville, FL / Remote 


Qualifications:
  • 4-6 years of experience in ETL Development utilizing Informatica DEI Developer/IICS (Informatica PowerCenter Experience will be considered)
  • 4-6 years of Informatica PowerExchange Development Experience
  • Strong SQL expertise
  • Strong understanding of Database Concepts and experience in Oracle 19c Database framework (PL/SQL, Stored Procedures, etc.)
  • Strong analytical and problem solving skills.
  • Strong understanding of ETL Development best practices and Star Schema Designs 1
  • Experience in performance tuning in SQL and Informatica Toolsets (DEI Developer, IICS).
  • Proven ability to work independently in a dynamic environment with multiple assigned projects and tasks.
  • Outstanding ability to communicate, both verbally and in writing.
Responsibilities and Expectations for the Role:
  • Assist with overall analysis, design and development of ETL processes to support project requirements
  • Document new designs and/or changes utilizing Microsoft Word
  • Analyze code developed in Oracle stored procedures and/or packages and re-write and/or modify code as necessary utilizing the Informatica DEI Developer/IICS platform
  • Develop Informatica DEI Developer/IICS mappings, SQL/stored procedures as well as data maps for PowerExchange
  • Performs unit testing, QA, and work with business partners and other developers to resolve any issues discovered during UAT
  • Review ETL performance and conducts performance tuning as required on mappings / workflows or SQL.
  • Serve as Informatica DEI Developer/IICS Tool SME by assisting other developers with general questions about the tool
  • Works with DBA/Application Administrator, as needed, to promote mappings/workflows between Development and QA environment

Apply with MATRIX today! 

Candidates will be responsible for following the client's COVID-19 protocols. Please refer to your MATRIX representative for specifics.

About Us

At MATRIX, we expertly match talented professionals with job opportunities to elevate careers. Since 1983, we have placed thousands of professionals at innovative clients across every industry ranging from small startups to Fortune 50 companies. It’s why we’re consistently in the top 25 of all U.S. IT staffing firms and why our consultants rate us well above the industry average, earning us ClearlyRated's Best of Staffing awards year after year. People come to us for a job, and stay with us because of our top-notch consultant care.

MATRIX is and Equal Employment Opportunity employer and provides reasonable accommodations for qualified individuals.  Supporting medical or religious documentation will be required where applicable. If you are a qualified individual with a disability, you may request a reasonable accommodation under the American Disability Act (ADA) by emailing MATRIX_HR@MatrixRes.com. To ensure a quick response to your request, please use the words “Accommodation request” as the subject line of your email.