Informatica MDM Developer

Healthfirst

Contract New York, New York, United States Posted 4 years ago

 Write a Review Add Vendor   Add Contact  

About Position

Informatica MDM Developer (Contract)

$86.00 / Hourly

New York, New York, United States

Informatica MDM Developer

Contract New York, New York, United States Posted 4 years ago

Description

Skills Required 1.Informatica PowerCenter knowledge. Ability to understand mappings/workflows.
2.Informatica MDM knowledge. Understanding of Stage, Load, Match and Merge, BVT,SIF/Composite framework and other MDM topics.
3.Ability to write and understand complex oracle SQL queries for production issue analysis and resolution.
4.Understanding of oracle DB concepts indexes, explain plan etc.
5.Knowledge of Core Java/Web services/SOA. Experience on Soap UI/Postman/Eclipse tools.
6.Previous prod support experience. ITIL/Service now process knowledge.
7.Linux/Unix knowledge. Ability to understand Unix shell scripts. Basic shell commands.
8.Controlm or similar scheduler Knowledge.9.OnshoreOffshore coordination.
Skills Good to have 1.Informatica PowerCenter development experience.
2.Informatica data quality experience.
3.Mulesoft any point studio experience.
4.Healthcare domain knowledge.

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

Healthfirst Vendors

Virtusa
Write a Review

2000 West Park Drive
Westborough
Massachusetts
www.virtusa.com ( 3 vendors)

Job Summary

$86.00 / Hourly

Contract

New York, New York, United States

Experience Required : 7 Year/s

Posted : 4 years ago

Deadline : August 22, 2020 4 years ago

Job ID : Job0000021487

Healthfirst

PO Box 5183

www.healthfirst.org

