Data Modeling / JSON Data Designer

IBM Corporation

Contract Chicago , Illinois, United States Posted 5 years ago

 Write a Review Add Vendor   Add Contact  

About Position

Data Modeling / JSON Data Designer (Contract)

$90.00 / Hourly

Chicago , Illinois, United States

Data Modeling / JSON Data Designer

Contract Chicago , Illinois, United States Posted 5 years ago

Description

Skills JSON Data Designer Required Skills JSON Data Designer
Job Role Data Specialist
Skill Set Data Modeling JRSS Description Translates business needs into a data model, providing expertise on data modeling tools and techniques for designing data models for applications and related systems. Skills include logical and physical data modeling, and knowledge of ERWin, MDM, and/or ETL. Data modeling is a process used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations. Therefore, the process of data modeling involves professional data modelers working closely with business stakeholders, as well as potential users of the information system. There are three different types of data models produced while progressing from requirements to the actual database to be used for the information system.
The data requirements are initially recorded as a conceptual data model which is essentially a set of technology independent specifications about the data and is used to discuss initial requirements with the business stakeholders. The conceptual model is then translated into a logical data model, which documents structures of the data that can be implemented in databases. Implementation of one conceptual data model may require multiple logical data models. The last step in data modeling is transforming the logical data model to a physical data model that organizes the data into tables, and accounts for access, performance and storage details. Data modeling defines not just data elements, but also their structures and the relationships between them. Several techniques have been developed for the design of data models. While these methodologies guide data modelers in their work, two different people using the same methodology will often come up with very different results. There are several notations for data modeling. The actual model is frequently called Entity relationship model, because it depicts data in terms of the entities and relationships described in the data. An entityrelationship model (ERM) is an abstract conceptual representation of structured data. Most notable are Bachman diagrams, Barker's notation, Chen's Notation, Data Vault Modeling, Extended BackusNaur form, IDEF1X, Objectrelational mapping, ObjectRole Modeling, Relational Model, Relational Model/Tasmania.

By applying to a job using PingJob.com you are agreeing to comply with and be subject to the PingJob.com Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.

Questions / Comments:

Display Questions / Comments:

No Questions / comments

IBM Corporation Vendors

( Login to see all the 130 vendors)
Kforce Professional Staffing Firm
Write a Review

1001 E Palm Avenue
Tampa
Florida
www.kforce.com ( 82 vendors)

Wipro Technologies
Write a Review

1300 Crittenden Lane
Mountain View
California
www.wipro.com ( 61 vendors)

Ajilon Consulting
Write a Review

210 West Pennsylvania Avenue
Towson
Maryland
www.ajilonconsulting.com ( 47 vendors)

Job Summary

$90.00 / Hourly

Contract

Chicago , Illinois, United States

Experience Required : 6 Year/s

Posted : 5 years ago

Deadline : January 20, 2020 5 years ago

Job ID : Job0000018296

IBM Corporation

1133 Westchester Avenue

