ETL Tester

ETL Tester (CREQ
128595) Skills

• Strong communication skills to interact with Business and technology teams.
• Previous experience in Banking/Wealth management.

• Ensure completeness of data by validating complex COUNT queries at different stages using SQL queries.
• Ensure the correctness of data by validating the enrichment and transformation logics manually via complex MINUS queries joining multiple Oracle tables.
• Created complex Oracle SQLs to validate the data loaded in DWH by ETL tools like IBM Data Stage.
• Validate Change Data Capture (CDC) or SCD (Slowly Changing Dimension) data based on transformation logics.
• Validate reference data.
• Good understanding of MDM.
• Test data creation.
• Good understanding of Web Services API validation using Postman with JSON and XML data.
• Validate No
  
  SQL data created in Mark Logic database or any No
  
  SQL database.
• Validate source files in UNIX for completeness using wc
  -l and file format, header, and footer validations.
• Sound knowledge of UNIX commands.
• Ensure the quality of data by processing manually created data to confirm insert/update and reject scenarios.
• Prepare complex test cases to verify enrichment logics on data in the database.
• Validate UPSERT concept by validating data flagging system.
• Define a testing strategy to validate data which are in files.
• Coordinate with the Business Analyst to understand business functionalities and client requirements.
• Ensure data transformation, data quality, and data completeness during testing.
• Create business use cases and data analysis reports for the business team.
• Good understanding of data migration and test environments like SIT and UAT.
• Provide application and technical knowledge to offshore teams.
• Review test cases prepared by offshore to ensure no slip‑through in daily deliverables.
• Prepare test plans/strategy and test closure during project releases.
• Prepare DSR and WSR to showcase the team’s effort to client/manager.