Get your dream job within 2 days (HURRY UP)ENROLL NOW
+

Database Developer/Architect


Job Id : 8175

Jobtitle : Database Developer/Architect

Location : Menands, NY

Company Name : HexaCorp LLC

Industry : Information Technology

Salary : $28,000 - $84,000  YEAR

Job type : Fulltime

Posted on: 2019-12-02


Required Skills : SQL, ETL, Informatica, Business Intelligence, Sybase, Pentaho, ErWin

Benefits : No benefits are available


Job Description:

  • This project will focus on the migration of SybaseIQ to MS SQL Server and Oracle databases.
  • It will also focus on the conversion of PowerBuilder Reports to Oracle Business Intelligence Enterprise Edition (OBIEE).
  • The current version of Sybase is no longer supported, and there is no support/maintenance contract between client and [Sybase].   Also, Sybase will not be supported at the ITS Enterprise level.

 

Tasks will include but not limited to the following:

The Database Architect will participate in a team approach to:

  • Work with SMEs, Business Analysts and Technology teams to understand the data requirements and the full attribute set for entities and dimensions;
  • Convert business processes, domain specific knowledge, and information needs into a conceptual model;
  • Convert conceptual models into logical models with detailed descriptions of entities and dimensions;
  • Develop and maintain fully defined conceptual, logical and physical dimensional data models to ensure the information models are capable of meeting end user and developer needs;
  • Develop data models and data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema, etc.
  • Model aggregation layers and specific star schemas as subject areas within a logical and physical model
  • Understand and meet referential data integrity requirements Document decisions made in meetings and alternative solutions discussed.

 

Requested Qualification:

  • Experience with developing and maintaining logical and physical dimensional data models, building data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema, etc. in a data warehouse/business intelligence environment
  • Experience with data modeling using ErWin.
  • Experience in relational data management disciplines and design and development experience using Oracle and Sybase database technologies.
  • Experience with utilizing SQL programming for data analysis purposes in a data warehouse/business intelligence environment.
  • Experience with designing, developing and creating solutions in a health care business intelligence reporting environment.
  • Experience with ETL tools Informatica
  • Experience with reviewing the data modeling of others for compliance and accepted standards of development.
  • Experience with Pentaho

 

 

Latest jobs for you

  • SailPoint Developer - OPT/H1B/C2C

    Techginia INC Minneapolis, MN

    Job Description: We are looking for a SailPoint Lead/Developer from Information Technology & ...

    View Job
  • Oracle EBS Cloud / Lead - OPT/H1B

    keybusinessglobal.com Secaucus, NJ

    Job Description: Senior Level Technical Lead with hands-on and leadership experience managing ...

    View Job
  • AS/400 Developer - OPT

    K Anand Corporation Houston, Texas

    Job Description: Migrate AS400 servers from IBM Data center to Equinix ...

    View Job
  • Java Developer+ Master Data Services (MDS) OPT/H1B

    Xiartech Mountain View, CA

    Required Qualifications: Java experience (primary skill set) Strong Java experience and ...

    View Job
  • Embedded Developer - OPT/H1B

    Aristasys Peachtree City, GA

    Job Description: Skill Level, Years: 2-4+ Programming Languages: C/C++ OS: Android ...

    View Job

Thanks For Your Feedback

We’re an equal opportunity provider.
All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
OPTnation.com is not a Consulting Company/Training Company/H1B Sponsor.

Attach A Resume First