Sachinkumar Dodamani

Experience

• 

  Quest Global

  Nov 2016 - Aug 2017

  Test Engineer

  Contributed to Manual Testing activities, ensuring the quality and reliability of software products.

• 

  RLE INTERNATIONAL Group

  Sept 2017 - Apr 2018

  Test Engineer

  As a Functional Tester, your roles and responsibilities revolve around ensuring that software applications meet specified functional requirements and perform as intended. Here's a breakdown of typical roles and responsibilities for a Functional Tester:Requirement Analysis:Thoroughly analyze functional requirements and specifications to understand the application's expected behavior.Test Planning:Develop comprehensive test plans outlining the scope, approach, resources, and schedule for functional testing.Test Case Design:Create detailed test cases based on functional specifications, ensuring full coverage of business requirements.Test Execution:Execute test cases to validate that the application functions according to specifications.Defect Identification:Identify and document defects, ensuring clear and concise communication to development teams.Regression Testing:Perform regression testing to ensure that new enhancements or bug fixes do not adversely affect existing functionality.User Acceptance Testing (UAT):Collaborate with end-users to conduct UAT and gather feedback on the application's functionality.Cross-Functional Collaboration:Work closely with developers, business analysts, and other stakeholders to resolve issues and clarify requirements.Test Status Reporting:Provide regular updates on test progress, including test execution status, defect status, and any risks or issues.Test Documentation:Maintain comprehensive documentation, including test plans, test cases, and test execution results.Knowledge Sharing:Share knowledge and best practices with team members to enhance the overall testing process. Show less

• 

  SLK

  Jul 2018 - Sept 2019

  Software Test Engineer

   Understanding the transformation rules in mapping documents as per client requirements. Understanding the Informatica mappings and workflows. Developing Test Scenarios and Test Cases for each sprint. Writing the test cases based on Functional specification and business requirement documents. Uploading test cases in to HPALM. Execution of Test Cases and reporting the bugs through defect tracking tool-HPALM. Validating data in target database according to business rules. Preparing SQL queries to validate the ETL processed data in target database. Verifying the column mapping between source and target database. Verifying the records count between source and target databases. Show less

• 

  OSI Digital

  Oct 2019 - Sept 2022

  Software Test Engineer

  • Strong exposure and experience in ETL/DWH testing and writing SQL Queries. • Creating Test strategy, Test scenario, Test cases and Test data.• Well versed in Logging defects, Bug-track, and escalate (when necessary) issues identified during test cycles. • Preparing SQL queries to validate the ETL processed data in target database.• Verifying the column mapping between Source and Target database.• Good knowledge on Data Warehouse concepts like Star schema, Snowflake schema, Fact table, Dimension table etc.• Experience on ORACLE and having complete BUG LIFE CYCLE knowledge.• Basic knowledge on Workflow Manager, Workflow Monitor in INFORMATICA ETL Tool.• Experience with detecting the defects, presenting the defect status reports, interacting with developers to resolve the defects.• Experience in Functional Testing, Integration Testing, System Testing, Regression Testing. • Good knowledge in STLC (Software Testing Life Cycle) and Agile Methodologies.• Experience in coordinating with Team lead and clients for day to day technical issues. Show less

• 

  Cognizant

  Oct 2022 - now

  Associate

  • Worked on Migration Project where data is transferred from on premise (GP) to AWS Cloud (EDP).• Understanding the flow of data from source to target by using the feature document.• Validating the data flow from source to target and verifying the transformations are working as per the functional requirement defined in feature document and • Documenting the test results from various environments (QA/DEV) and checking the data with post prod migration• Working with AWS tools like GLUE, S3, REDSHIFT, LAMDA FUNCTIONS, STEP FUNCTIONS, CLOUDWATCH DYNAMODB, ATHENA and SNS notifications • I develop the test cases and undergo peer review. Once it is approved by team lead it is uploaded in JIRA. In addition, we start executing the test cases.• Querying the data using SQL script in DBeaver, HIVE and HBASE to check the counts, comparing the data, checking duplicates and null. Checking audit entry of data.• Any deviations between actual and expected results, I raise the BUG report to developer and keep on following until it gets resolved.• At the end of day, I submitted status report to Team lead. Show less