PrimeSource Building Products

  • ETL Developer-Irving, TX (2018-11965)

    Job ID
    2018-11965
    # Positions
    1
    Category
    US-TX-Irving
    Category
    IT
    Posted Date
    6/7/2018
  • Overview

    ETL Developer-Irving, TX (2018-11965)

     

    PrimeSource Building Products, Inc., one of the nation's largest wholesale distributors of building supply products is seeking reliable, hard working ETL Developer in our corporate office located in Irving, Texas.

     

    The ETL Developer will build new data warehouses, maintain and enhance existing data warehouse tables, and ensure data quality and accuracy are maintained in all data warehouse structures.  Be responsible for business intelligence tools that transfer data stored in SAP ECC Tables to the FICO and SD Rapid Marts, such as Data Services (BODS). Create and maintain ETL schedules utilizing the scheduling software Active Batch, solve issues pertaining to data or reports, and perform data conversions during business acquisitions. Work closely with Database Administrator to tune and optimize data warehouse performance via indexing, reorgs, partitions, views, and MQTs. Design and maintain all ETL logic using BODS ETL tool. Improve query performance for reporting by tuning data warehouse table constructs and database concepts.

     

    Analyze data load times and maximize loading by applying ETL configuration changes and/or data warehouse changes. Create and maintain data maps from source to target tables/files.  

     

    Candidates MUST be local to the DFW Area 

    We are UNABLE to sponsor candidates at this time

    Responsibilities

    Essential Duties and Responsibilities include the following. Other duties may be assigned.

    • Support and develop master data processes to meet business needs.
    • Ensure data quality, integrity and accuracy is maintained in data warehouse tables.
    • Interface with users on topics related to data integration.
    • Create and maintain data maps from source to target tables/files.  
    • Perform data conversions into the data warehouse during new business acquisitions.
    • Create and maintain Data Services ETL jobs to load and maintain master data.
    • Manage data activities pertaining to company reorganizations.
    • Create and maintain production Data Warehouse job schedule using Active Batch software.

    Qualifications

    Bachelor’s degree in Computer Science, Electrical Engineering or related field, and five years of experience in the job offered or related position with SAP Data Services (BODS) and ECC Tables

     

    IT Skills                                            

     

    To perform this job successfully, an individual should have knowledge of:

    • Master Data design and concepts including customer, vendor, material
    • Business Objects Data Services or similar ETL software
    • Relational database experience (extensive SQL experience)
    • Business Objects Web Intelligence or similar BI software
    • SAP ECC tables, data objects, and basic T codes
    • Basic Data Warehouse knowledge
    • Active Batch or similar job scheduling software

    EOE Statement

    PrimeSource Building Products, Inc. is an Equal Opportunity Employer. PrimeSource Building Products, Inc. is fully committed to equal employment opportunity (EEO) and maintaining a workplace free of discrimination and harassment based on race, gender, religion, age, color, national origin, disability, sexual orientation, genetic information and other non-merit factors. All persons shall be afforded equal employment opportunity at PrimeSource Building Products, Inc.

     

    PrimeSource Building Products, Inc. prohibits discrimination in all aspects of its personnel policies, program practices and operations and relationships with employees and applicants, including but not limited to recruitment, hiring and merit promotion. PrimeSource Building Products, Inc. promotes programs of affirmative recruitment and employment at all levels of PrimeSource Building Products, Inc.. PrimeSource Building Products, Inc. subscribes to, and will implement to the full extent, all applicable laws that promote equality of opportunity.

     

    PrimeSource Building Products, Inc. welcomes and encourages applications from persons with disabilities, and will reasonably accommodate the needs of those persons. PrimeSource Building Products, Inc. is firmly committed to satisfying its affirmative obligations under the Rehabilitation Act of 1973, to ensure that persons with disabilities have every opportunity to be hired and advanced on the basis of merit within PrimeSource Building Products, Inc.

    Apply for this career opportunity

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