Job Description :
Role: ETL Test Lead
Experience: 10+ Years
Location: Strongsville, OH
- 10 years progressive experience and responsibilities in the area of ETL Testing.
- Test ETL Data warehouse components.
- Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
- Executing backend data-driven test.
- Create, design and execute Test plans, Test harnesses and Test cases.
- Identify, troubleshoot and provide solutions for potential issues.
- Approve requirements and design specifications.
- Test flat file data transfer ??
- Pre-Data Migration Testing
????-?? Formal Data Migration Design Review
- ?????????Post-Data ?????Migration????? ??Testing
???????????- Data Migration User Acceptance Testing
????- Production Migration?
1) Verify that data is transformed correctly according to various business requirements and rules.
2) Make sure that all projected data is loaded into the data warehouse without any data loss and truncation.
3) Make sure that ETL application appropriately rejects, replaces with default values and reports invalid data.
4) Make sure that data is loaded in data warehouse within prescribed and expected time frames to confirm improved performance and scalability. Apart from these 4 main ETL testing methods other testing methods like integration testing and user acceptance testing is also carried out to make sure everything is smooth and reliable.