How to Set Up an ETL Development Team

Database systems such as SQL have revolutionized the way that businesses analyze performance and generate reports. While database reporting drastically decreases the amount of effort required to analyze large amounts of information, businesses can rely on the reports only to the degree that their databases contain complete, accurate information. Database administrators refer to the process of transferring data from source systems (such as point of sales programs) to the database as extraction, transformation and loading (ETL). Setting up an ETL development team helps your company ensure that database-generated reports accurately display complete, up-to-date information.

Instructions

    • 1

      Determine how large of an ETL development team your company requires. Consider how quickly you need an ETL system implemented. Discuss with your current information technology staff what programs provide information (such as point of sales, invoicing and human resource management systems) and with what database system (such as Oracle or MySQL) they must interface.

    • 2

      Recruit from your current IT staff for a project manager. Choose a staff member with proven experience using company software, knowledge of the database system and potential as a team leader.

    • 3

      Write detailed job listings. List the specific technologies and systems (such as Informatica, Oracle or Linux) that an applicant must be familiar with. Include education, certification and experience requirements.

    • 4

      Post the listing on your corporate web site as well as job search engines such as Thingamajob and Simplyhired.

    • 5

      Schedule interviews with promising applicants. Ask the team leader to participate in the interviews. Review the applicant's knowledge and qualifications relevant to the position, such as experience with the company's database system or input programs.

    • 6

      Consult the team leader for his impression of top interviewees. Discuss any reservations that you may have about each candidate. Decide which candidates to hire to fill the ETL team positions.

Learnify Hub © www.0685.com All Rights Reserved