Business Analytics Developer

Position Summary

The Developer, Enterprise Integration will be responsible for the design, development, implementation and support of processes to integrate data across applications and between applications and data warehouse/CRM, which includes partner integration, interface design/specifications, and interface troubleshooting.

Key Accountabilities:

with TCP Application Teams and external partners to establish new interfaces, enhance existing interfaces, and troubleshoot integration issues as they arise through all stages of development, implementation, and production operation

Parallel jobs using various stages including join, merge, lookup, surrogate key, funnel, sort, transformer, copy, remove, duplicate, filter, pivot, and aggregator stages for grouping and summarizing key performance indicators used in decision support systems

experience in XML processing

job sequences and job schedules to automate the ETL processes

on UC4 automation tool

multiple data sources such as Red shift, Post Gres, DB2, Netezza, Oracle, MS SQL Server, Complex Flat Files, Delimited Files, XLSX and XML files for handling feeds

production problems using Peek, Row Generator, and Column Generator Stages

in technical discussions to improve processes and applications

support for production DataStage jobs

to have knowledge on ETL server maintenance activities

Education and Experience:

degree in computer science, information systems, or related field or equivalent work experience

years of related experience developing and implementing solutions using IBM DataStage

with Red shift, Post Gres,DB2, Netezza, Oracle and other relational databases required

industry experience preferred

in handling IBM InfoSphere Information Server 11.7+ using DataStage Designer & Director

in analysis, design, data extraction, cleansing, transformation, and loading into Data Marts

with EDI a plus

Skills and Behaviors:

SQL and PL/SQL skills required

ETL development skills using Datastage 11.7 and higher

knowledge in UNIX shell and Python scripting

verbal and written communication and interpersonal skills

to work independently and within a team environment

critical listening and thinking skills