How to source and shortlist {role_name}

Where can you find qualified {role_name}?

  • Professional network
    • Leverage your professional network and reach out to former colleagues, industry peers, and tech community members to ask for referrals.
  • Educational Institutions:
    • Partner with universities offering computer science and data engineering programs, particularly those known for producing data engineering talent.
    • Look for candidates from institutions with strong data science or engineering programs.
  • Company Career Pages:
    • Ensure the career page on your company website is SEO-optimized and features ETL Developer roles with clear job descriptions, emphasizing key technologies (e.g., Informatica, Talend, SQL).

What are the best practices for headhunting {role_name}?

  • Personalized Outreach: When headhunting, personalize your message by highlighting the technical tools and data challenges the candidate will be solving, such as working on large-scale data pipelines or integrating complex datasets.
  • Leverage Specialized Communities: Engage in online communities such as Data Engineering Slack Groups, Reddit’s Data Engineering Subreddit, and professional groups like Data Warehouse Developer Networks on LinkedIn.
  • Targeted Referrals: Ask for referrals from internal teams and data engineers for potential candidates who are strong in ETL tools and data integration technologies.

How to shortlist candidates?

Once you have started to get applications from applicants, a thorough screening process and shortlisting of prospects will help you make the most of your time spent with the most qualified ones. 

Automated shortlisting tools :

Automated screening quickly filters out unqualified candidates, saving time for manual review. This allows the manual process to focus on the most promising candidates, ensuring the best ones are considered for further evaluation.

Screening questions to auto-shortlist based on predefined criteria

like qualifications, location, experience, and skills. Either use job board or use an ATS such as whitecarrot. Here are some questions for {role_name}

  • How many years of experience do you have working with ETL tools like Informatica or Talend?
    • Auto-reject criteria: Less than 2 years of experience with ETL tools.
  • How many years of experience do you have in SQL and data warehousing?
    • Auto-reject criteria: Less than 3 years of experience with SQL and data warehousing concepts.
  • Are you located in [specified location] or willing to work remotely?
    • Auto-reject criteria: Candidate is not located in the required area or not willing to work remotely.

Skill based question to auto shortlist candidate

Analyze the skill test data to automatically shortlist top-performing applicants. (recommended screening test time - 15 minutes). Here are some skill test questions for {role_name}

ETL Tools

Assess the candidate's knowledge of ETL processes and tools (e.g., Informatica, Talend).

  • Question 1: What does the "T" in ETL stand for?
    • Options:
      1. Translate
      2. Transform
      3. Transmit
      4. Transcode
    • Correct Answer: 2. Transform
  • Question 2: Which ETL tool allows for drag-and-drop interface-based data transformations?
    • Options:
      1. Informatica
      2. Tableau
      3. Python
      4. Snowflake
    • Correct Answer: 1. Informatica
  • Question 3: Which of the following can be used to automate ETL workflows?
    • Options:
      1. Git
      2. Jenkins
      3. SSIS
      4. Airflow
    • Correct Answer: 4. Airflow

SQL and Data Warehousing

Assess SQL proficiency and knowledge of data warehousing concepts.

  • Question 1: Which SQL statement is used to retrieve data from a database?
    • Options:
      1. SELECT
      2. DELETE
      3. INSERT
      4. UPDATE
    • Correct Answer: 1. SELECT
  • Question 2: What is a data warehouse?
    • Options:
      1. A system for operational data processing
      2. A repository for storing large volumes of data for reporting and analysis
      3. A system for web server monitoring
      4. A tool for data encryption
    • Correct Answer: 2. A repository for storing large volumes of data for reporting and analysis
  • Question 3: Which SQL clause is used to filter records based on a condition?
    • Options:
      1. FROM
      2. WHERE
      3. ORDER BY
      4. GROUP BY
    • Correct Answer: 2. WHERE

Data Transformation and Integration

Evaluate the candidate’s ability to transform and integrate data across systems.

  • Question 1: Which process involves converting data from one format to another?
    • Options:
      1. Extraction
      2. Loading
      3. Transformation
      4. Integration
    • Correct Answer: 3. Transformation
  • Question 2: How do you handle null values during the data transformation process?
    • Options:
      1. Remove all null values
      2. Replace them with default values
      3. Leave them unchanged
      4. Ignore them
    • Correct Answer: 2. Replace them with default values
  • Question 3: Which of the following is a key consideration in integrating data from multiple sources?
    • Options:
      1. Source file name
      2. Data consistency and format
      3. The color of the data visualization
      4. Data encryption algorithms
    • Correct Answer: 2. Data consistency and format

Note - Auto reject candidates if scores less than 70% in this section

One way video interview

Recruitment Bullet

Use tools like hirevue, whitecarrot.io to ask candidates pre-recorded questions about their experience and skills.

Recruitment Bullet

Use sample question given in scorecard.

Collect other information 

Recruitment Bullet

Collect data from shortlisted candidates, such as salary expectations and visa status.

Manual candidate profile shortlisting:

Recruitment Bullet

Thoroughly review the CVs of the top scoring candidates from the automated process

Recruitment Bullet

Look for evidence of the required skills, experience, and achievements

Recruitment Bullet

Review the candidate’s portfolio or GitHub repositories to see examples of their work.

Schedule recruiter calls with the candidate

Recruitment Bullet

Use a tool like calendly or whitecarrot to allow candidates to self-schedule calls based on your availability

Recruitment Bullet

Confirm the call details (date, time, dial-in info) with the candidate via email

What questions to ask in the recruiter phone screen?

Recruitment Bullet

 Use scorecard for rating candidates for recruiter

Recruitment Bullet

Sample scorecard : 

Criteria Sample Question Rating (1-5) Comments
Technical Skills "How do you handle data integration from multiple sources?"
SQL Proficiency "What SQL queries do you typically use for data extraction?"
ETL Knowledge "Explain the ETL process using Talend or Informatica."
Problem-Solving Ability "How do you resolve performance issues in ETL pipelines?"
Communication Skills "How do you explain complex data processes to non-technical teams?"
Cultural Fit "How do you collaborate with cross-functional teams?"
Recruitment Bullet

Check for consistency in responses from the candidates.

Recruitment Bullet

Record such scorecards in an ATS like whitecarrot or use google doc