- 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.
- This position requires the candidate to be on-site in the Forks offices a minimum of 2 days per week.
- The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.
- Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is frequently required to sit, talk and hear.
- The employee is occasionally required to walk; use hands and fingers to operate, handle, or feel objects, tools, or controls; and reach with hands and arms.
- The employee must occasionally lift and/or move up to 25 pounds.
- Specific vision abilities required by this job include close vision and the ability to adjust focus
-
IT specialist for system integration
1 week ago
Phoenix Industries Marksboro, United StatesWe, the team at Marksboro, are supported by our various brands and around 1200 motivated employees, managing the online presence of various companies. From improving online visibility to digitizing everyday work processes, we support our clients with excellent products and servic ...
-
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 ...
-
ZephyrTech Coplay, United States**About IPETRONIK GmbH & Co. KG: ** · We are a globally operating company for mobile measurement technology, DAQ software, engineering services, and test bench technology for the automotive industry as well as for the aerospace & turbines sector. · What do we offer? · Flexible wo ...
-
ZephyrTech Pen Argyl, United StatesWhat can you do with your talents here in Pen Argyl?You plan and organize sales. · You procure goods and ensure their availability. · You present goods and provide services. · You determine and analyze business indicators. · You advise customers, lead employees, and manage busine ...
-
Integration Specialist
5 days 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 ...
-
Social Worker/counselor Lcsw-c/lcpc
4 days ago
Affiliated Sante Group Easton, United States**DO YOU HAVE A PASSION FOR MAKING AN IMPACT IN YOUR COMMUNITY?** · **PLEASE JOIN OUR TEAM OF PROFESSIONAL AND DEDICATED STAFF** · **EXCELLENT OPPORTUNITY** · **COMPETITIVE PAY STARTING AT $31 **PER HOUR** PLUS SHIFT DIFFERENTIAL** · **NOT REMOTE (in office)** · **What We Do**: · ...
-
Sales and Service Specialist
3 days ago
Fulton Bank Easton, United StatesValue Proposition: · Our values define us and our culture inspires us to change lives for the better. Our employees are the heart and soul of our company, and every success we experience begins with them. Together we are committed to making a positive impact in our local communit ...
-
Clinical Supervisor
6 days ago
Avenues Recovery Easton, United States**Avenues Recovery Center at Eastern Shore** is seeking to hire a **Clinical Supervisor** · **Avenues Recovery Center** is a unique community-based detox/residential style facility that's truly customized to the needs and unique circumstances of each individual. With our team of ...
-
Clerical Technician 3
1 week ago
County of Northampton Easton, United States**Application Requirements**: · Equal Employment Opportunities - It is the policy of Northampton County to provide equal employment opportunities (EEO) to all persons regardless of race, color, national origin, religion, sexual orientation, marital status, sex, gender identity, g ...
-
Clerical - Juvenile Probation
1 week ago
County of Northampton Easton, United States**Posting will remain online until position is filled.** · **GENERAL PURPOSE** · The Clerical Technician 3 - Juvenile Probation position is responsible for performing administrative and professional work for the Juvenile Court. The individual in this position independently prepar ...
-
IT-Consultant Energy Industry
1 week ago
Cascade Innovations Phillipsburg, United StatesAs an internationally operating IT specialist, we are looking for you as an IT consultant or market communication consultant in the energy industry (m/f/d) at Phillipsburg. In our modern, hybrid work culture, you can choose to work at one of our locations: Leipzig, Cologne, or Gü ...
-
Specialized skilled worker
2 weeks ago
SilverLinx Tatamy, PA, United States FreelanceAs a leading Swiss construction and real estate service provider, Implenia develops, builds, and manages living spaces, work environments, and infrastructure for future generations in Switzerland and Germany. Additionally, Implenia offers tunnel construction and related infrastru ...
-
Social pedagogical specialist in the
2 weeks ago
Velocity Ventures Stewartsville, NJ, United States FreelanceSozial-kulturelle Netzwerke casa e.V. has been an officially recognized social organization for over 30 years, working in the field of education-oriented youth and school social work. We are currently seeking a Social Pedagogical Specialist for our full-day care program with inte ...
-
Ltd. Senior Physician
1 week ago
Stellar Enterprises Brainards, United StatesThere are many reasons to collaborate with European Medical Consulting Adam. In the following section, you will see how you can benefit from our free services and save valuable time: · You will learn about exclusive and unpublished positions · You will be relieved by our relocati ...
-
Training to become a salesperson
1 week ago
Titan Ventures Brainards, United StatesJoin our team at Takko Fashion and become a part of our success story With over 1,900 stores in 17 countries across Europe, our stores are at the heart of our company. Do you have a passion for fashion? Do you enjoy providing families with great advice and the perfect offer? Then ...
-
Photographer (Field Reporting Specialist)
3 days ago
Reliable Reports, Inc. Bethlehem, United StatesIf you are looking for a job that was not impacted by the covid-19 crisis, is considered an Essential Business (Under the CISA Memo, the federal government categorizes types of "critical infrastructure workers." Within each category, there may be a variety of different businesses ...
-
Nexus Innovations Hellertown, United StatesAbout the Company · With a passion for taste and quality, we develop and produce dressings, sauces, fish, and delicacies at three locations in Germany and two locations in Poland, with around 2,300 employees. · What do we offer? · Learn from mentors and supervisors: Through prof ...
-
Learning Management System
1 week ago
St. Luke's University Health Network Allentown, United StatesSt. 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 excell ...
-
Director, Allentown School District
1 week ago
Da Vinci Science Center Allentown, United StatesThe Da Vinci Director of ASD Partnership will serve as the co-leader of a new and innovative partnership between ASD and the Da Vinci Science Center providing ASD students with consistent access to state-of-the-art experiences in Science, Technology, Reading, Engineering, Arts, a ...
-
Safety Training Specialist
2 days ago
Compliance Management International Lansdale, United States**Safety Training Specialist** · Compliance Management International (CMI) is a premier global provider of environmental, health, and safety (EHS) services, serving clients of all sizes for over 25 years. We collaborate closely with organizations, including Fortune 500 companies ...
Data Integration Specialist - Easton, United States - ASB Resources
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
Decision Making Capabilities
1. Decide if requested projects are technically feasible within the capabilities of the current systems and technologies.
2. Defining and optimizing Data Integration processes.
3. Choose and implement the best solution that meets data requirements with optimal performance.
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
o Flat file Source and Target transformations, Expression transformations, Lookup transformations, Filter transformations, Joiner transformations, Router transformations.
o Intelligent Structure Model
o Java transformations
o Source Control experience
o MS PowerShell scripting
o SQL Server, Oracle, Snowflake database connections
o Cloud Application Integration
o Cloud B2B o Cloud Mass Ingestion
o SAP HANA connector
o Google Analytics connector
o REST V2/V3 connector
Understand and perform basic Snowflake DBA functionality including but not limited to
o Stored Procedures,
o JavaScript
o User Defined Functions
o Stages
o Data Pipelines
o 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.
PHYSICAL CONDITIONS:
