
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
QA Automation Engineer with 7+ years in ETL, Oracle & SQL
To work in an environment that provides a challenging and rewarding career ensuring a high-level job satisfaction. To give effective as well as efficient efforts towards attainment of organizational goals with exploring wide scope of knowledge and intelligence. Having 6+ years of relevant experience as an ETL Tester with good knowledge in Oracle and ETL concepts. Having 4 Month experience in API testing. Well-versed with all stages of software development life cycle (SDLC). Created ETL test scenario document and test case document and also validated ETL Mapping rules to the functionality of the SSIS. Experience in SQL Joins, Group functions, Analytical functions, and Sub queries. Good Knowledge and Experience in Snowflake schema. Analysed source systems, staging area, Fact table and Dimension tables in Target environment. Tested the ETL SSIS mappings and other ETL processes. Experience in preparing detailed test cases writing test scripts by decomposing business requirements. Having good knowledge in UNIX commands like Grep, AWD, AWK to process the files in the UNIX environment. Experience in data quality validations. Strong working experience in windows and UNIX environment. Clear understanding of business procedures and ability to work as an individual as well as a part of a team. Experience in testing of Kafka Messages posting. Experience in Retail Banking. Handling Specifically handling credit card and debit card Services. Experience in Spark Shell validating with SQL Query.
T.B.M.L collage of arts and science
B.sc Mathematics · Mathematics
N/A – June 30, 2010
Newton’s Collage of arts and science
M.sc Mathematics · Mathematics
N/A – June 30, 2012
NexGen and Non Pillar
November 1, 2024 – Present
Roles & Responsibilities: Understanding Functionalities as per the client requirement. Verifying the data in the target database using DTBR date using show partition. Verified column mapping between source and target. Verifying Kafha messages for Eod, Future date etc. Interactions with BA & Dev teams to resolve the issues. Working in Must run cases using Automation for every Month . Preparing test cases and getting approval from Scrum team. Regularly giving Sign off for each week end for Next week deployment . Extensively written SQL to confirm the data transfer from source to target. Defect Analysing and Reporting in QC. Creating test cases for ETL mappings and design documents for production support. Communication with the client for Data management. Handling Specifically handling credit card and debit card Services
VANGUARD (Inbursa Bank)
May 1, 2021 – October 31, 2024
Roles & Responsibilities: Understanding Functionalities as per the client requirement. Verifying the data in the target database by ETL process. Verified column mapping between source and target. Prepared test data for functional & Integration testing. Interactions with BA & Dev teams to resolve the issues. Reporting daily testing status. Designed, Reviewed & Executed Test cases. Identified Test cases for Regression testing. Extensively written SQL to confirm the data transfer from source to target. Defect Analyzing and Reporting in QC. Creating test cases for ETL mappings and design documents for production support. Communication with the client for Data management.
Interactive data system (Health care)
June 1, 2019 – May 31, 2021
Roles & Responsibilities: Analysed the Project and tested the source, staging, and target data. Written SQL queries to execute the test cases using Sub-queries, Joins, Group functions and Analytical functions. Testing the Record counts between Source and Target environments. Documentation & preparation of test reports, defect list, test results. Created complex test cases and test scripts. Worked in Agile methodologies such as scrum and Retro. Involved in functional testing and regression testing. Involved in writing complex SQL queries to verify data from source to target. Involved in data quality validation includes row counts check, sample data validations.
Cultural Fit Analysis
The candidate has worked on diverse projects across banking (VANGUARD, NexGen and Non Pillar) and healthcare (Interactive data system) sectors, demonstrating adaptability to different business domains. The roles consistently align with QA Automation Engineer responsibilities, focusing on data validation, ETL testing, and defect management. The breadth of technologies used (SQL, Oracle, Couchbase, Postman, Python, Jira, Unix) indicates a willingness to learn and apply various tools, which is positive for cultural fit in dynamic environments. The consistent focus on data-centric testing aligns well with roles requiring meticulous attention to detail and robust validation processes.
Soft Skills & Operational Fit
The candidate's project descriptions indicate involvement in client communication, interaction with BA and Dev teams, and daily status reporting, suggesting a collaborative and communicative approach. The focus on understanding client requirements and resolving issues points to problem-solving and stakeholder management skills. However, without specific psychometric test results, a deeper assessment of work attitude, stress handling, and team collaboration is not possible.