Dyuti Dutta

Working as a Test Engineer in a data migration project of a beauty product-based US Client from SAP ECC to SAP S4 where the scope is to analyze the mismatching field values, build interactive report in Excel, support Data Team and present it before business and other stakeholders and try build confidence with the help of report, post data is migrated for different conversion objects. Key Gains: Column Level data profiling, content type, redundancy check using Information Steward Tool; Creating different views in Information Steward applying joins, creating custom columns, getting exposure to use Decode function and SQL query; Load and Cleanse data using Power Query ETL tool, data modelling, cross filters using Power BI Desktop, Merge and Append columns by joining tables according to requirements in Power Query; Advance Excel Compare data using VLOOKUP, Conditional Formatting, Pivot table to check count and chart representation and data bar representation to highlight the field level mismatches found; Macros-enabled, VBA programmed Validation to automate manual tasks.

Worked as Test Engineer for a US based Global Clothing brand on a data migration project for migrating workloads running on Google Cloud Platform (GCP) to Azure platform and migrate in Scope Tableau reports to MicroStrategy on Azure Platform. Key Gains: Knowledge and hands-on expertise in framing SQL queries and Software Testing Life Cycle (STLC); ETL Datawarehouse backend testing; Experience in preparing Report, log defect using Test Management tool JIRA; Agile methodology project; Validation of data migration from GCP to Azure system and analyze the mismatching data fields value; Apply transformation using complex SQL query and validate data in cleaned layer; Validate data transformation for reporting dashboards in curated layer; Validate Tableau dashboard with MicroStrategy reports built on top of semantic layer; Automating manual task for effective execution.

Infosys provided Industry level quality training on Java Fundamentals, RDBMS theory and Hands on, SQL query for analysis, Angular.