Informatica ETL Developer

Chicago Mercantile Exchange

Contract Chicago , Illinois, United States Posted 7 years ago

 Write a Review Add Vendor   Add Contact  

About Position

Informatica ETL Developer (Contract)

$35.00 / Hourly

Chicago , Illinois, United States

Informatica ETL Developer

Contract Chicago , Illinois, United States Posted 7 years ago

Description

The ETL Developer role will help with developing the foundational technical architecture support for deploying a new Informatica environment in Informatica 8.3. This person will also play a key role in developing the data integration solutions for the NYMEX integration. Individual will be responsible for developing ETL mappings for STATS mainframe elimination project using Informatica. Person should have strong background in Data Warehousing, dimensional modeling and Oracle (PL/SQL) development to integrate Informatica processes to work in conjunction with existing PL/SQL ETL processes.ResponsibilitiesIntegration Tasks Design strategy to integrate Nymex fee and volume data into CME Groups data warehouse Develop ETL maps using Informatica to integrate Nymex fee and volume data Develop process to move Informatica packages from Dev to QA and Production. Standards Development Document Create Best Practices document for transformation usage Document best practices for tool usage strategy comparing Java, PL/SQL vs. Informatica Document Create ETL Standards Naming Conventions Map Design Standards Metadata Management Standards Best practices for handling slowly changing dimensions Infrastructure/Production Support Tasks Develop Disaster Recovery Develop restart recovery processes and procedures Document Repository Setup and usage Standards and Mapping Standards Develop code migration standards and procedures Support Environment Migrations Document Security Architecture Development Support Task Development and manage cross team scheduling standards and thread management (Manage Cross Team Runbook) Develop Shared components Develop File Management and Input/Output Feed hub Develop Batch control processes Design/Develop Shared Error/exception/reject management handling Develop Target Record Deletion Process Design and Develop shared maplets for time, input/batch control, load processes Skill sets required 4+ Years developing Informatica solutions in a Unix/Linux environment Experience with high volume datasets from various sources (Cobol, Text Files, XML, Relational) Experience with multithreading and parallel processing using Informatica Experience with common Data Warehousing terminology Experience using Informatica integrated with web services Experience in developing and documenting environment setup processes, procedures and shared components Experience supporting multiteam environments Experience with general scheduling tools such as UC4

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

Chicago Mercantile Exchange Vendors

( Login to see all the 8 vendors)
TEK Systems
Write a Review

971 Corporate Boulevard
Linthicum
Maryland
www.teksystems.com ( 85 vendors)

Starpoint Solutions
Write a Review

115 Broadway, 2nd Floor
Watertown
New York
www.starpoint.com ( 12 vendors)

Akraya Inc
Write a Review

2160 Lundy Avenue #200
San Jose
California
www.Akraya.com ( No vendors )

Job Summary

$35.00 / Hourly

Contract

Chicago , Illinois, United States

Experience Required : 3 Year/s

Posted : 7 years ago

Deadline : October 30, 2017 7 years ago

Job ID : Job0000011305

Chicago Mercantile Exchange

30 S Wacker Dr

