Hybrid Data Integration Specialist at EDI Specialists, Inc.
Easton, PA
About the 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
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.
- 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.
