About Me
Over 5 years of experience in ETL, Database, Data Warehouse, and BI Report testing. Hands-on expertise in Informatica, Talend, Power BI, SQL, PLSQL, UNIX, and Python. Proficient in SQL scripting, including Joins, Aggrega…
Over 5 years of experience in ETL, Database, Data Warehouse, and BI Report testing. Hands-on expertise in Informatica, Talend, Power BI, SQL, PLSQL, UNIX, and Python. Proficient in SQL scripting, including Joins, Aggregates, Analytical Functions, and CTEs. Familiar with data validations in Snowflake, Oracle, and SQL Server. Involved in Power BI reports and dashboard validations. Strong experience in creating and executing test cases, test scripts, and documenting results. Comfortable with defect management using JIRA and documentation with Confluence. Experienced in Agile environments with strong communication and collaboration skills. Proficient in Python, Pandas and used functions like merge, shape, len, Read_csv, Read_SQL, etc.
Experience
ETL Tester
Working as an ETL Tester in Entrust Software and IT Services, Chennai from March 2019 to March 2022 and again started from November 2023 to till date.
Reviewed mapping sheets in accordance with the RSD, test plans, and test cases to ensure accurate test coverage and alignment with requirements.
Actively contributed to sprint planning sessions by providing estimates and planning for QA tasks.
Collaborated with business analysts and team leads to analyze and clarify user stories within the sprint backlog.
Conducted data validation and backend testing by developing advanced SQL queries using joins, set operators, subqueries, and functions.
Created PLSQL stored procedure for Regression execution.
Logged critical defects in JIRA with detailed documentation and relevant attachments; ensured prompt assignment to development teams.
Delivered sprint-end demos and walkthroughs to product owners to showcase completed features and gather input.
Conducted testing on numerous intricate ETL mappings and reusable transformations for daily data loading operations.
Leveraged ETL procedures to extract data from front-office database systems, transferring it to the target data warehouse through complex SQL queries.
Developed test case scenarios, executed them, and managed identified defects within an internal bug tracking system.
Conducted backend testing by executing Oracle SQL queries to retrieve data from the database, ensuring alignment with expected outcomes generated by the process.
Used Unix commands to navigate and validate the files in Unix environment.
ETL Tester
Proficient in crafting and executing intricate SQL queries to verify actual versus expected outcomes and to validate data integrity from source to target., Skilled in collaborating as a team member to adhere to project timelines and fulfill deliverables as committed., Proficiency in drafting test scenarios and cases, and creating/maintaining test scripts aligned with business and functional requisites., Involved in Power BI Reports and Dashboard Testing., Validated data in Snowflake data Warehouse with the help of SQL., Created Python Pandas Scripts for validating data between flat files to table and tables in heterogeneous databases., Reviewed mapping sheets in accordance with the RSD, test plans, and test cases to ensure accurate test coverage and alignment with requirements., Actively contributed to sprint planning sessions by providing estimates and planning for QA tasks., Collaborated with business analysts and team leads to analyze and clarify user stories within the sprint backlog., Conducted data validation and backend testing by developing advanced SQL queries using joins, set operators, subqueries, and functions., Created PLSQL stored procedure for Regression execution., Logged critical defects in JIRA with detailed documentation and relevant attachments; ensured prompt assignment to development teams., Delivered sprint-end demos and walkthroughs to product owners to showcase completed features and gather input., Conducted testing on numerous intricate ETL mappings and reusable transformations for daily data loading operations., Leveraged ETL procedures to extract data from front-office database systems, transferring it to the target data warehouse through complex SQL queries., Developed test case scenarios, executed them, and managed identified defects within an internal bug tracking system., Conducted backend testing by executing Oracle SQL queries to retrieve data from the database, ensuring alignment with expected outcomes generated by the process., Used Unix commands to navigate and validate the files in Unix environment.
ETL Tester
Working as an ETL Tester in Entrust Software and IT Services, Chennai from March 2019 to March 2022 and again started from November 2023 to till date.
Reviewed mapping sheets in accordance with the RSD, test plans, and test cases to ensure accurate test coverage and alignment with requirements.
Actively contributed to sprint planning sessions by providing estimates and planning for QA tasks.
Collaborated with business analysts and team leads to analyze and clarify user stories within the sprint backlog.
Conducted data validation and backend testing by developing advanced SQL queries using joins, set operators, subqueries, and functions.
Created PLSQL stored procedure for Regression execution.
Logged critical defects in JIRA with detailed documentation and relevant attachments; ensured prompt assignment to development teams.
Delivered sprint-end demos and walkthroughs to product owners to showcase completed features and gather input.
Conducted testing on numerous intricate ETL mappings and reusable transformations for daily data loading operations.
Leveraged ETL procedures to extract data from front-office database systems, transferring it to the target data warehouse through complex SQL queries.
Developed test case scenarios, executed them, and managed identified defects within an internal bug tracking system.
Conducted backend testing by executing Oracle SQL queries to retrieve data from the database, ensuring alignment with expected outcomes generated by the process.
Used Unix commands to navigate and validate the files in Unix environment.
ETL Tester
Proficient in crafting and executing intricate SQL queries to verify actual versus expected outcomes and to validate data integrity from source to target., Skilled in collaborating as a team member to adhere to project timelines and fulfill deliverables as committed., Proficiency in drafting test scenarios and cases, and creating/maintaining test scripts aligned with business and functional requisites., Involved in Power BI Reports and Dashboard Testing., Validated data in Snowflake data Warehouse with the help of SQL., Created Python Pandas Scripts for validating data between flat files to table and tables in heterogeneous databases., Reviewed mapping sheets in accordance with the RSD, test plans, and test cases to ensure accurate test coverage and alignment with requirements., Actively contributed to sprint planning sessions by providing estimates and planning for QA tasks., Collaborated with business analysts and team leads to analyze and clarify user stories within the sprint backlog., Conducted data validation and backend testing by developing advanced SQL queries using joins, set operators, subqueries, and functions., Created PLSQL stored procedure for Regression execution., Logged critical defects in JIRA with detailed documentation and relevant attachments; ensured prompt assignment to development teams., Delivered sprint-end demos and walkthroughs to product owners to showcase completed features and gather input., Conducted testing on numerous intricate ETL mappings and reusable transformations for daily data loading operations., Leveraged ETL procedures to extract data from front-office database systems, transferring it to the target data warehouse through complex SQL queries., Developed test case scenarios, executed them, and managed identified defects within an internal bug tracking system., Conducted backend testing by executing Oracle SQL queries to retrieve data from the database, ensuring alignment with expected outcomes generated by the process., Used Unix commands to navigate and validate the files in Unix environment.
ETL Tester
Proficient in crafting and executing intricate SQL queries to verify actual versus expected outcomes and to validate data integrity from source to target., Skilled in collaborating as a team member to adhere to project timelines and fulfill deliverables as committed., Proficiency in drafting test scenarios and cases, and creating/maintaining test scripts aligned with business and functional requisites., Involved in Power BI Reports and Dashboard Testing., Validated data in Snowflake data Warehouse with the help of SQL., Created Python Pandas Scripts for validating data between flat files to table and tables in heterogeneous databases., Reviewed mapping sheets in accordance with the RSD, test plans, and test cases to ensure accurate test coverage and alignment with requirements., Actively contributed to sprint planning sessions by providing estimates and planning for QA tasks., Collaborated with business analysts and team leads to analyze and clarify user stories within the sprint backlog., Conducted data validation and backend testing by developing advanced SQL queries using joins, set operators, subqueries, and functions., Created PLSQL stored procedure for Regression execution., Logged critical defects in JIRA with detailed documentation and relevant attachments; ensured prompt assignment to development teams., Delivered sprint-end demos and walkthroughs to product owners to showcase completed features and gather input., Conducted testing on numerous intricate ETL mappings and reusable transformations for daily data loading operations., Leveraged ETL procedures to extract data from front-office database systems, transferring it to the target data warehouse through complex SQL queries., Developed test case scenarios, executed them, and managed identified defects within an internal bug tracking system., Conducted backend testing by executing Oracle SQL queries to retrieve data from the database, ensuring alignment with expected outcomes generated by the process., Used Unix commands to navigate and validate the files in Unix environment.
ETL Tester
Proficient in crafting and executing intricate SQL queries to verify actual versus expected outcomes and to validate data integrity from source to target., Skilled in collaborating as a team member to adhere to project timelines and fulfill deliverables as committed., Proficiency in drafting test scenarios and cases, and creating/maintaining test scripts aligned with business and functional requisites., Involved in Power BI Reports and Dashboard Testing., Validated data in Snowflake data Warehouse with the help of SQL., Created Python Pandas Scripts for validating data between flat files to table and tables in heterogeneous databases., Reviewed mapping sheets in accordance with the RSD, test plans, and test cases to ensure accurate test coverage and alignment with requirements., Actively contributed to sprint planning sessions by providing estimates and planning for QA tasks., Collaborated with business analysts and team leads to analyze and clarify user stories within the sprint backlog., Conducted data validation and backend testing by developing advanced SQL queries using joins, set operators, subqueries, and functions., Created PLSQL stored procedure for Regression execution., Logged critical defects in JIRA with detailed documentation and relevant attachments; ensured prompt assignment to development teams., Delivered sprint-end demos and walkthroughs to product owners to showcase completed features and gather input., Conducted testing on numerous intricate ETL mappings and reusable transformations for daily data loading operations., Leveraged ETL procedures to extract data from front-office database systems, transferring it to the target data warehouse through complex SQL queries., Developed test case scenarios, executed them, and managed identified defects within an internal bug tracking system., Conducted backend testing by executing Oracle SQL queries to retrieve data from the database, ensuring alignment with expected outcomes generated by the process., Used Unix commands to navigate and validate the files in Unix environment.