This site uses cookies. To find out more, see our Cookies Policy

ETL Data Integrator in Auburn Hills, MI at Johnson Service Group

Date Posted: 3/11/2019

Job Snapshot

  • Employee Type:
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:

Job Description

JobID: 367558

Data Integrator

* Bachelor's degree from an accredited university and 5 years of experience in technology or 10 years of experience in technology.

* Minimum 2 years of experience working with Informatica

* Minimum 4 years of experience with ETL flows interacting with the source system technical staff, the project database administrator (DBA) and the DI Administrator to develop and document the most efficient method to extract source data.

* Minimum 4 years of experience develops and tests for extraction, transformation, and load (ETL) processes.

* Strong understanding of Database design in Oracle, DB2, SQL.

* Strong understanding of SQL (Structured Query Language) command.

* Basic understating of CA SCM, Jenkins, XMLSpy, CA Harvest, Jenkins, TOAD, IBM Data Studio, LDAP, A/D.

* Strong problem solving skills.

* Strong teamwork skills within I.S. and the client community.

* Strong verbal and written communication skills.

* Ability to manage their own project tasks.

* Highly Self-Driven and Self-Motivated.

* Demonstrated ability to multi-task work assignments, on two or more projects.

* Builds integration solutions in accordance with strategies, and standards.

* Prepares unit test plans and performs unit testing and peer reviews to ensure integration quality.

* Resolves defects and facilitate troubleshooting of integration issues.

* Advises ways to expand usage of IS standard tools on projects and other initiatives.

* Drafts and updates policies and best practices.

* Perform continuous improvement of efficiency, productivity, and usage.

* Implement methods to capture system SLA, logs, user experience, and data quality metrics.

* Implement security patterns included in the design.

* Implement vulnerability assessment remediation as required.

* Resolve operation issues and support operations when needed.

* Ensure that established procedures are followed and coordinate changes with other support staff.

* Keep manager informed of status of assigned tasks and activities through accurate, timely, and appropriate status reporting.

* Performs mentoring/coaching to less experienced team members.