Business Analytics Developer

  • Hyderabad
  • The Childrens Place
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