• Understanding of BSD and TSD
• Analysis of Business transformation logic using Bteq Scripts
• Preparation of Test Plan & Test Approach
• Preparation of Test cases with SQL Queries
• Preparation of Test Data based on the requirement
• Hands on in preparation of RTM, Test Closure Document, uploading TC into RQM
• Performed validations like Count, load log Key, duplicate, RI, Audit Balance, Impacted column, Non-Impacted column verification & project specific Business validations & regression testing for History & Incremental Fixes
• Identification of Defects and notified to Dev Team through Clear Quest
• Participation in Defect Triage call & Client status call

• Understanding the client requirements.
• Verifying the column mapping between source and target databases.
• Running the jobs ETL process in Informatica BDE
• Verifying the data which is loaded into target database.
• Executed test cases through TFS MTM
• Run the Informatica Workflows for ETL Process.
• Validated data in Target database according to business rules.
• Prepared Hive queries and executed to validate the ETL processed data in target database.
• Interactions with BA & Dev teams to resolve the issues.
• Reporting daily testing status report.

Defect Analyzing and Reporting in MTM

• Mastering DELL & EMC customers and building 360° customer view
• Deploy Customer data Governance (globally & regionally)
• Identity management , Matching methodology & results to manage local files delivery
• Additional & new data feeds integration & governance
• Linking online digital behavior sources into accounts universe for Dell & EMC
• Enable linkage between online info above and offline sales & marketing history from Dell & EMC
• Identify & classify accounts by customer journey stages (Silent, explore, Discover, Educate, Compare, Buy, Grow) to be customer centric

• Understanding the client requirements.
• Verifying the column mapping between source and target databases.
• Running the Spark jobs for ETL process
• Verifying the data which is loaded into target database.
• Executed test cases through TFS MTM
• Run the Informatica Workflows for ETL Process.
• Validated data in Target database according to business rules.
• Prepared Hive queries and executed to validate the ETL processed data in target database.
• Interactions with BA & Dev teams to resolve the issues.
• Reporting daily testing status report.
• Defect Analyzing and Reporting in MTM