Global Data Consultants

  • ETL DataStage Developer

    Job Locations US-MD-Hagerstown
    Posted Date 4 weeks ago(5/24/2018 2:35 PM)
    Job ID
    Alex McCurn
  • Overview

    GDC IT Solutions is currently recruiting for an ETL DataStage Developer in the Hagerstown, MD area.

    Position Overview

    The ETL Developer will be joining a team of professionals that places an emphasis on leveraging data as a strategic asset, exceeding expectations for internal and external clients, and enhancing our ability to leverage information to improve service delivery. You will work closely with other members of the Data and ETL teams to design and develop data delivery solutions to meet identified needs for the business.


    • Design, develop, test, debug, implement and maintain ETL workflows, mappings, scripts, stored procedures and applications to support the data warehouse and reporting requirements.
    • Follow best practices for coding, data quality and data governance.
    • Support on-call, including after hour and weekend support of production Data Integration processes.   Typical monthly rotation per team member is 8 days, including 1 weekend rotation a month.
    • Perform production support activities including incident and problem management, upgrades and code patches.  Troubleshoot data warehouse and data quality problems. Identify, coordinate and help resolve the root cause of day to day production issues.
    • Assist in identifying and evaluating risks and developing risk mitigation strategies
    • Develop SQL queries/scripts to validate the completeness, integrity and accuracy of data within the ETL process testing cycle.
    • Review and analyze source data, analyze and document data flows, and validate mapping specifications and business rules from data source to target.
    • Participate in broader technical reviews used to detect defects in requirements, design, code, test cases, or other project artifacts.
    • Run, debug, and troubleshoot SQL data imports and exports.
    • Investigate and report on the root cause of system issues.
    • Evaluate queries and programs under system load.

    Minimum Qualifications

    • Must Have:

      • In-depth experience with IBM DataStage v8 or above (v11.5 desirable)
      • Experience in BI, Data Warehousing, Data Quality and Data Analysis
      • Experience with ETL Testing

      Experience with all/some of the following technologies or responsibilities:

      • Database knowledge (SQL Server / Netezza / mySQL)
      • Cognos BI Tools / SSRS / SSIS
      • Powershell / C#/ T-SQL / JavaScript
      • SQL based tools (SQL Developer/ TOAD / Aginity)
      • Experience developing and executing software validation scripts
      • Experience in technical writing and documentation

    Preferred Experience

    • Bachelor’s degree from an accredited university, preferably in Computer Science/Information Systems/Engineering or another related field.

    What We Do

    GDC IT Solutions (GDC) is a full-service Information Technology (IT) company providing solutions that empower businesses to increase employee productivity, maximize investments, and improve operational efficiencies. With experienced and certified professionals, we deliver services in the areas of application development, data center, 24/7 multilingual service desk, desktop lifecycle management, project management, business process consulting, and IT staff augmentation.


    What Makes GDC Different:


    Our employees are our greatest asset continually driving our success each and every day. We attract and maintain the best talent to provide a personal customer experience at every touchpoint. Our technology professionals care about day-to-day client interactions and resolving customer issues quickly and efficiently, the first time. We deliver services with a code of high ethical responsibility, both to protect our clients and to assure that the work is carried out at the maximum level of professionalism. We are technology experts remaining one step ahead as technology evolves and constantly engaging to understand our clients’ business technology needs in order to deliver the best possible solution.


    Why Work for GDC?

    • Cutting Edge Technology and Innovation:  GDC fully supports and embraces continuing education and industry certifications to stay ahead of trends and remain current within the technology landscape. We recognize that our employees add the real value to our clients and to our business. By approaching our daily operations with a passion for innovation and a shared-learning environment, everyone can make a positive difference.
    • Career Growth: GDC is one of the fastest growing companies in the region!  Sustained growth means ongoing opportunity. Many of our senior leaders have grown within the company, starting with the helpdesk or other entry-level roles to become thought leaders in the fields of IT infrastructure, application development, project management, and business development.
    • Employee-Centric Environment: GDC prides itself on employee satisfaction with a firm belief that happy employees are the most productive employees. In appreciation of our employees and their contributions, we sponsor numerous events throughout the year including an annual gala, golf, lunch barbeques and more.
    • Comprehensive Benefits Package: GDC offers competitive compensation, excellent benefits, and a positive work environment designed around the philosophy of mutual respect. Our comprehensive benefits package includes medical, dental, prescription, vision, 401(k), short and long-term disability, and group life.
    • Holiday and Vacation: GDC firmly believes in a comfortable work-life balance, and we offer comprehensive holiday and paid-time-off (PTO) packages.  We provide a generous PTO package, and we encourage our staff to use it — whether it’s for vacation or other personal reasons everyone needs time to relax and refresh.

    Equal Opportunity Workplace:


    GDC is proud to be an equal opportunity workplace and is an affirmative action employer. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. All qualified applicants will receive consideration for employment.


    Visit our Career Center for the latest employment opportunities.


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

    Connect With Us!

    Not ready to apply? Connect with us for general consideration.