SAFIYA A

SAFIYA A

ETL TESTER
India
Tamil, Hindi, English

نبذة عني

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…

الخبرة

ETL Tester

Entrust Software and IT Services, Chennai
Nov 2023 - حتى الآن · 2 سنوات 8 أشهر

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

Resource Pte. Ltd, Singapore
Jan 2023 - حتى الآن · 3 سنوات 6 أشهر

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

Entrust Software and IT Services, Chennai
Mar 2019 - Mar 2022 · 3 سنوات

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

Anthem, US
Oct 2020 - Mar 2022 · 1 سنة 4 أشهر

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

Entrust Software and IT Services, Chennai
Mar 2019 - Mar 2022 · 3 سنوات

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

Onemedifund, Australia
Sep 2020 - Mar 2019 · 1 سنة 6 أشهر

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.

المهارات

التوثيق أوراكل بايثون (لغة برمجة) لغة الاستعلامات الهيكلية (SQL) خادم SQL أجايل استخراج البيانات سلامة البيانات التحقق من البيانات إدارة العيوب خدمات تكامل SQL Server تاليند حالات الاختبار كونفلوينس باور بي آي ETL testing BI testing Data Warehouse testing Informatica testing SQL Scripting Unix testing Functional testing Regression testing UI Validation Manual testing Informatica (Power Center) JIRA SQL Developer WinSCP SSMS Pycharm Snowflake Unix PLSQL Test Scripts SQL Queries PLSQL Stored Procedures Unix Commands ETL Mappings Reusable Transformations Backend Testing Data Loading Operations Test Scenarios Test Plans Sprint Planning User Stories Set Operators Subqueries Functions Bug Tracking System Sprint Demos Walkthroughs Data Warehouses Front-Office Databases File Validation Data Mapping Sheets RSD Test Coverage Business Analysts Team Leads Sprint Backlog Defect Logging Attachments Development Teams Product Owners Input Gathering Test Case Execution Internal Bug Tracking System Informatica Power Center PyCharm Pandas
الإبلاغ عن هذا الملف الشخصي؟