Back to search results

Data Integration Engineer - Core Technology Infrastructure

Charlotte, North Carolina

Job Description:

Job Description:                       

Analyze source data/file structures, technical metadata, profile source data and develop data mapping and transformation rules and detail ETL specifications based on business requirements;

• Assist in the collection of technical metadata supporting the implementation;

• Utilize automation tools to schedule, execute, and monitor ETL jobs;

• Design, test, and debug data flow plans to create necessary Client files and/or populated databases;

• Design of the ETL application;

• Performance tune the application to meet operational production requirements;

• Develop and execute, in conjunction with the ETL Architect, Quality and Release, and Process Analyst system and integration test plans;

Responsible for data migration from legacy system to new Platform

·        Design and develop ETL jobs and sequences

·        Design and develop multiple reports including audit, error and reconciliation reports.

·        Candidate must have understanding of ETL Processes and Best Practices

 ·        Expert level knowledge and hands-on experience with DataStage Enterprise Edition/Parallel Extender (Orchestrate) for parallel processing as part of ETL conversion process integrating multiple source

Required Skills:

    Integration of various data sources like Oracle, DB2, DB2UDB, SQL Server, Flat files into the target tables.

·        SQL, PL/SQL, Packages, Procedures, Functions and Triggers.

·        Performance Tuning of SQL statements, stored procedures and functions.

·        Writing UNIX shell scripts as per the requirement and used Job scheduling tools like Autosys utility

·        Firm understanding of software development Lifecycle, release management and change management process

·        5+ years of experience in Production Support. Strong analytical, diagnostic and troubleshooting skills and ability to work in a dynamic, team-oriented environment.

·        Strong written and verbal communication skills

·        Understanding and hands-on experience with XML packages in DataStage

·        Diverse understanding of IT infrastructure and other technologies is a plus

·        Strong written and verbal communication skills

·        Team player and self-motivated, work independently with minimum direction

Desired Skills:

• Fundamental knowledge of IT Service Management/ITIL processes and tools

• Data Virtualization using Presto/Trino

• Experience with Jira & Bitbucket

• Cloudera Manager CDH Administration

• ETL Tool - Syncsort DMX-h

• Autosys and Oozie

• Kafka

Job Band:

H5

Shift: 

1st shift (United States of America)

Hours Per Week:

40

Weekly Schedule:

Referral Bonus Amount:

0

Job Description:

Job Description:                       

Analyze source data/file structures, technical metadata, profile source data and develop data mapping and transformation rules and detail ETL specifications based on business requirements;

• Assist in the collection of technical metadata supporting the implementation;

• Utilize automation tools to schedule, execute, and monitor ETL jobs;

• Design, test, and debug data flow plans to create necessary Client files and/or populated databases;

• Design of the ETL application;

• Performance tune the application to meet operational production requirements;

• Develop and execute, in conjunction with the ETL Architect, Quality and Release, and Process Analyst system and integration test plans;

Responsible for data migration from legacy system to new Platform

·        Design and develop ETL jobs and sequences

·        Design and develop multiple reports including audit, error and reconciliation reports.

·        Candidate must have understanding of ETL Processes and Best Practices

 ·        Expert level knowledge and hands-on experience with DataStage Enterprise Edition/Parallel Extender (Orchestrate) for parallel processing as part of ETL conversion process integrating multiple source

Required Skills:

    Integration of various data sources like Oracle, DB2, DB2UDB, SQL Server, Flat files into the target tables.

·        SQL, PL/SQL, Packages, Procedures, Functions and Triggers.

·        Performance Tuning of SQL statements, stored procedures and functions.

·        Writing UNIX shell scripts as per the requirement and used Job scheduling tools like Autosys utility

·        Firm understanding of software development Lifecycle, release management and change management process

·        5+ years of experience in Production Support. Strong analytical, diagnostic and troubleshooting skills and ability to work in a dynamic, team-oriented environment.

·        Strong written and verbal communication skills

·        Understanding and hands-on experience with XML packages in DataStage

·        Diverse understanding of IT infrastructure and other technologies is a plus

·        Strong written and verbal communication skills

·        Team player and self-motivated, work independently with minimum direction

Desired Skills:

• Fundamental knowledge of IT Service Management/ITIL processes and tools

• Data Virtualization using Presto/Trino

• Experience with Jira & Bitbucket

• Cloudera Manager CDH Administration

• ETL Tool - Syncsort DMX-h

• Autosys and Oozie

• Kafka

Shift:

1st shift (United States of America)

Hours Per Week: 

40

Learn more about this role

Full time

JR-22000480

Band: H5

Manages People: No

Travel: Yes, 5% of the time

Manager:

Talent Acquisition Contact:

Kathleen Jones-Griffith

Referral Bonus:

0

Street Address

Primary Location:
901 W Trade St, NC, Charlotte, 28255