3 Jobs in Easton, PA
ASB Resources is Hiring a Data Integration Specialist Near Easton, PA
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.
- Decide if requested projects are technically feasible within the capabilities of the current systems and technologies.
- Defining and optimizing Data Integration processes.
- Choose and implement the best solution that meets data requirements with optimal performance.
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 o Cloud Mass Ingestion
- SAP HANA connector
- Google Analytics connector
- REST V2/V3 connector
- Stored Procedures,
- JavaScript
- User Defined Functions
- Stages
- Data Pipelines
- Strong data modeling skills (normalized and multidimensional).
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
- 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
Job Summary
Full Time
IT Outsourcing & Consulting
$117k-138k (estimate)
04/25/2024
10/06/2024
asbresources.com
PRINCETON, NJ
50 - 100
2012
MOHAMED BAKERYWALA
$5M - $10M
IT Outsourcing & Consulting
Related Companies
About ASB Resources
As one of the best Human Capital Solutions Providers and Project Resource Firms in the field, our team at ASB Resources has been identifying and providing top talent to corporate clients since 2004. Recognized as a business consulting firm with high level of tech expertise, we help clients strengthen their Information Security, Project Management & QA capabilities. Your Goals are our Results! ASB Resources was started with a vision of creating a unique and efficient platform that would attract talented people, and would foster professional and personal growth to create future industry leaders. ...
We offer human capital solutions and tech consultancy in the fields of information security, temporary staffing, contingency executive search, project-based recruitment solutions, and customized HR consultancy. We are in the business of maximizing human potential for your growth, and helping talented people emerge as world leaders through the application of our innovative workforce solutions.
More
Show Less
The job skills required for Data Integration Specialist include Computer Science, Problem Solving, Java, Data Integration, JavaScript, Initiative, etc. Having related job skills and expertise will give you an advantage when applying to be a Data Integration Specialist. That makes you unique and can impact how much salary you can get paid. Below are job openings related to skills required by Data Integration Specialist. Select any job title you are interested in and start to search job requirements.
The following is the career advancement route for Data Integration Specialist positions, which can be used as a reference in future career path planning. As a Data Integration Specialist, it can be promoted into senior positions as an Integration Engineer V that are expected to handle more key tasks, people in this role will get a higher salary paid than an ordinary Data Integration Specialist. You can explore the career advancement for a Data Integration Specialist below and select your interested title to get hiring information.
Similar Jobs
Popular Articles
