<< Back to Management


Data Integration / ETL Consultant

Job Description

The Data Warehouse Developer is a strong ETL Developer that works as part of the Data Warehouse and Reporting team. The developer has strong design, development and testing knowledge data warehouse technologies. The Developer will develop, unit test, support and maintain ETL jobs based on business requirements and technical specifications following project standards. 



  • Responsible for testing, monitoring and validating data integration activity, including data extraction, cleansing, transformation, movement, loading and updating processes
  • Ensures data integration processes meets service level requirements
  • Designs and writes the scripts required to extract, transform, clean and move data and metadata so it can be loaded into a data warehouse, data mart or operational data store
  • Coding and testing program modules; assisting in design
  • Assisting in the integration of technical and application components
  • Maintaining, tuning and repairing applications; providing user support
  • Participating in execution and documentation of tests



  • ETL Tools
  • SQL writing experience
  • UNIX operating system and shell scripting
  • Understanding of Data warehouse concepts, project lifecycle, and roles and responsibilities
  • Understanding of change management practices
  • Understanding of Data modeling and able to read Data models
  • Able to work in a team and independently and meet timelines
  • Strong communications skills


Education and Experience Level

  • Experience with data performance and data warehousing concepts
  • Minimum of 3 years of development experience
  • BS Degree in Computer Science/Information Technology, Computer Engineering or any 4-year IT related degree
  • Hands-on experience in implementation and deployment of SAS Data Integration Solution.
  • Hands-on experience in implementation and deployment of any of the following Data Integration Technologies/Solutions: SAP, Oracle, IBM, Informatica, Microsoft SQL Server and on SAS Data Quality Solution is a plus