Request history8.1.31PHP Version3.2sRequest Duration688MBMemory UsageGET {slug}Route
    • Booting (2.75s)time
    • Application (455ms)time
    • 1 x Booting (85.8%)
      2.75s
      1 x Application (14.2%)
      455ms
      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 executed213ms
      • JobController.php#484clientfyi_final32.87msselect * from `jobs` where `job_slug` = 'Job0000021487' limit 1
        Bindings
        • 0: Job0000021487
        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_final82.1msselect `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_final630μsselect * from `users` where `users`.`id` = 19727 limit 1
        Bindings
        • 0: 19727
        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_final450μ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` = 19727
        Bindings
        • 0: 1
        • 1: 19727
        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_final810μsselect `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` = 19727 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 19727
        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_final320μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 19727
        Bindings
        • 0: 1
        • 1: 19727
        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.76msselect 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_final420μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 21487 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 21487
        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_final890μ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_final45.13msSELECT 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_final40.22msSELECT 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
          tRdinpq4dJArclTCzgVOVfsq2a9x0twipMrlhgzv
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000021487" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000021487
          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.142.220.14" ] "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 => "91a50b982c10e7f4-ORD" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-forwarded-for" => array:1 [ 0 => "3.142.220.14" ] "x-real-ip" => array:1 [ 0 => "172.70.100.153" ] "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 => "Mon, 03 Mar 2025 00:33:59 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjI1VWxRaEtOd01OeXc5ZTNXMUZMakE9PSIsInZhbHVlIjoiRTJDWDlTMlAxN1UzbklscGs3TktRa0pKRVBDTmhycTM3ZnMwcHBRc0tVT0g5YnoxVE9KTGtYTU8wWExuYWlBQXlwVjdEemdIKzVVb0x4Z3hxKzNkSEhleC8rbktFZG1IY0FMRk9BWHhvcVpPWjRzS0NML3RpemNJVUdUbEJ0VXEiLCJtYWMiOiI2YzMwMjBiZDlmZTJlMjJkNGMxY2E0YWEzZjI5ZGVmNDRhODAzYzFhMDhiYTEzMzc5ZjVlYzhmNGNlMmExMTNiIiwidGFnIjoiIn0%3D; expires=Mon, 03 Mar 2025 02:33:59 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjI1VWxRaEtOd01OeXc5ZTNXMUZMakE9PSIsInZhbHVlIjoiRTJDWDlTMlAxN1UzbklscGs3TktRa0pKRVBDTmhycTM3ZnMwcHBRc0tVT0g5YnoxVE9KTGtYTU8wWExuYWlBQXlwVjdEe" 1 => "laravel_session=eyJpdiI6Im5wZHhyYWtXaXhra3Uvd1FSejIvZHc9PSIsInZhbHVlIjoiY2plbi9BV2dqYVMzNDU4c2tZSmx6d3cveW15QUpUejZJTFRTZUtnaml6Q3Fsbk9WaW1lTWlreldLNS93N1M1aDE2SldMb3FNbXNaS09yYXljeXl2RXpPWWN4MVR2bzJCNzgzVTU0YlBGRmwvM2tUK2hhY2xQS3FYWDV0ZERJL1YiLCJtYWMiOiI0YjM4MzIxM2YzYmY3MTM1NzdiODM5ZGFlMWFkYTk0MDg3OTBmMTIwNGFjNzc2MGE0MzJjZDAxYjgyMDViNGIxIiwidGFnIjoiIn0%3D; expires=Mon, 03 Mar 2025 02:33:59 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6Im5wZHhyYWtXaXhra3Uvd1FSejIvZHc9PSIsInZhbHVlIjoiY2plbi9BV2dqYVMzNDU4c2tZSmx6d3cveW15QUpUejZJTFRTZUtnaml6Q3Fsbk9WaW1lTWlreldLNS93N1M1aDE2" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjI1VWxRaEtOd01OeXc5ZTNXMUZMakE9PSIsInZhbHVlIjoiRTJDWDlTMlAxN1UzbklscGs3TktRa0pKRVBDTmhycTM3ZnMwcHBRc0tVT0g5YnoxVE9KTGtYTU8wWExuYWlBQXlwVjdEemdIKzVVb0x4Z3hxKzNkSEhleC8rbktFZG1IY0FMRk9BWHhvcVpPWjRzS0NML3RpemNJVUdUbEJ0VXEiLCJtYWMiOiI2YzMwMjBiZDlmZTJlMjJkNGMxY2E0YWEzZjI5ZGVmNDRhODAzYzFhMDhiYTEzMzc5ZjVlYzhmNGNlMmExMTNiIiwidGFnIjoiIn0%3D; expires=Mon, 03-Mar-2025 02:33:59 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjI1VWxRaEtOd01OeXc5ZTNXMUZMakE9PSIsInZhbHVlIjoiRTJDWDlTMlAxN1UzbklscGs3TktRa0pKRVBDTmhycTM3ZnMwcHBRc0tVT0g5YnoxVE9KTGtYTU8wWExuYWlBQXlwVjdEe" 1 => "laravel_session=eyJpdiI6Im5wZHhyYWtXaXhra3Uvd1FSejIvZHc9PSIsInZhbHVlIjoiY2plbi9BV2dqYVMzNDU4c2tZSmx6d3cveW15QUpUejZJTFRTZUtnaml6Q3Fsbk9WaW1lTWlreldLNS93N1M1aDE2SldMb3FNbXNaS09yYXljeXl2RXpPWWN4MVR2bzJCNzgzVTU0YlBGRmwvM2tUK2hhY2xQS3FYWDV0ZERJL1YiLCJtYWMiOiI0YjM4MzIxM2YzYmY3MTM1NzdiODM5ZGFlMWFkYTk0MDg3OTBmMTIwNGFjNzc2MGE0MzJjZDAxYjgyMDViNGIxIiwidGFnIjoiIn0%3D; expires=Mon, 03-Mar-2025 02:33:59 GMT; path=/; httponlylaravel_session=eyJpdiI6Im5wZHhyYWtXaXhra3Uvd1FSejIvZHc9PSIsInZhbHVlIjoiY2plbi9BV2dqYVMzNDU4c2tZSmx6d3cveW15QUpUejZJTFRTZUtnaml6Q3Fsbk9WaW1lTWlreldLNS93N1M1aDE2" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "tRdinpq4dJArclTCzgVOVfsq2a9x0twipMrlhgzv" "_previous" => array:1 [ "url" => "https://pingjob.com/Job0000021487" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-03-03 00:33:59GET/Job0000021487311140