What are the responsibilities and job description for the Informatica Consultant position at Pinnacle Technology?
Job Description/Summary:
The Informatica Consultant will assist with UKG Pro Workforce Management Project. The Informatica consultant is responsible for working with HR and Payroll to create needed interfaces. This role will also work closely with our Human Resources and Payroll Departments to ensure that appropriate policies & procedures are adhered to within the implementation(s) and that the existing live functionality is not negatively impacted.
In collaboration with department and project management, the consultant will advise the project team of all risks and efficiencies and schedule any required procedures or knowledge transfer. The consultant will guide and perform design, testing and training as needed by the project team.
Essential Functions:
The successful candidate will interface with key stakeholders and apply their technical proficiency across various stages of the project.
- Use Informatica PowerCenter to create mappings, transformations, and load data into the target systems.
- Data modeling: Creating data models, building ETL processes, and performing data migration
- Programming: Using Informatica tools to update, test, and provide solutions for data issues
- Take responsibility for delivering work and designing the work effort.
- Proactively identify project issues and recommend viable solutions.
- Provide training and support to project team on interfaces and best practices.
- Development and testing of interfaces/flat files
- Work closely with Project Managers communicating and understanding the goals required to complete the required tasks on time and budget.
