The Children's Place Stores, Inc. -


    Posted Date 4 months ago(12/5/2017 9:42 AM)
    Job ID
    # Positions
    New Jersey
  • Overview

    This position will be responsible for design, development and implementation of processes to integrate data across marketing applications and CRM database. This includes building database stored procedures, functions to load and transform data to meet business needs and perform data analysis.


    Key Accountabilities:

    • Work 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.
    • Build complex sql and stored procedures to support CRM and Loyalty databases
    • Build ETL using datastage for complex transformations required to support enterprise integration needs
    • Partner with business stakeholders on data requirements and analysis

    Perform data audits across multiple sources of data and maintain data integrity


    • Excellent ETL development skills using Datastage 8.5 and higher.
    • Experience in handling IBM InfoSphere Information Server 8.5+ using DataStageDesigner & Director
    • Extensive experience in Analysis, Design, Data Extraction, Cleansing, Transformation and Loading into Data Marts
    • Extensive experience in writing SQL, database stored procedures and functions
    • Extensive knowledge of data architecture, database design, data model and data warehouse design considerations
    • Experience in developing Parallel jobs using various stages like Join, Merge, Lookup, Surrogate key, Funnel, Sort, Transformer, Copy, Remove Duplicate, Filter, Pivot and Aggregator stages for grouping and summarizing on key performance indicators used in decision support systems.
    • Production problem solving experience using Peek, Row Generator and Column Generator Stages.
    • Experience in handling job sequences and job schedules to automate the ETL processes.
    • Experience in handling feeds using multiple data sources such as DB2, Netezza, Oracle, MS SQL Server, Complex Flat Files, Delimited Files and XML files
    • Active participation in Technical discussions 
    • Working knowledge in UNIX shell scripting
    • Excellent Interpersonal Communication and Documentation skills


    Education and Experience:

    • Bachelor’s Degree in Computer Science, Information Systems or related course of study required or equivalent work experience
    • 5-8 years of related experience developing and implementing solutions using IBM datastage
    • Retail experience is a plus
    • ETL architecture and design
    • DB2, Netezza and other relational database experience Required
    • Strong SQL experience required
    • Communication skills both written and verbal
    • Ability to work independently and within a team environment
    • Critical listening and thinking skills


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed