Senior ETL Tester Resume Example

Senior ETL QA Engineer · JPMorgan Chase

New York, NY · 2022 - Present

• Led a team of 4 ETL QA engineers in validating data migration for a multi-billion dollar regulatory reporting platform, achieving 99.9% data accuracy across 500+ data tables and ensuring successful submission of BCBS 239 reports.
• Developed and implemented automated ETL test frameworks using Pytest and SQL, reducing testing cycles by 25% and detecting data discrepancies 15% faster for daily data loads.
• Designed and executed comprehensive test plans for risk data aggregation systems, identifying critical data quality issues that prevented over $5M in potential compliance fines.
• Collaborated with data architects and developers to optimize ETL processes, resulting in a 10% improvement in data load performance for key financial analytics dashboards.

ETL Tester Lead · Citi

New York, NY · 2018 - 2022

• Managed and mentored a team of 3 junior ETL testers, overseeing testing efforts for a new enterprise data warehouse supporting credit risk analysis, reducing post-production defects by 20%.
• Developed and maintained complex SQL scripts and stored procedures for data validation, identifying and resolving over 1,000 data quality issues across 20+ data sources.
• Implemented data reconciliation processes for critical financial ledger data, ensuring zero data loss during quarterly data refresh cycles for regulatory audits.
• Contributed to the improvement of CI/CD pipelines by integrating automated data validation scripts, leading to a 10% faster release cycle for data-dependent applications.

ETL QA Analyst · Bank of America

Charlotte, NC · 2015 - 2018

• Performed extensive data validation and functional testing for ETL processes supporting wealth management reporting, ensuring 98% accuracy of client portfolio data.
• Wrote and executed test cases for data ingestion from various financial systems into a central data lake, identifying 150+ data transformation errors pre-production.
• Assisted in the development of data quality dashboards, providing visibility into data health and reducing data remediation efforts by 10 hours per week.

Master of Science in Data Science · New York University

New York, NY · 2018 - 2020

• GPA: 3.8/4.0
• Relevant Coursework: Data Warehousing & ETL, Database Systems, Data Mining, Statistical Modeling, Big Data Technologies.
• Master's Thesis: 'Optimizing Data Quality in Financial Data Pipelines using Machine Learning Techniques' - focused on anomaly detection in large transactional datasets.

Bachelor of Science in Computer Science · University of Massachusetts Amherst

Amherst, MA · 2011 - 2015

• GPA: 3.7/4.0, Magna Cum Laude
• Relevant Coursework: Database Management, Software Engineering, Algorithms, Object-Oriented Programming, Data Structures.

Senior ETL Tester · DataStream Analytics

Chicago, IL · 2022 - Present

• Led a team of 3 QA engineers in designing and implementing comprehensive ETL test plans for a data migration project involving over 5TB of data, achieving 99.8% data accuracy post-migration.
• Developed and automated 150+ SQL validation scripts and Python routines to ensure data integrity and transformation logic, reducing manual testing effort by 40% and shortening testing cycles by 20%.
• Implemented a new data quality monitoring framework using Informatica Data Quality, which proactively identified and prevented over 50 critical data discrepancies from reaching production.
• Collaborated with data architects and developers to optimize database queries and ETL processes, leading to a 15% improvement in data load performance for key financial reports.
• Mentored junior testers on advanced SQL querying, data validation techniques, and the use of automated testing tools, improving team efficiency by 25%.

ETL Tester · GlobalTech Solutions

Chicago, IL · 2018 - 2022

• Executed end-to-end testing of ETL processes for enterprise data warehouse solutions, contributing to the successful deployment of 3 major data integration projects ahead of schedule.
• Created and maintained detailed test cases, test data, and bug reports using Jira and TestRail, identifying over 200 defects and ensuring resolution prior to release.
• Wrote complex SQL queries to validate data transformations, aggregations, and data loads from diverse sources (SAP, Salesforce, flat files), reducing data discrepancies in reports by an average of 18%.
• Collaborated with cross-functional teams to understand data requirements and business rules, translating them into effective test strategies and improving data quality metrics by 10%.

Business Intelligence Analyst · Midwest Financial Group

Chicago, IL · 2015 - 2018

• Developed and maintained interactive dashboards and reports using Tableau and Power BI for key business stakeholders, resulting in a 25% increase in data-driven decision-making efficiency.
• Extracted, transformed, and loaded data from various financial systems into a centralized data mart, ensuring accuracy and consistency for over 100 daily and weekly reports.
• Identified and resolved data quality issues in source systems, improving the reliability of financial forecasts by 10% and reducing report generation time by 15% through optimized data preparation.

Bachelor of Science in Information Systems · University of Illinois Urbana-Champaign

Urbana, IL · 2011 - 2015

• Graduated with High Honors, GPA: 3.8/4.0
• Relevant Coursework: Database Management Systems, Data Warehousing, Data Mining, Business Intelligence, Software Testing and Quality Assurance.
• Thesis Project: Developed an analytical framework for identifying data anomalies in large transactional datasets, reducing false positive rates by 15% in simulations.