ETL Associate

Ventures Unlimited Inc; Charlotte (NC); On-site; USD 90,000 - 120,000; Full time

Job summary

A service-centric organization is seeking an ETL Associate in Charlotte, NC. The candidate will be responsible for automating and transforming customer data into formats suitable for the Supply Cloud solution. This role requires strong collaboration with customers to improve data quality and ensure successful processing. The ideal candidate has 7-10 years of experience, with extensive knowledge in ETL tools like Informatica and PDI, as well as programming skills in Java and Groovy.

Qualifications

• 7-10 years of experience required, with 3-5 years specifically in ETL.
• Domain knowledge in Manufacturing Operations, Supply Chain, and Quality Management.
• Knowledge of data quality validation and data mapping processes.

Responsibilities

• Automate and transform customer data into recognized data formats.
• Collaborate with customers to define data formats for sources.
• Ensure high-quality customer data through validations.
• Provide validations to ensure high quality customer data.
• Collaborate with customers to improve source data quality as needed.
• Provide feedback to Product Realization on feature gaps and usage improvements.
• Coordinate with the Solution Consultant to implement data feeds and customer tenants.
• Build trust and strong working relationships with customers.

Skills

ETL

Informatica

PDI

Data quality improvement

Customer collaboration

Tools

Java

Groovy

Piglatin

PDI

Informatica ETL tools

Job description

Ventures Unlimited is a service centric organization. Our success begins with our ability to apply our relationships, leverage technologies, and identify talent - often in combination - to an endless array of real-world customer needs

Job Description

Title : ETL Associate

Location : Charlotte, NC

Type : Full Time Permanent

Job Description :

Data may come from several sources in various formats. The Data Expert must ensure these data feeds from the customer will be processed successfully within the constraints of the Supply Cloud solution. This accountability will include the automation and transformation of customer data into data formats recognized by the solution

• Understand customer usage scenarios that will drive value
• Work with the customer to define data formats for each of their sources
• Gain intimate knowledge of the customer's data and map it to a format recognized by the Supply Cloud solution using ETL tools or programming languages
• Provide validations relevant to each scenario to ensure high quality customer data
• Collaborate with the customer on methods to improve source data quality as needed
• Provide feedback to Product Realization on feature gaps and usage improvements to improve the overall value of the solution
• Work with the Solution Consultant in implementing the data feeds and customer tenants
• Build trust and a strong working relationship with customers

Functional Skills : Domain knowledge in Manufacturing Operations, Supply Chain, and Quality Management

Technical Skills :

• Knowledge of data base concepts and Big Data techniques
• Knowledge of programming and scripting languages: Java, Groovy, Piglatin
• PDI, Informatica and other known ETL tools

Total Experience Required :

• 7- 10 years of experience
• 3-5 years of experience on ETL

Qualifications

• ETL
• Informatica
• PDI

Additional Information