Gurugram, Haryana, India
•Migrating historical and incremental data related to revenue management from on-prem Oracle to Snowflake(cloud) using IICS as ETL tool. •Involved in test planning and creating test cases/scripts for entities in work-streams across the project. •Validating the migrated data by preparing SQL queries according to business requirements.Handled the testing of most complex entities and work-streams in the project. •Worked on the identification and analysis of defects/data discrepancies and reported to respective teams. •Hands-on experience with Relational Database Management System, Snowflake /Star schema , OLAP/OLTP systems ,Data warehouse and ETL testing concepts. •Knowledge on Cloud terminologies, tools and usage. •Experience in dashboards/ report testing including UI , KPI and data testing.
•Data migration from Teradata to GCP Big-Query using CDAP pipelines and migrating data within Big-Query using Cloud Data Fusion pipelines and Airflow. •Involved in creating test cases, test plans, test data, test validation and reporting status. •Involved in end-to-end ETL testing for different subject areas on GCP BigQuery. •Using ALM/QC for handling test cases and logging and tracking defects. Raising Jira tickets for reporting data issues.Using SAP Power-Designer to understand Data Models.