Job Details

ID #49573505
State North Carolina
City Charlotte
Job type Contract
Salary USD USD60 - USD70 USD60 - USD70
Source Randstad Technologies
Showed 2023-03-28
Date 2023-03-28
Deadline 2023-05-27
Category Et cetera
Create resume

Oracle SQL / Hadoop Developer

North Carolina, Charlotte, 28255 Charlotte USA

Vacancy expired!

job summary:

Summary

  • Work with Product Managers/Owners and the Development community to ensure the robust data warehousing solutions are delivered
  • Develop Conceptual/Logical/Physical data models in line with business requirements
  • Ensure data models developed meet appropriate standards and principles
  • Ensure data models are documented, communicated, updated, and centrally managed in an appropriate manner
  • Design technical data solutions meeting business requirements and providing guidance to development teams.

Primary Skill

  • Oracle SQL / PLSQL

Secondary Skill

  • Hadoop

Tertiary Skill

  • Data modelling and architecture

Required Skills

  • Expertise in Data Modelling, including Conceptual, Logical and Physical modelling for Enterprise-level Data Stores
  • Good understanding of different data modelling techniques - 3NF, Dimensional and Data Vault.
  • Ability to think strategically about business, product, and technical challenges in an enterprise environment.
  • Understanding of database and analytical technologies in the industry including MPP and NoSQL databases, Data Warehouse design, BI reporting, and Dashboard development.
  • Knowledge of payments industry data standards is highly desirable, including ISO 20022, as well as regulatory experience within Payments.
  • Excellent problem solving and communication skills; experience in interacting with technical and non-technical stakeholders at all levels.
  • Ability to clearly communicate complex technical ideas, regardless of the technical capacity of the audience
  • Experience in reverse-engineering of data models.
  • Ability to troubleshoot complex SQL queries implemented as part of ETL code
  • Ability to utilize Business Intelligence tools (Power BI, Tableau, etc.) to represent insights
  • Excellent problem solving and communication skills; experience in interacting with technical and non-technical stakeholders at all levels.

Technical Skills:

  • Data Architecture - Data Warehouse, Data Mart, ODS, ETL, reporting, analytics
  • Understanding of Apache Hadoop and the Hadoop ecosystem.
  • Significant exposure to relational and NoSQL design methodologies.
  • Understand common integration services: REST API exposure.
  • Data analysis and modelling tools (e.g., Power Designer, Erwin, etc.)
  • SQL and/or PL/SQL hands-on experience
  • RDBMS platforms (e.g., SQL Server, Oracle, Netezza, Teradata, DB2 / UDB)
  • NoSQL databases (MongoDB, Elasticsearch, etc)
  • BI Tools (MSTR/Tableau/Kibana)
  • Microsoft Excel, Word, Power Point and Visio
  • Specialist skillsets: Oracle, Agile, Hadoop, Java

Desired Skills

  • inter-personal skills and ability to work as part of a team

location: Charlotte, North Carolina

job type: Contract

salary: $60 - 70 per hour

work hours: 8am to 5pm

education: Bachelors

responsibilities:

  • Work with Product Managers/Owners and the Development community to ensure the robust data warehousing solutions are delivered
  • Develop Conceptual/Logical/Physical data models in line with business requirements
  • Ensure data models developed meet appropriate standards and principles
  • Ensure data models are documented, communicated, updated, and centrally managed in an appropriate manner
  • Design technical data solutions meeting business requirements and providing guidance to development teams.

qualifications:

  • Experience level: Experienced
  • Minimum 3 years of experience
  • Education: Bachelors

skills:
  • Oracle
  • Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

    At Randstad, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).

    For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information.

    Vacancy expired!

    Subscribe Report job