ETL Test Lead

Required Experience:

- Strong experience in ETL testing with experience in financial domain

- Significant understanding on Budget & Forecasting, Actuarial

- Experience with Data warehouse ETL testing and Strong Analytical Skills

- Experience in understanding DW concepts

- Should have strong SQL skills (Oracle, DB2, SQL Server or equivalent)

- Experience in data analysis/Data Modelling

- Experience in handling PII data (Production secure Data)

- Strong communication and analytical skills

- Experience in Oracle Analytics Cloud (OAC) reports / Tableau testing

- Good knowledge in ETL test automation testing tool - ETL Validator

- Experience in UNIX and scheduling tools (Ex: Autosys)

- Solid knowledge to stratergize testing on running/analysing Batch Files,Interfaces,Upstream/Downstream feeds

- Experience in testing of ETL test scripts based on technical specifications/Technical Design Documents and Source to Target mappings

- Ability to query database to validate data / ability to view and compare data files to identify differences

- Ability to use the appropriate automation tools from the available options within TIAA and drive automation planning, Implementation and Execution.

- Ability to work with 3rd party vendors when necessary, to start services, run jobs, etc. As we are testing in SaaS environment, we have limited control over certain aspects of the environment.

- Experience working in an Agile/Scrum/Waterfall development process.

Technical Skills

- Excellent understanding of Finance domain

- Good understanding of data warehouse and ETL process; and related testing processes

- Good understanding on Batch processes and related testing

- Excellent in SQL and data analysis skills

- Excellent in MS excel and other MS office applications

- Automation Scripting Experience Selenium, ETL Validator or similar toolset

Nice to have

-Testing Certifications Ex: ISTQB, HP UFT Certifications, PMP and Oracle Certifications etc.