- Featured in:
-
More ETL Tester Resumes
Use these ETL Tester samples as a guideline or visit our extensive library of customizable best resume templates.
Select
Customize
Download
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Computer Software Resume Samples
ETL Tester Resume Samples
No results found
0-5 years of experience
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
0-5 years of experience
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
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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
Computer Software Cover Letter Examples
Rate This Article
[ETL Tester]
Last edited by: Gabriela Barcenas, CPRW, Content Writer II -
Gabriela Barcenas
CPRW, Content Writer IIGabriela is a Certified Professional Resume Writer (CPRW) and career adviser. With 10 years of digital media experience and five years of resume writing expertise, her publication history includes fashion, education, travel, social justice, equitable design and career advice.
