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