Business Analytics Developer

Position SummaryThe 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 operationParallel 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 systemsexperience in XML processingjob sequences and job schedules to automate the ETL processeson UC4 automation toolmultiple 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 feedsproduction problems using Peek, Row Generator, and Column Generator Stagesin technical discussions to improve processes and applicationssupport for production DataStage jobsto have knowledge on ETL server maintenance activitiesEducation and Experience:degree in computer science, information systems, or related field or equivalent work experienceyears of related experience developing and implementing solutions using IBM DataStagewith Red shift, Post Gres,DB2, Netezza, Oracle and other relational databases requiredindustry experience preferredin handling IBM InfoSphere Information Server 11.7+ using DataStage Designer & Directorin analysis, design, data extraction, cleansing, transformation, and loading into Data Martswith EDI a plusSkills and Behaviors:SQL and PL/SQL skills requiredETL development skills using Datastage 11.7 and higherknowledge in UNIX shell and Python scriptingverbal and written communication and interpersonal skillsto work independently and within a team environmentcritical listening and thinking skills PRB