- 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
-
Data Integration Specialist
1 day ago
Crayola Easton, United StatesData Integration Specialist, Full-Time, Forks, PA · 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 wi ...
-
Data Integration Specialist
2 weeks ago
Crayola Easton, United StatesData Integration Specialist, Full-Time, Forks, PA · 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 w ...
-
Emerald Enterprises Chalfont, United StatesIT Specialist for System Integration (m/f/d) at MEDIAN Company Headquarters · MEDIAN is a leading provider of medical rehabilitation and mental health services in Europe. With over 120 facilities throughout Germany, we offer a dynamic and innovative environment for employees in ...
-
Data Integration Specialist
3 weeks ago
FIA NOW Employment Solutions Easton, United StatesOur client is seeking a highly skilled and experienced Data Integration Specialist to join their team. The ideal candidate will have extensive expertise in data integration technologies, with a focus on Informatica. They will be responsible for designing, developing, and implemen ...
-
Training for IT specialist in system integration
3 weeks ago
FusionTech Bradley Gardens, United StatesAt Silberform Group, we are active in the areas of design, development, and prototyping. Equipped with state-of-the-art technology, we develop and manufacture models, prototypes, and special vehicles in design studios. With our expertise and innovation, we support automotive manu ...
-
Integration Specialist
1 week ago
StarkTech LLC Defunct Flemington, United StatesStark Tech is on the lookout for an Integration Specialist proficient in Temperature Control building controls systems to become a part of our dynamic team. If you possess the skills to configure, validate, and manage these systems along with other low voltage control sub-systems ...
-
St. Lukes Health Network Bethlehem, United StatesIntegration Behavioral Health Billing Support Specialist page is loaded **Integration Behavioral Health Billing Support Specialist** · **Integration Behavioral Health Billing Support Specialist** · locationsBethlehem, PA - 257 Brodhead Road time typeFull time posted onPosted To ...
-
Education Specialist MSN
1 week ago
ST. LUKE'S UNIVERSITY HEALTH NETWORK Easton, United States Part timeSt. Luke's is proud of the skills, experience and compassion of its employees. The employees of St. Luke's are our most valuable asset Individually and together, our employees are dedicated to satisfying the mission of our organization which is an unwavering commitment to excelle ...
-
Construction Manager
1 week ago
Fusion Technology Easton, United States ContractedEmployee dedication contributes to our success, customer satisfaction, and our nation's most outstanding achievements. At Fusion Technology, we recognize that our employees are our greatest attribute. That is why our top priority is to attract, recruit, retain, and continuously m ...
-
University of Maryland Medical System Easton, United StatesDetails Posted: 08-Jun-24 · Location: Easton, Maryland · Salary: Open · Categories: · General Nursing Internal Number: REF26960B · Job Description The Maryland ExpressCare (MEC) Senior Critical Care Transport Specialist (SRCCTS) must be able to function as a member of a high ...
-
University of Maryland Medical System Easton, United States OTHERJob Description The Maryland ExpressCare (MEC) Senior Critical Care Transport Specialist (SRCCTS) must be able to function as a member of a highly effective, high-acuity, high-volume critical care transport team. Team members in this role are expected to work collaboratively and ...
-
Principal OT Security Architect
2 weeks ago
Haleon Warren, NJ, United States Full timeHello. We're Haleon. A new world-leading consumer health company. Shaped by all who join us. Together, we're improving everyday health for billions of people. By growing and innovating our global portfolio of category-leading brands – including Sensodyne, Panadol, Advil, Voltare ...
-
US Trade Compliance Specialist
4 days ago
Victaulic Easton, United States· Title: Trade Compliance Specialist (US) · Department: Internal Audit & Compliance - Global Trade Compliance · Reports to: Global Trade Compliance Specialist · Location: Easton, PA. US · Type: Full Time · Job Summary · The Trade Compliance Specialist is responsible for ha ...
-
Marketing Specialist
1 week ago
Victaulic Easton, United StatesMarketing · Job Description · Position: · Marketing · Specialist - · Industrial Markets · , · Global · Corporate · Headquarters · Reports To: · Marketing · Manager – · Industrial · Markets · , · Corporate Headquarters · Location: · Easton, · Pennsylvania 18040 ...
-
Medical Assistant
1 day ago
Steward Health Care Easton, United States Per DiemJob Summary: · The position is a member of the health care team who functions in a dual role, providing administrative as well as clinical support to ensure quality care to patients and the smooth day-to-day operation of the physician practice. Duties will include, but are not li ...
-
Creative Arts Therapist
2 weeks ago
COMHAR Easton, United StatesReference #: Creative Arts Therapist · Job Type Part-time Description · COMHAR is growing in the Lehigh Valley and we are excited to have you join our team At COMHAR, it is our mission to provide health and human services that empower individuals, families, and communities to liv ...
-
Creative Arts Therapist
1 day ago
COMHAR Easton, United States Part timeJob Type Part-time Description COMHAR is growing in the Lehigh Valley and we are excited to have you join our team · At COMHAR, it is our mission to provide health and human services that empower individuals, families, and communities to live healthier, self-determined lives. · ...
-
Acquisitions Specialist
1 day ago
Pezon Properties Easton, United StatesJob Description · Job DescriptionAre you a real "Go-Getter" that wants to serve, and add value? Do you possess a great attitude and the willingness to be coachable? At Pezon Properties, we are seeking an ambitious and driven Acquisitions Specialist to join our team. As the Acquis ...
-
University of Maryland Medical System Easton, United States OTHERJob Description The Maryland Express Care (MEC) Critical Care Transport Specialist 2 (CCTS2) must be able to function as a member of a highly effective, high-acuity, high-volume critical care transport team. Team members in this role are expected to work collaboratively and resp ...
-
Advanced Manufacturing Manager
2 weeks ago
Georg Fischer Easton, United StatesYour tasks Duties: Develop and lead initiatives in the organization to elevate performance to world class plastics and polymer manufacturing Develop technical and operating strategies regarding the manufacturing of plastic parts and related systems, develop standards and ensure t ...
Data Integration Specialist - Forks Township, United States - Heller Search Associates
3 weeks ago
Description
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
JOB SPECIFICATIONS:
