ETL Developer

» ETL Developer
Information Technology
in Washington
, DC
Reference: 19-03940

Description:

This role is responsible for data warehouse development, testing, and support, as well as integrating complex transactions and data flows across different systems and technologies. With strong data modeling, profiling, and ETL programming skills, you will integrate data across channels, systems and technologies enabling our business customers and owners to access and benefit from the resulting knowledge in simple and secure ways. Our application development team seeks people with initiative who can envision and create technology solutions that not just meet but exceed expectations.

Responsibilities:

  • Design, implement, and support complex data integration processes in support of overall business objectives
  • Engage in system testing including unit, integration, regression, and performance testing
  • Debug complex ETL and other integration challenges
  • Provide technical support to resolve issues and ensure proper function of systems
  • Produce design specifications, assist with project planning, data modeling and design, documentation and test plans
  • Review functional requirements with team lead, and develop estimates
  • Perform and assume other duties and responsibilities as required by technology management

Requirements:

  • 3+ years in Information Technology specializing in ETL Technologies
  • Ideal candidate would have experience in Microsoft SSIS, but other platform experience will be considered
  • Experience with IBM DataStage is a plus
  • 3+ years of experience with SQL using MS SQL Server and/or Oracle
  • Undergraduate college degree, certification or equivalent work experience may be substituted for the educational requirement
  • Experience with Infor Omni-channel Campaign Management a plus
  • Experience with cloud database platforms such as Salesforce.com and Amazon RDS as ETL data sources is a plus
  • Experience with Data Warehousing a plus, including understanding of Data Warehousing theory, techniques, concepts and best practices