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)

Featured Jobs SonarQube Monitoring Engineer (Jobs in Des Moines, Iowa) Technical Administrator (Jobs in Bismarck, North Dakota) Financial Manager (Jobs in Nashville, Tennessee) SSRS ASP.Net&C# JavaScript Xml Developer (Jobs in Jackson, Mississippi) Help Desk Software TechLead (Jobs in Jackson, Mississippi) EPIC Implementation Consultant (Jobs in Nashville, Tennessee) Analyst (Jobs in Jackson, Mississippi) FTP/SFTP SIEM Administrator (Jobs in Pontiac, Michigan) - - Consultant (Jobs in Chattanooga, Tennessee) MS Analyst (Jobs in Jackson, Mississippi)