About Me
9+ years of experience in ETL testing, design and engineering including a thorough understanding of System, Functional , Automation, ETL, SIT , UAT ,Regression testing methods started my career as data Engineer (SQL deve…
9+ years of experience in ETL testing, design and engineering including a thorough understanding of System, Functional , Automation, ETL, SIT , UAT ,Regression testing methods started my career as data Engineer (SQL developer, big data , hadoop, hive,AWS).
ETL and Automation Testing experience with MDM using Waterfall, Agile/Scrum methodology. Have extensive experience directing all aspects of Quality Assurance functions in a variety of industries
Have strong data Analytical skills, problem-solving skills, Communication and presentation skills.
Experience to manage various phases of the Software Testing Life Cycle (STLC) and Software Develpement life cycle (SDLC).
Analysing the bug and reporting the same to the team and stakeholders.
Experience in Test Analysis, Test Planning and Strategy, Requirement tracebility, Test Environment Setup and Test Case Design,Defect Life Cycle, Test Execution, and End of Test Case and admistering it into JIRA ,Xray, HP-ALM
Developed UNIX Shell Scripts for batch process automation, and also in programming languages such as C,Python, Java.
Experience in Hadoop system Data lake , Data warehouse , Big data (Spark) , Azure DevOps, Docker, and Docker-Compose
Have understanding of API testing using REST API using Postman.
Hands on experience with UI tests using Selenium Webdriver and Robotframework.
experience with GIt hub in order to pull the code and review it and analysing the code quality and did CI/CD using Jenkins.
Good understanding of Data Warehouse concepts (Star , snowflake , SCD )and data modelling.
Good Understanding with AWS S3 buckets , kinesis, athena,
Good at writing and optimizing SQL queries(All joins, views, Stored procedures) and CTE and Hive HQL
Have done reconciliation of large volume of data for KPI which are the key metrics for trends. Creating the data sample, validating and verification of data,
Experience in System integration testing, User acceptance testing, unit testing, Regression and Smoke Testing, Report testing,Functional testing.
Experience
ETL tester
Worked as a ETL tester for 6 month on Contract basis. Written Sql queries with the test cases based on the STM document and its KPI. Have experience working with big data, data mart, data warehouse, snowflake schema. Experienced with end to end source to target table testing.
Quality Analyst and ETL tester
Wrote test scripts using Robot Framework (Selenium Library, WebDrivers) for UI automation.
Used Qtest for writing test cases, executing test cases, raising defects, and linking them with JIRA.
Performed CI/CD integration with Jenkins.
Reported bugs to stakeholders and the team.
Retested issues after fixes were completed.
Worked with on-premise and on-cloud environments.
Wrote SQL queries in SQL Developer to check data between on-premise and on-cloud systems.
Performed E2E testing on ETL along with MDM.
Performed regression testing, UAT testing, and API testing.
ETL Tester
Performed data cleaning and data validation.
Understood data workflow from one system to another.
Created automated test cases with continuous improvements.
Performed end-to-end testing with MDM.
Developed test strategy, test plans, and test cases based on requirement and mapping documents.
Worked with data extracted from Oracle, flat files, and SQL Server.
Completed test documentation and wrote test cases.
Worked in SIT and UAT.
Used HP-ALM to track defects and generate defect summary reports.
Wrote complex SQL in BigQuery.
Analyzed test results and debugged observed issues.
Generated defect reports.
Verified fixed issues and updated pre-existing defect reports.
Created test reports.
Worked with DWH and SCD concepts.
Created and tested UNIX shell scripts as part of the ETL testing process.
Used Python and Python libraries (Numpy, Panda) for design, coding, debug operations, reporting, and data analysis.
Worked with AWS S3 and PySpark queries for big data.
Used Data Studio, Qlik Report, and Tableau.
Performed functional testing, regression testing, sanity testing, smoke testing, Robot Framework with Selenium, and data reconciliation testing.
Performed API automation testing with Postman.
Software Tester
Performed data cleaning and data validation.
Performed E2E testing with MDM.
Developed test strategy, test plans, and test cases based on requirement and mapping documents and their transformation logics.
Completed test documentation and wrote test cases.
Created automated test cases and sample data considering positive and negative cases.
Used Jira to track defects and generate defect summary reports.
Worked in a data lake and Hadoop environment (Spark).
Wrote HQL to test target data in Hive.
Used Data Studio, Qlik Report, and Tableau.
Performed functional testing, regression testing, sanity testing, smoke testing, and Robot Framework with Selenium.
Documented test procedures for developers and future testing.
Used Python (pandas) and PySpark.
Performed API automation testing.
Used SQL programming.
Worked with AWS S3 for big data.
Used Unix/Linux shell scripting, AbInitio tool, and Hadoop commands.
Software Engineer
Performed data cleaning and data validation.
Developed test strategy, test plans, and test cases based on requirements and mapping documents.
Completed test documentation and wrote test cases.
Worked with ETL workflow and exposure to fact, dimension table, and MDM.
Analyzed test results and debugged observed issues.
Generated defect reports.
Verified fixed issues and updated pre-existing defect reports.
Created test reports.
Worked with Hadoop system (Data Lake, PySpark), Pentaho tool, and AWS S3.
Performed functional testing, regression testing, sanity testing, smoke testing, and Robot Framework with Selenium.
Wrote Python program scripts for testing.
Used Oracle query tools to validate reports and troubleshoot data quality issues.
Data Engineer
Understood business requirements and created test cases.
Executed test cases using JIRA test management tool.
Performed web services testing using Insomnia and Postman.
Developed complex SQL queries and PL/SQL to validate data in source and target tables and in the data warehouse and MDM.
Analyzed test results and debugged observed issues.
Generated defect reports.
Verified fixed issues and updated pre-existing defect reports.
Created test reports.
Worked with PySpark and AWS S3 bucket.
Executed UNIX scripts to check data availability and for data reconciliation.
Used C and C++ OOPs concepts.
Performed functional testing, regression testing, sanity testing, smoke testing, and Robot Framework with Selenium.
Test planning ,writing Test case sand executing it using JIRA test management tool.
Performed database testing and functional testing.
Wrote SQL queries for data testing.
Reported bugs and retested issues.
Used basic Python scripting to deal with data.
Used C and C++ OOPs concepts.
Test planning ,writing Test case sand executing it using JIRA test management tool.
Performed database testing and functional testing.
Wrote SQL queries for data testing.
Reported bugs and retested issues.
Used basic Python scripting to deal with data.
Used C and C++ OOPs concepts.