ETL Tester

Chicago, IL, US

ETL Tester - (CREQ128595)


Very Strong ETL/Data Warehouse Testing.
Hands on experience in IBM Datastage tool.
Very strong knowledge in Oracle database.
Very Strong knowledge in UNIX commands.
Sound Knowledge API testing (JSON, XML).
Automation tools like Selenium(Nice to have).
JIRA and Agile Methodology.
Strong communication skills to interact with Business and technology teams.
Previous experience in Banking/Wealth management.
Job Description
Ensure completeness of data by validating complex COUNT queries at different stages using SQL queries.
Ensuring the Correctness of data by validating the Enrichment and Transformation logics manually by using complex MINUS queries by Joining multiple oracle tables.
Created complex oracle SQLs to validate the data loaded in DWH by ETL tools like IBM DataStage.
Validating Change Data Capture (CDP)or SCD (Slowly Changing Dimension) data based on transformation Logics.
Validating Reference data.
Good Understanding of MDM
Test data Creation.
Good understanding of Web Services API validation using Postman using JSON and XML data.
Validating noSQL data created in Marklogic database or any noSQL Database.
Validating the Source files in UNIX for completeness of the files using wc -l and file formats, header, and footer validations.
Sound knowledge in UNIX commands.
Ensuring the Quality of data by processing manually created data to ensure Insert/Update and Reject scenarios
Preparing complex test cases to verify the enrichment logics on data in the database.
Validating UPSERT concept by validating data flagging system.
Defined a testing strategy to validate data which are in files.
Coordinating with the Business analyst to understand the functions of Business functionalities and the clients requirements.
Need to ensure Data Transformation, Data Quality and Data completeness during testing
Creating Business Use cases and Data Analysis report for Business Team.
Good understanding of data Migration and Test environments like SIT, UAT.
Providing application and technical knowledge to offshore
Reviewing of test cases prepared by offshore, enable then to ensure no slippage in daily deliverables.
Preparation of Test plan/Strategy and test closure during project releases.
Preparation of DSR and WSR to showcase my teams effort to client/manager.

Primary Location

: US-IL-Chicago


: Full Time

Job Type

: Experienced


: No

Job Posting

: 14/04/2022, 4:46:21 PM

Apply Now Back to Results