Senior Quality Assurance Engineer - Test Lead Big Data And Etl Tester
Current• Quickly understood the business concepts and involved in working end to end testing.• Involved in Test case validation and execution in JIRA and Worked with ICEDQ tool for Data Validation purpose.• Analyzed the use cases provided by analysts and wrote test cases.• Reviewed the test cases written for Integration Testing, Regression testing and documented them accordingly.• Experience in Data Analysis, Data Validation, Data cleansing, Data verification and identifying data mismatches.• Experience in importing and exporting the Data from relational databases into Hadoop cluster using Sqoop.• Expert in writing complex SQL queries to check the integrity of data to perform ETL testing.• Experience in working on data integration projects.• Experience in validating tables with partitions, bucketing, and loading data into HIVE tables.• Worked on Big data/Hadoop Ecosystem– Hive database, impala database, sqoop, HDFS.• Worked on AWS cloud – S3, Lambda, Step functions, Athena query engine for validating ETL process• Worked on relational databases like Teradata, Oracle 10g/11g, SQL server in the process of validating the data.• Involved in the Agile Methodology - Daily standup Meetings, grooming calls, Sprint Planning activities and responsible for sending the status updates to all the stake holders.• Tracking, Debugging and Retesting the Defects in JIRA promptly.• Carry out regression testing every time changes are made• Coordinating with development team, onsite and other downstream, upstream applications to ensure full test coverage – from writing test plan, test cases, validating test scripts and test cases, Test execution, tracking defects – closure• Executed SQL/Hadoop-HiveQL Queries to verify the data completeness.• Handling the data issues and discussing with all the other application stakeholders.• Involved in testing of XML files• Experience working with build & deployment tools like GitLab, IntelliJ and Job monitoring tools like Airflow, Jenkins.