ETL Developer with 5+ years in Data Warehousing & BI Testing
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Detail-oriented ETL Tester with 4 plus years of experience in validating large-scale data pipelines across Investment Banking and Healthcare domains. Strong expertise in SQL based data validation, ETL testing, BI testing, and defect management. Proven ability to ensure data accuracy, integrity, and compliance in enterprise environments.
Ethiraj College for Women
M.A
August 1, 2021 – June 30, 2021
Ethiraj College for Women
B.A
August 1, 2019 – June 30, 2019
ILink System & Digital Solution
ETL Tester
June 1, 2021 – Present
Chennai, Tamil Nadu, India
Investment Banking
June 28, 2026 – Present
Domain: Investment Banking Client: Lazard Ltd, United States. Databases: SQL server, Snowflake Languages: SQL, Python Tools: Informatica PowerCenter Other Applications: Jira, Git, Excel, SSMS, PyCharm Role: ETL & BI Tester BI Tool: Power BI Responsibilities: Analysed the mapping sheet and RSD document to create a test scenario. Analysing requirement and creating test plan, test case and executing test cases. Working with business analyst and team leads to go over the user stories assigned as part of the sprint. Used SQL joins, aggregate functions and subqueries to validate joiner, aggregate and filter transformation. Used Python Pandas functions like merge, read_csv, read_sql, shape and much more for validating data between heterogenous databases. Created automated data validation scripts using Python (Pytest) to test APIs, data services and ETL workflows. Validated ETL workflows orchestrated via Apache Airflow, ensuring DAG executions, task dependencies, and job scheduling were functioning correctly. Conducted DBT test validations including schema tests, data tests, and transformation verification for analytical data models. Collaborated with Product Owners, Developers, and Data Engineers in Agile ceremonies (sprint planning, grooming, stand-ups, retrospectives). Translated JIRA user stories and acceptance criteria into detailed test cases, test scenarios, and validation scripts. Maintained requirements traceability matrix (RTM) mapping test cases with business requirements and acceptance criteria. Executed large-scale data validation in data warehouse platforms (e.g., Snowflake/Big Query/Redshift) to verify schema conformance and data accuracy. Participated in User Acceptance Testing (UAT) and conducted post-release production validation and smoke testing. Identified, documented, and tracked defects in JIRA, supporting root cause analysis and resolution with development teams. Implemented and maintained data quality checks and automated test frameworks for validating schema, data lineage and transformation logic. Validated Power BI functionalities like RLS, Drill down, Drill through, Page level filters, Bookmarks. Create bugs by using the Jira tool and attached the test evidenced and assigned to the developer to fix the issues firstly. Experienced in Agile process and attended all agile meeting and given inputs to the team also raised the clarification points in the same meeting.
Healthcare
June 28, 2026 – Present
Domain: Healthcare Client: Fresenius Medical Care, Germany Databases: Oracle, SQL server Language: SQL, Unix, PLSQL Tools: SSIS Other Applications: SQL Developer, Jira, Git, Excel, Putty Role: ETL Tester & Functional Tester Responsibilities: Creation of test scripts as per the business rules which mentioned in mapping sheet. Connecting with business analyst to understand complex requirement. Involving in the execution of the test cases for the end-to-end business validation in the data warehouse. Involving in writing complex SQL queries to verify data from Oracle to SQL server. Used JIRA tool to track the bugs based on priority and severity and until completion. Created PLSQL stored procedure for running the regression test cases. Working with the dev team to go over the developed package to make sure that the requirement is covered by the development as per the mapping sheet.
Cultural Fit Analysis
The candidate's experience across Investment Banking and Healthcare domains demonstrates adaptability and a broad understanding of different industry data requirements. The exposure to various tools and technologies (SQL, Python, Informatica, SSIS, Talend, Apache Airflow, DBT, Power BI) indicates a willingness to learn and work with diverse tech stacks. Participation in Agile ceremonies suggests a collaborative mindset suitable for modern development teams. The role as an ETL Tester aligns well with the target role of an ETL Developer, showing a foundational understanding of data pipelines from a quality perspective.
Soft Skills & Operational Fit
The candidate demonstrates strong analytical skills through test scenario creation and complex query writing. Collaboration with BAs, developers, and product owners in Agile environments indicates good teamwork and communication. The focus on defect tracking and resolution using Jira shows a methodical approach to quality assurance. The experience in UAT and post-release validation suggests a commitment to end-to-end quality.