312-930-1000

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.31PHP Version3.97sRequest Duration689MBMemory UsageGET {slug}Route
    • Booting (3.23s)time
    • Application (740ms)time
    • 1 x Booting (81.36%)
      3.23s
      1 x Application (18.64%)
      740ms
      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 executed336ms
      • JobController.php#484clientfyi_final19.41msselect * from `jobs` where `job_slug` = 'Job0000011305' limit 1
        Bindings
        • 0: Job0000011305
        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_final159msselect `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_final920μsselect * from `users` where `users`.`id` = 28950 limit 1
        Bindings
        • 0: 28950
        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_final910μsselect 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` = 28950
        Bindings
        • 0: 1
        • 1: 28950
        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_final1.69msselect `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` = 28950 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 28950
        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_final450μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 28950
        Bindings
        • 0: 1
        • 1: 28950
        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_final10.68msselect DISTINCT email from `job_applications` where `category_id` = 61 and `status` = 1
        Bindings
        • 0: 61
        • 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_final750μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 11305 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 11305
        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_final1.09msselect * 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_final69.78msSELECT 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_final70.62msSELECT 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
          5nybUgZ9sutgQq5GN5kI4NkwRyJneKCXRSO4A9VS
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000011305" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000011305
          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"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "3.22.235.243"
  ]
  "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"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "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 => "91b554a2bc001136-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.22.235.243"
  ]
  "x-real-ip" => array:1 [▶
    0 => "172.69.59.82"
  ]
  "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, 05 Mar 2025 00:00:03 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkIvUkZVbTdsUllONms1MVczNDVLV1E9PSIsInZhbHVlIjoiaDhiMGM0dkRuclo5SW9ITlMzdFg1d3JjREpjQkt2aGs4OHczMS9ncFFrbEhNT04zblkyb0M0dkZEZEtObmh4YVFpdTU3N0hLMHpJc2ZlbGNtNEgxSXhJWkZsVk1Sb1M1R0xNMDBWTDZib0orR1ltZ2FHNm1ZMWgxd05oTlNkcVEiLCJtYWMiOiJjZDJhNWJiNjExZTU1MDY2YTYyMjA4Y2I2ZThjMDZkNzBmNTdlNDVhZDY1Y2ZlYjY4MDJhMGU0NzY0MWExYTNjIiwidGFnIjoiIn0%3D; expires=Wed, 05 Mar 2025 02:00:04 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkIvUkZVbTdsUllONms1MVczNDVLV1E9PSIsInZhbHVlIjoiaDhiMGM0dkRuclo5SW9ITlMzdFg1d3JjREpjQkt2aGs4OHczMS9ncFFrbEhNT04zblkyb0M0dkZEZEtObmh4YVFpdTU3N ▶"
    1 => "laravel_session=eyJpdiI6Inp2UkdsOXNleDlQampQdDYvMHlDeVE9PSIsInZhbHVlIjoiMHVPdDB2aWhZNk5PODhrNE1tQk1QZElyYVdPcFNMOGwxSUpoOWlsUkpJVjRSNVh5RVZZcDVLZDVjeHlYTGRCcXVHWFV0dGU3Y1VabkZXZnNxekg4RGFnYXF6WnlSOHpQSDdEL1BMd2JvUmc4cEdRZHNQQVN1emNLSEJwR0JvaWciLCJtYWMiOiI4MzRhNTUyZTY5ZmU1MTUyYjkwMzk2YTdkNjU0Njc4NmE3NDg0MGVjYTkyZDlhZDhmZmNjMmMzNTc3YTIwNjE0IiwidGFnIjoiIn0%3D; expires=Wed, 05 Mar 2025 02:00:04 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6Inp2UkdsOXNleDlQampQdDYvMHlDeVE9PSIsInZhbHVlIjoiMHVPdDB2aWhZNk5PODhrNE1tQk1QZElyYVdPcFNMOGwxSUpoOWlsUkpJVjRSNVh5RVZZcDVLZDVjeHlYTGRCcXVH ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkIvUkZVbTdsUllONms1MVczNDVLV1E9PSIsInZhbHVlIjoiaDhiMGM0dkRuclo5SW9ITlMzdFg1d3JjREpjQkt2aGs4OHczMS9ncFFrbEhNT04zblkyb0M0dkZEZEtObmh4YVFpdTU3N0hLMHpJc2ZlbGNtNEgxSXhJWkZsVk1Sb1M1R0xNMDBWTDZib0orR1ltZ2FHNm1ZMWgxd05oTlNkcVEiLCJtYWMiOiJjZDJhNWJiNjExZTU1MDY2YTYyMjA4Y2I2ZThjMDZkNzBmNTdlNDVhZDY1Y2ZlYjY4MDJhMGU0NzY0MWExYTNjIiwidGFnIjoiIn0%3D; expires=Wed, 05-Mar-2025 02:00:04 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IkIvUkZVbTdsUllONms1MVczNDVLV1E9PSIsInZhbHVlIjoiaDhiMGM0dkRuclo5SW9ITlMzdFg1d3JjREpjQkt2aGs4OHczMS9ncFFrbEhNT04zblkyb0M0dkZEZEtObmh4YVFpdTU3N ▶"
    1 => "laravel_session=eyJpdiI6Inp2UkdsOXNleDlQampQdDYvMHlDeVE9PSIsInZhbHVlIjoiMHVPdDB2aWhZNk5PODhrNE1tQk1QZElyYVdPcFNMOGwxSUpoOWlsUkpJVjRSNVh5RVZZcDVLZDVjeHlYTGRCcXVHWFV0dGU3Y1VabkZXZnNxekg4RGFnYXF6WnlSOHpQSDdEL1BMd2JvUmc4cEdRZHNQQVN1emNLSEJwR0JvaWciLCJtYWMiOiI4MzRhNTUyZTY5ZmU1MTUyYjkwMzk2YTdkNjU0Njc4NmE3NDg0MGVjYTkyZDlhZDhmZmNjMmMzNTc3YTIwNjE0IiwidGFnIjoiIn0%3D; expires=Wed, 05-Mar-2025 02:00:04 GMT; path=/; httponly ◀laravel_session=eyJpdiI6Inp2UkdsOXNleDlQampQdDYvMHlDeVE9PSIsInZhbHVlIjoiMHVPdDB2aWhZNk5PODhrNE1tQk1QZElyYVdPcFNMOGwxSUpoOWlsUkpJVjRSNVh5RVZZcDVLZDVjeHlYTGRCcXVH ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "5nybUgZ9sutgQq5GN5kI4NkwRyJneKCXRSO4A9VS"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/Job0000011305"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-03-05 00:00:04GET/Job0000011305311140