Global Data Consultants

  • Business Intelligence (BI) ETL Developer

    Job Locations US-MD-Hagerstown
    Posted Date 6 days ago(6 days ago)
    Job ID
    2018-2138
    Recruiter
    Alex McCurn
  • Overview

    GDC IT Solutions is currently recruiting for a Business Intelligence (BI) ETL Developer in the Hagerstown, MD area.   Telecommunicating available for experienced developer.


     


    Please note that this is a full-time, W2 position. Candidates must be able to legally work in the US without requiring work visa sponsorship now or in the future.  This position is unable to support C2C.


     

    Position Overview

    Collaborate with senior level developers and customers on design, mapping, development and testing for data integration processes.

    Responsibilities


    • 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 6 days, including 1 weekend rotation every other 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


    • 3 to 4 years ETL development experience 

    • Experience with ETL testing

    • Experience with PostgreSQL or Netezza relational databases

    • Experience working within a Linux operating environment

    • Basic understanding of data design and data structures

    • Basic understanding of scripting or programming

    • Experience in evaluating system change and implementation requests

    Preferred Experience


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

    • IBM DataStage v11.5

    • Experience with Microsoft SQL Server Integration Services (SSIS)

    • Database knowledge (SQL Server / Netezza / mySQL)

    • SQL based tools (SQL Developer / TOAD / Aginity)

    • Experience developing and executing software validation scripts

    • Experience in technical writing and documentation

    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.

    Options

    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.