Associate – Testing

ETL Testers with Advanced SQL knowledge.

Job Description 


Elait is a leading technology and services company driven to deliver value for money by focusing on delivery excellence and client collaboration. The organization endeavors to provide a fair and rewarding environment for our people that encourages technical and personal development through training, mentoring, and opportunities to work on cutting-edge solutions. Our goal is to be accepted as “trusted experts” who deliver solutions that anticipate and respond to our customers’ needs and provide advice, on a proactive basis, for continuous improvement.

Our philosophy: Elait believes in listening to our customers and working in collaboration to satisfy their needs. We achieve this via understanding, planning and delivering to the very highest standards and with the best and most appropriate team. This, along with our expert processes and adherence to best practices are all key to successful deliveries till date.

Industry Vertical we consult includes the following viz;
o Finance & Banking
o Gaming & Betting
o Retail
o Healthcare & Wellness
o Telecom
o Media & Entertainment

Roles and responsibilities:

  • Should work as a team player.
  • Should write test cases as per the requirement (Simple to Complex).
  • BI report testing.
  • Participate in peer reviews.
  • Write queries to validate the transformations in the mapping.
  • Helps the juniors in query writing.
  • Should participate in the BA discussions.

Mandatory Skills: 

  • Must have hands-on experience in SQL queries.
  • All types of Joins, conditions in joins, subqueries, nested sub queries.
  • Group By, Having clause.
  • Set operators, rank, dense rank.
  • Functions (date, string, casting, conversion etc.), date-time manipulation, case statements, Except, Not In.
  • Strong in SQL queries especially advanced queries like operators, joins, sub-queries, nested sub-queries, corelated queries, clustered, non-clustered indexes.
  • Common Table Expressions, recursive CTE’s, temporary functions, temporary tables.
  • Good in ETL- DW, report testing.
  • Good test design and defect analysis skills.
  • Good in communication skills.
  • Good understanding in Agile process.

Good to have:

  • Stored Procedures and data analysis skills

Qualifications and Education Requirements

  • Any professional degree or equivalent.

Additional Notes

Should be confident enough to interact with clients.

Working model: Strictly from office premises.
Interview Process: First – Technical round, Second – Managerial Round, Third – Leadership/Client Round.