W-2 Jobs Portal

  • W-2 Open Positions Need to be Filled Immediately. Consultant must be on our company payroll, Corp-to-Corp (C2C) is not allowed.
Candidates encouraged to apply directly using this portal. We do not accept resumes from other company/ third-party recruiters

Job Overview

  • Job ID:

    J36993

  • Specialized Area:

    Hadoop & Big Data

  • Job Title:

    Informatica Developer Data Analyst

  • Location:

    Leawood,KS

  • Duration:

    7 Months

  • Domain Exposure:

    Government, Telecom, Education, IT/Software

  • Work Authorization:

    US Citizen, Green Card, OPT-EAD, CPT, H-1B,
    H4-EAD, L2-EAD, GC-EAD

  • Client:

    To Be Discussed Later

  • Employment Type:

    W-2 (Consultant must be on our company payroll. C2C is not allowed)




Job Description

Responsibilities

  • Assist in converting the existing OBIA (Oracle Business Intelligence Applications)/Informatica data warehouse into SQL Server because the OBIA platform is nearing its end-of-life.

Requirements

  • Key requirement is someone with proven experience in Oracle ERP, OBIA Warehouse/Informatica development, as well as data modeling for a data warehouse.
  • In-depth knowledge of the Oracle ERP (Finance, and HR) concepts and OBIA warehouse solution.
  • Deep understanding of conceptual, logical, and physical entity-relationship and data flow modeling.
  • Deep understanding of EAI (Enterprise Application integration) data flow concepts.
  • Deep understanding of API (Application Programming Interface) data flow concepts.
  • Strong SQL skills including SQL Server and Netezza (PDA) technology; writing/updating complex stored procedures, views, and DML.
  • Proficiency in data modeling for real-time transactional systems.
  • Proficiency in data modeling using transactional and dimensional data warehouse concepts.
  • Proficiency in creating mapping documents including tables, files, and XML Schema from source-to-target.
  • Proficiency in Master Data Management (MDM) concepts surrounding locations, films, customers, and products.
  • Ability to reverse- and forward-engineer relational databases MS SQL Server, Oracle, and Netezza.
  • Ability to reverse- and forward-engineer XSD and XML constructs.

Apply Now
Equal Opportunity Employer

DIGITAL TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. DIGITAL TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will DIGITAL TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract