Job Title: Data IntegrationSpecialist
Location: EastonPA (Hybrid)
Duration : FullTime
GENERAL SUMMARY
Thisposition is a technical role that has the responsibility fordesigning and developing data integration solutions in support ofour data warehouse environment and intersystem interfaces. Theindividual will collaborate with crossfunctional teams tounderstand data requirements and implement data integrationsolution to best satisfy the requirements.
PRINCIPAL DUTIES &RESPONSIBILITIES
* Developand maintain ETL (Extract Transform Load) processes to ensureseamless data integration from various sources into our datawarehouse using Informatica IDMC.
* Ensure dataquality and accuracy by implementing validation checks and errorhandling mechanisms.
* Understand and performbasic DBA functions in Snowflake and MS SQLServer
* Strong familiarity with SAP and SAP data in amanufacturing setting.
* Design and develop theETL process including data analysis and testing.
* Design and develop the information access and deliveryeffort for the data warehouse.
* Participate inthe design and development of the data warehouse as well ascreation of user and SOP documentation.
* Monitor system performance implement changes to optimizeperformance.
* Experience with IDMC Catalog andData Governance a plus.
Decision Making Capabilities
1. Decide if requested projects are technically feasiblewithin the capabilities of the current systems andtechnologies.
2. Defining and optimizing DataIntegration processes.
3. Choose and implementthe best solution that meets data requirements with optimalperformance.
JOB SPECIFICATIONS:
Bachelors degree in computer science information systemsfield with 5 years of work experience.
Strongtechnical skills with Informatica ICDM including but not limitedto
o Flat file Source and Target transformationsExpression transformations Lookup transformations Filtertransformations Joiner transformations Routertransformations.
o Intelligent StructureModel
o Java transformations
o Source Control experience
o MSPowerShell scripting
o SQL Server OracleSnowflake database connections
o CloudApplication Integration
o Cloud B2B o Cloud MassIngestion
o SAP HANA connector
o Google Analytics connector
o RESTV2/V3 connector
Understand and perform basicSnowflake DBA functionality including but not limited to
o Stored Procedures
oJavaScript
o User Defined Functions
o Stages
o Data Pipelines
o Strong data modeling skills (normalized andmultidimensional).
Understanding of businessdata and its various sources including but not limited to SAP bothECC and S4/Hana
Understanding of databasetechnologies and data warehouse methodologies.
Strong business and communication skills.
Ability to present ideas in userfriendlylanguage.
Maintain a high level of customerservice to both internal and external clients.
Must exhibit a proficiency in using Microsoft OfficeSuite.
Must have excellent problem solving andanalytical skills.
High initiative and abilityto prioritize in a highpressure environment.
Must be able to work on simultaneous projects.
PHYSICAL CONDITIONS:
* This position requires the candidate to beonsite in the Forks offices a minimum of 2 days perweek.
* The physical demands described here arerepresentative of those that must be met by an employee tosuccessfully perform the essential functions of thisjob.
* Reasonable accommodations may be made toenable individuals with disabilities to perform the essentialfunctions. While performing the duties of this job the employee isfrequently required to sit talk and hear.
* Theemployee is occasionally required to walk; use hands and fingers tooperate handle or feel objects tools or controls; and reach withhands and arms.
* The employee must occasionallylift and/or move up to 25 pounds.
* Specificvision abilities required by this job include close vision and theability to adjust focus