Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Data Warehousing SQL Experience Relational Database UnixLinux Powerpoint Word And E
 
Requirement id 114289
Job title Specialist
Job location in Columbus, OH
Skills required Informatica Power Center, Data Warehousing, ETL Design And Documentation, SQL Experience Relational Database UnixL
Open Date 22-Feb-2021
Close Date
Job type Contract
Duration 4 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: coolsoft
Job Description Specialist: Informatica Power Center, Data Warehousing, ETL Design And Documentation, SQL Experience Relational Database UnixL

start date:03/08/2021

End date:06/30/2021

submission deadline: Wednesday 2/24 @ 10 am EST.




Note:

* Interviews: vis TEAMS

Description:


The Technical Specialist will be responsible for Medicaid Enterprise data warehouse design, development, implementation, migration, maintenance and operation activities. Works closely with Data Governance and Analytics team. The candidate will work closely with Data Governance and Analytics team. Will be one of the key technical resource for data warehouse projects for various Enterprise data warehouse projects and building critical data marts, data ingestion to Big Data platform for data analytics and exchange with State and Medicaid partners. This position is a member of Medicaid ITS and works closely with the Business Intelligence & Data Analytics team.

Responsibilities:

• Participate in Team activities, Design discussions, Stand up meetings and planning Review with team.

• Perform data analysis, data profiling, data quality and data ingestion in various layers using Database queries, Informatica PowerCenter, Informatica Analyst score cards, Pyspark programs and UNIX shell scripts.

• Follow the organization coding standard document, Create mappings, sessions and workflows as per the mapping specification document.

• Updating the production support Run book, Control M schedule document as per the production release.

• Create and update design documents, provide detail description about workflows after every production release.

• Continuously monitor the production data loads, fix the issues, update the tracker document with the issues, Identify the performance issues.

• Performance tuning long running ETL jobs by creating partitions, enabling bulk load, increasing commit interval and other standard approaches.

• Perform Quality assurance check, Reconciliation post data loads and communicate to vendor for receiving fixed data.

• Participate in ETL code review and design re-usable frameworks.

• Create Pyspark programs to ingest historical and incremental data.

• Create SQOOP scripts to ingest historical data from EDW oracle database to Hadoop IOP, created HIVE tables and Impala views creation scripts for Dimension tables.

• Writing complex SQL queries and performed tuning based on the explain plan results.

• Extract unstructured and semi-structured data using data processor transformation in IDQ.

• Participate in meetings to continuously upgrade the Functional and technical expertise.


Detailed Day-To-Day Job Duties to be performed:

Responsibilities:

• Participate in Team activities, Design discussions, Stand up meetings and planning Review with team.

• Perform data analysis, data profiling, data quality and data ingestion in various layers using Database queries, Informatica PowerCenter, Informatica Analyst score cards, Pyspark programs and UNIX shell scripts.

• Follow the organization coding standard document, Create mappings, sessions and workflows as per the mapping specification document.

• Perform Gap and impact analysis of ETL and IOP jobs for the new requirement and enhancements.

• Create jobs in Informatica PowerCenter, Informatica Developer IDQ, Hadoop using SQOOP, PYSPARK and Stream Sets to meet the business user needs.

• Create mockup data, perform Unit testing and capture the result sets against the jobs developed in lower environment.

• Updating the production support Run book, Control M schedule document as per the production release.

• Create and update design documents, provide detail description about workflows after every production release.

• Continu
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 114289 while calling.
 
Other jobs in OH: Cincinnati (1), Cleveland (1), Columbus (233), Dublin (8), Solon (2),
Informatica Power Center job openings in Columbus, OH
Jobs List

Informatica Developer - 10018
Create date: 14-May-2018
Client Info : Nationwide Insurance

Informatica Developer contractor with the following skill set:

Required:

Informatica PowerCenter (3+ Years)
Database SQL (3+ Years)
GIT

Nice to Have:

ESP (Scheduling Tool)
UNIX (Shell Scripting)
Reporting Tool (BO,.... (This job is for - GIT Jobs in OH Columbus Developer - (in Columbus, OH))

ETL Developer - 7901
Create date: 20-Oct-2017
Informatica PowerCenter / ETL
SQL
Agile
Nice to Have:
ESP or other scheduling tools
Ruby (This job is for - ETL Jobs in OH Columbus Developer - (in Columbus, OH))

ETL Developer - 7895
Create date: 20-Oct-2017
Informatica PowerCenter / ETL
SQL
Agile
Nice to Have:
ESP or other scheduling tools
Ruby (This job is for - ETL Jobs in OH Columbus Developer - (in Columbus, OH))
 
 Informatica Power Center job openings in other states
Jobs List

Data Warehouse Developer III - 105096 - SP
Create date: 01-Jun-2022
start date:7/1/2022
End date:06/30/2023

submission deadline:6/3/2022 4:00PM CST.

client info : DOT

Note:

* Interview Process: Teams with video on - one hour interview.

* Duration: Thru 6/30/2023 - Possibility of extension

* Local candidates or willing to relocate at the candid.... (This job is for - Kimball Jobs in WI Madison Developer - (in Madison, WI))

MHBE RFR090721 MD78 Senior Systems Analyst Operations -SP
Create date: 07-Sep-2021
Note: Email Submission

Submission Deadline: 9/21/2021 12:00 p.m. EST
Start Date: 10/1/2021
End Date : 6/30/2022

Client: Maryland Health Benefit Exchange (MHBE)

Description:

The Maryland Health Benefit Exchange (MHBE), an independent unit of state government, provides accessible, affordable heal.... (This job is for - AWS Jobs in MD Baltimore Analyst - (in Baltimore, MD))

52908096R2 System Analyst 3 -SP
Create date: 02-Mar-2020
Note: Online Submission
Note: Total estimated hours per Candidate shall not exceed 1000 hours.

Submission Deadline: 3/9/2020 5:00 PM CT
Start Date: 4/1/2020
End Date: 8/31/2020

Client: Texas Health and Human Services Commission

Description:

Texas Health and Human Services Commission require.... (This job is for - Unix Linux Jobs in TX Austin Analyst - (in Austin, TX))

Informatica Administrator - J-11-465-923
Create date: 29-Jan-2020
Description/Comment: H&PS
Provides experienced technical support for Informatica PowerCenter, Enterprise Data Catalog, and Data Quality as well as other commercial-off-the-shelf (COTS) products implemented to support Texas Medicaid Data and Analytics functions.
Responsibilities include:
Implementing, managing and administering Inform.... (This job is for - COTS Jobs in TX AUSTIN Administrator - (in Austin, TX))

ETL Developer - 54555
Create date: 23-Oct-2019
Job Description :

Description:

Follows company software development lifecycle to design, code, configure, test, debug, and document system and application programs. Assists in preparing technical design specifications based on functional requirements and analysis documents. Reviews functional requirements, analysis and design .... (This job is for - Analysis Design Jobs in IL Bloomington Developer - (in BLOOMINGTON, IL))
 
 Informatica Power Center job openings in OH
Jobs List

Data Analyst - 36295
Create date: 06-Jul-2018
Position Description:

The Data Analyst is responsible for discovery and documentation of data sets and data integrations. Work will be focused on identifying redundancies for consolidation, finding opportunities to streamline processing, and exposing flows via the Data Catalog. Additionally, areas to enhance Integrations with Data Quali.... (This job is for - Netezza Jobs in OH BlueAsh Analyst - (in BLUE ASH, OH))
(Specialist: Informatica Power Center, Data Warehousing, ETL Design And Documentation, SQL Experience Relational Database UnixL in Columbus, OH)
   
 
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
    About Us     Services    Privacy policy    Legal     Contact us     Copyright JobsInHand.com All Rights Reserved