www.ibm.com/us

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.32PHP Version5.43sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (4.33s)time
    • Application (1.11s)time
    • 1 x Booting (79.66%)
      4.33s
      1 x Application (20.34%)
      1.11s
      3 templates were rendered
      • frontend.job-viewjob-view.blade.php#?blade
      • admin.flash_msgflash_msg.blade.php#?blade
      • layouts.themetheme.blade.php#?blade
      uri
      GET {slug}
      middleware
      web
      controller
      App\Http\Controllers\JobController@view
      namespace
      prefix
      where
      as
      job_view
      file
      app/Http/Controllers/JobController.php:482-507
      11 statements were executed468ms
      • JobController.php#484clientfyi_final34.93msselect * from `jobs` where `job_slug` = 'Job0000018296' limit 1
        Bindings
        • 0: Job0000018296
        Backtrace
        • app/Http/Controllers/JobController.php:484
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • User.php#78clientfyi_final273msselect `id`, `company` from `users` where `user_type` in ('employer', 'agent') order by `id` desc
        Bindings
        • 0: employer
        • 1: agent
        Backtrace
        • app/Models/User.php:78
        • app/Http/Controllers/JobController.php:491
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • JobController.php#493clientfyi_final24.79msselect * from `users` where `users`.`id` = 2669 limit 1
        Bindings
        • 0: 2669
        Backtrace
        • app/Http/Controllers/JobController.php:493
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • Vendor.php#57clientfyi_final6.83msselect count(*) as aggregate from `vendors` inner join `users` on `vendors`.`vendor_id` = `users`.`id` inner join `states` on `users`.`state_id` = `states`.`id` inner join `countries` on `states`.`country_id` = `countries`.`id` where `vendors`.`approve_status` = 1 and `vendors`.`employer_id` = 2669
        Bindings
        • 0: 1
        • 1: 2669
        Backtrace
        • app/Models/Vendor.php:57
        • app/Http/Controllers/JobController.php:495
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • Vendor.php#57clientfyi_final7.43msselect `vendors`.*, `users`.`website`, `users`.`company`, `users`.`address`, `users`.`city`, `states`.`state_name`, `countries`.`country_name`, (SELECT (SUM(ratings)/COUNT(id)) FROM reviews WHERE reviews.employer_id = vendors.vendor_id AND reviews.approve_status = 1) as review_rating, (SELECT COUNT(id) FROM reviews WHERE reviews.employer_id = vendors.vendor_id AND reviews.approve_status = 1) as review_count, (SELECT COUNT(id) FROM vendors as b WHERE b.employer_id = vendors.vendor_id) as vendor_count from `vendors` inner join `users` on `vendors`.`vendor_id` = `users`.`id` inner join `states` on `users`.`state_id` = `states`.`id` inner join `countries` on `states`.`country_id` = `countries`.`id` where `vendors`.`approve_status` = 1 and `vendors`.`employer_id` = 2669 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 2669
        Backtrace
        • app/Models/Vendor.php:57
        • app/Http/Controllers/JobController.php:495
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • JobController.php#500clientfyi_final400μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 2669
        Bindings
        • 0: 1
        • 1: 2669
        Backtrace
        • app/Http/Controllers/JobController.php:500
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • job-view.blade.php#17clientfyi_final8.44msselect DISTINCT email from `job_applications` where `category_id` = 99 and `status` = 1
        Bindings
        • 0: 99
        • 1: 1
        Backtrace
        • view::frontend.job-view:17
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • job-view.blade.php#450clientfyi_final1.61msselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 18296 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 18296
        Backtrace
        • view::frontend.job-view:450
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • theme.blade.php#101clientfyi_final750μsselect * from `categories` where `job_count` >= 1 order by `job_count` desc
        Bindings
        • 0: 1
        Backtrace
        • view::layouts.theme:101
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • theme.blade.php#102clientfyi_final52.91msSELECT jobs.state_id,jobs.state_name, COUNT(*) AS numberOfSales FROM jobs JOIN states ON states.id = jobs.state_id GROUP BY jobs.state_id,jobs.state_name ORDER BY COUNT(*) DESC limit 15
        Backtrace
        • view::layouts.theme:102
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • theme.blade.php#103clientfyi_final56.34msSELECT jobs.city_id,jobs.city_name, COUNT(*) AS numberOfcities FROM jobs JOIN cities ON cities.id = jobs.city_id GROUP BY jobs.city_id,jobs.city_name ORDER BY COUNT(*) DESC limit 15
        Backtrace
        • view::layouts.theme:103
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      App\Models\Category
      138Category.php#?
      App\Models\Job
      1Job.php#?
      App\Models\User
      1User.php#?
          _token
          VYPg8k1vcwfLx6cCAbo56fMjJWjgtVBrnPDOIuLB
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000018296" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000018296
          status_code
          200
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          request_request
          []
          request_headers
            0 of 0   
          array:25 [▼
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "3.144.222.234"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, br"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "cf-ray" => array:1 [▶
    0 => "92dca934af2d89f7-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.144.222.234"
  ]
  "x-real-ip" => array:1 [▶
    0 => "108.162.216.195"
  ]
  "host" => array:1 [▶
    0 => "pingjob.com"
  ]
]
          request_cookies
          []
          response_headers
            0 of 0   
          array:7 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "private, must-revalidate"
  ]
  "date" => array:1 [▶
    0 => "Wed, 09 Apr 2025 20:12:48 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InRja0d1TUdLWEJHaHpmNmhOYTdydmc9PSIsInZhbHVlIjoiNkd1bzJwNG5lTEhxQkdvRzBvV3o3N0dJM1ZiZmR0RUI2VFZuUDhMcDg2dUwyT1JMaXRreHcxYnRaeUtFbTFyOXZ3SkZod3drOGxRT09DTENzWVk1WjR3bzJiRnVCWXl3alRBS0R6Vmx1a2FpbUZBNGIxa3krbkxreU8zcGdhdEMiLCJtYWMiOiJlYTgwM2NkYzQ4ZjU1NmI2MGQ5NDcyMWI5NTZjM2ExYjBhMGI5ZTkwMzQxNTUzNGRhMDM0MDBlYmI4OGIzMjJmIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 22:12:49 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InRja0d1TUdLWEJHaHpmNmhOYTdydmc9PSIsInZhbHVlIjoiNkd1bzJwNG5lTEhxQkdvRzBvV3o3N0dJM1ZiZmR0RUI2VFZuUDhMcDg2dUwyT1JMaXRreHcxYnRaeUtFbTFyOXZ3SkZod ▶"
    1 => "laravel_session=eyJpdiI6IkpLV21FREhvMVdVV1VUZEltZVNPckE9PSIsInZhbHVlIjoiYWNra3NxZlBReGZkMmJONWtocnpGa3VsR0ZBZ3NqSkpOUlVZbFA2Sld6c2JZdGFFMXgwb1d5cVJYUW94Uit5UEVEcWhGdkdySW1SeWd4K3NIM2tkUGVybjRJTGNTdHhnd3dEMEJBOGVZT3lUd1JrNzV1V29UL0hjREZoeTV3cXUiLCJtYWMiOiIwNjFmNjJlMjZiMTE4M2MyZjkyYjAzOTM3ZDQ2MjFkZGI4MDU5ODRjMzQ5NGRlMGExOGUyMDZjNzllZmYwNWQ5IiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 22:12:49 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IkpLV21FREhvMVdVV1VUZEltZVNPckE9PSIsInZhbHVlIjoiYWNra3NxZlBReGZkMmJONWtocnpGa3VsR0ZBZ3NqSkpOUlVZbFA2Sld6c2JZdGFFMXgwb1d5cVJYUW94Uit5UEVE ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InRja0d1TUdLWEJHaHpmNmhOYTdydmc9PSIsInZhbHVlIjoiNkd1bzJwNG5lTEhxQkdvRzBvV3o3N0dJM1ZiZmR0RUI2VFZuUDhMcDg2dUwyT1JMaXRreHcxYnRaeUtFbTFyOXZ3SkZod3drOGxRT09DTENzWVk1WjR3bzJiRnVCWXl3alRBS0R6Vmx1a2FpbUZBNGIxa3krbkxreU8zcGdhdEMiLCJtYWMiOiJlYTgwM2NkYzQ4ZjU1NmI2MGQ5NDcyMWI5NTZjM2ExYjBhMGI5ZTkwMzQxNTUzNGRhMDM0MDBlYmI4OGIzMjJmIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 22:12:49 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InRja0d1TUdLWEJHaHpmNmhOYTdydmc9PSIsInZhbHVlIjoiNkd1bzJwNG5lTEhxQkdvRzBvV3o3N0dJM1ZiZmR0RUI2VFZuUDhMcDg2dUwyT1JMaXRreHcxYnRaeUtFbTFyOXZ3SkZod ▶"
    1 => "laravel_session=eyJpdiI6IkpLV21FREhvMVdVV1VUZEltZVNPckE9PSIsInZhbHVlIjoiYWNra3NxZlBReGZkMmJONWtocnpGa3VsR0ZBZ3NqSkpOUlVZbFA2Sld6c2JZdGFFMXgwb1d5cVJYUW94Uit5UEVEcWhGdkdySW1SeWd4K3NIM2tkUGVybjRJTGNTdHhnd3dEMEJBOGVZT3lUd1JrNzV1V29UL0hjREZoeTV3cXUiLCJtYWMiOiIwNjFmNjJlMjZiMTE4M2MyZjkyYjAzOTM3ZDQ2MjFkZGI4MDU5ODRjMzQ5NGRlMGExOGUyMDZjNzllZmYwNWQ5IiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 22:12:49 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IkpLV21FREhvMVdVV1VUZEltZVNPckE9PSIsInZhbHVlIjoiYWNra3NxZlBReGZkMmJONWtocnpGa3VsR0ZBZ3NqSkpOUlVZbFA2Sld6c2JZdGFFMXgwb1d5cVJYUW94Uit5UEVE ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "VYPg8k1vcwfLx6cCAbo56fMjJWjgtVBrnPDOIuLB"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/Job0000018296"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-09 20:12:49GET/Job0000018296311140