- Featured in:
-
High Quality
The best examples from thousands of real-world resumes
Expert Approved
Handpicked by resume experts based on rigorous standards
Diverse Examples
Tailored for various backgrounds and experience levels
ETL Tester Resume Samples
No results found
Candidate Info
years in workforce
months at this job
Data Warehouse & ETL Tester, BI Report Tester
Supported business-wide Oracle data quality and ETL testing for security investment accounting (EDM) system
- Developed and executed plan for data profiling, and BI report testing
- Planned and conducted OBIEE report tests for wide variety of applications
- Planned, documented and tested extensive data integration process (PL/SQL) in support of financial security reference data
- Implemented effective data quality testing standards, verification procedures and tools
- Used HP Quality Center: Test Center, Test Lab, defect management
Candidate Info
years in workforce
years at this job
Electrical Engineering
Computer Science
ETL Tester
As a contractor for [company name], worked in the Risk Data Platform department testing financial risk databases using SQL queries in MS Access and Aqua Data Studio
- Reviewed database business and functional requirements, reviewed mapping transformations
- Worked with Program Managers, Requirement Analysts, Mappers, Developers, and other testers to resolve issues with requirements/mapping transformations
- Created Test Plans and test scripts, executed test scripts, and wrote Test Report
Candidate Info
years in workforce
years at this job
Databases
Software/etl Tester
Designed and Developed Shell scripts to generate and test the Weekly/Monthly RxNorm Releases and Resynchronization.
- Maintaining/troubleshooting the RxNorm release processes and the RxNorm web application.
- Unit Testing the RxNorm application with JUnit.
- Involved in Weekly Releases of RXNORM Release Files and running Appscan Security Checks
- Deployed the test and production versions of the RxNorm web application on JRun in Solaris.
- Developed Stored Procedures for the RxNorm releases as necessary using Toad/Oracle.
- Performed Input Validations, User Interface Validations, Browser Compatibility testing and Navigation testing.
- Defect Reporting, Analyzing, Tracking and Report Generation using Mercury Quality Center.
Candidate Info
years in workforce
years at this job
Role - Data/sql/etl Tester
Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data (Oracle, DB2 UDB, MS SQL Server) from various heterogeneous data sources.
- Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
- Developed inline view queries and complex SQL queries and improved the query performance for the same.
- Did extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.
- Executed campaign based on customer requirements
- Followed company code standardization rule
- Developed several VBA macros.
- Identify issues, information and behaviors during the adoption of a proprietary information management system.
- Accelerate the rate of adoption of the system, improve the quality of the data being input and generated, and promote accountability amongst the staff and users.
- Develop code necessary to introduce additional reports, reverse engineer data models to the business meaning, and instruct users on the account management and implementation process advantages derived from the system.
- Identify and document deficiencies in the proprietary information management system during initial implementation.
Candidate Info
years in workforce
years at this job
Finance
ETL Tester
Developing Informatica Power Center Mapping, Mapplet and reusable transformations for Incremental data load for new projects as well as change projects.
- Create stored procedures for Incremental extract based on time stamp, version date and record flag.
- Implemented SCD I, II to the extracts based on the business requirement and client expectations.
- Create test plan, test cases and do the Unit testing, SIT and UAT and send them to projects lead for approval.
- Schedule the workflow using AutoSys. Sent error logs if any to project DBA's or assigned Project Leads to sort it out and resolve.
- Update project leads on a day to day basis on the developments.
- Wrote UNIX Shell Scripts and pmcmd command line utility to interact with Informatica Server from command mode.
Candidate Info
years in workforce
years at this job
ETL Tester
Preparation of Test Cases based on ETL Specification Document, Use Cases, Low Level Design document.
- Extensively used SQL queries for data validation and backend testing.
- Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
- Preparation of Test Cases based on ETL Specification Document, Use Cases, Low Level Design document.
- Played role in creation and testing of designed scalable, reusable, and low maintenance ETL templates.
Candidate Info
years in workforce
years at this job
Electronics And Telecommunications
Information Systems
Business Mashup
DW ETL Tester/reports Analyst
The Washington State Department of Social and Health Services is DSHS's primary provider payment processing system. It pays about 100,000 providers who serve 1 million people who qualify for DSHS services each year.
- Involved in Go-Live and Operations and Maintenance Post Go-Live support for WAMMIS (Washington Medicaid Management Information Systems)
- Collaborated with the Lead and Customer to develop the Test and Acceptance plan criteria for Performance and Load Testing and thereafter generated Cognos (Adhoc and OnDemand) Reports and SQL's along with executing various scenarios using WebLOAD
- Performed System test on Cognos Reports for WAMMIS Data warehouse system which involved analyzing functional specifications and writing test analysis, executing reports with test data for test scenarios and writing complex Test SQLs for the reports and logging defects in Clear Quest.
- Responsible for System testing of Ad-Hoc Query Packages in Cognos which involved developing and execution of Ad-hoc reports and corresponding Test SQLs based on various join conditions and filters and calculations.
- Collaborated with the Development and Database Modeling teams for Integration, System, Functional, Regression and UAT testing of WAMMIS Data Warehousing. Main tasks performed included - IBM Datastage ETL job execution, test analysis, source file extraction, FTP processes, Smoke test and source file validation for relevant tables during Initial and Incremental Loads.
- Performed analysis of Mapping Documents and 'Schema Compare' with Database tables, logged the defects and worked with the Database Modeling Team to resolve them.
- Collaborated with Manager on hiring interns and then provided them with basic training and appropriate supervision.
Candidate Info
years in workforce
months at this job
ETL Tester
Writing and executing database queries
- Creating the expected results by executing the queries according to the test conditions.
- Raising defects where discrepancy found in the database and reporting it to the onshore development team.
- Guiding new resources to make them familiar with the project work
More ETL Tester
Resumes
ETL Tester Resume Success Stories
