Job Search > Hybrid Data Integration Specialist

Filter these job results to find a perfect match.

  • Keywords can include skills or a job number. If using multiple keywords, insert ‘or’ or ‘and’ between for best results (e.g. Java or Oracle)
  • Advanced Options...
  • X

Hybrid Data Integration Specialist

  • Location: Easton, PA
  • Start Date: 1/18/2024
  • Job ID: 24-00488
  • Posting Date: 9/13/2024
  • Job Type: Direct Placement
Continue to apply for this job >
GENERAL SUMMARY:
This position is a technical role that has the responsibility for designing and developing data integration solutions in support of our data warehouse environment and inter-system interfaces. The individual will collaborate with cross-functional teams to understand data requirements and implement data integration solution to best satisfy the requirements.

PRINCIPAL DUTIES & RESPONSIBILITIES
  • *Develop and maintain ETL (Extract, Transform, Load) processes to ensure seamless data integration from various sources into our data warehouse using Informatica IDMC
  • *Ensure data quality and accuracy by implementing validation checks and error handling mechanisms.
  • *Understand and perform basic DBA functions in Snowflake and MS SQLServer
  • *Strong familiarity with SAP and SAP data in a manufacturing setting.
  • Design and develop the ETL process, including data analysis and testing.
  • Design and develop the information access and delivery effort for the data warehouse.
  • Participate in the design and development of the data warehouse, as well as creation of user and SOP documentation.
  • Monitor system performance, implement changes to optimize performance.
  • Experience with IDMC Catalog and Data Governance a plus.
JOB SPECIFICATIONS:
  • Bachelor's degree in computer science, information systems field with 5+ years of work experience.
  • Strong technical skills with Informatica ICDM including but not limited to
    • Flat file Source and Target transformations, Expression transformations, Lookup transformations, Filter transformations, Joiner transformations, Router transformations.
    • Intelligent Structure Model
    • Java transformations
    • Source Control experience
    • MS PowerShell scripting
    • SQL Server, Oracle, Snowflake database connections
    • Cloud Application Integration
    • Cloud B2B
    • Cloud Mass Ingestion
    • SAP HANA connector
    • Google Analytics connector
    • REST V2/V3 connector
  • Understand and perform basic Snowflake DBA functionality including but not limited to
    • Stored Procedures,
    • JavaScript
    • User Defined Functions
    • Stages
    • Data Pipelines
    • Strong data modeling skills (normalized and multidimensional).
  • Understanding of business data and its various sources including but not limited to SAP, both ECC and S4/Hana
  • Understanding of database technologies and data warehouse methodologies.
  • Strong business and communication skills.
  • Ability to present ideas in user-friendly language.
  • Maintain a high level of customer service to both internal and external clients.
  • Must exhibit a proficiency in using Microsoft Office Suite.
  • Must have excellent problem solving and analytical skills.
  • High initiative and ability to prioritize in a high-pressure environment.
  • Must be able to work on simultaneous projects.
Continue to apply for this job > Share this job
Posted by Adam Barron
Technical Resource Manager - Midwest
(800) 821-4644 x 9584

why-work-with-edi