Etl Tester Resume
Jacksonville, FL
SUMMARY
- Over 4+ years of IT experience in Quality Assurance and Software Testing of various business applications in Client/Server environments and Data Warehousing solutions.
- Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer.
- Strong knowledge of SDLC and Software Test Life Cycle and highly proficient in SQA methodologies for Waterfall and Agile.
- Experience in Data Analysis, Data Cleansing (Scrubbing), Data Validation and Verification, Data Conversion, Data Migrations and Data Mining.
- Experience in analyzing the error caused to failure of the ETL load with reference to the log file and report them to the corresponding team to get it rectified.
- Experience in gathering functional requirements from users and designing data model for ETL development.
- Good knowledge in ETL/DWH testing concepts, Informatica Power Center and Talend.
- Good Experience in creating ETL test data for all ETL mapping rules to test the functionality.
- Good Experience in testing ETLTalend and other ETL Processes (Data Warehouse Testing)
- Extensive experience in performing different types of testing including White Box, Black Box, System, Functional, Integration, Regression, Smoke, Database and User Acceptance Testing (UAT).
- Experience in Data Profiling, Data Extraction, Data Integration, Data Testing and Data Cleansing.
- Good Experience in preparation of Requirement Traceability Matrix (RTM), Defect Reports, and Weekly Status Reports.
- Experienced in running SQL queries using Toad (Oracle), and SQL server.
- Passionate worker to contribute individually and as part of a team.
- Ability to learn modern technologies quickly with good analytical and problem - solving skills
TECHNICAL SKILLS
ETL Tools: Informatica Power Center, Talend Cognos, Datastage
Test Management Tools: Quality Center, Jira, ALM
Languages: Java, SQL
Databases: Oracle 9i/10g, IBM DB2, MS SQL Server, MS Access
WebServer/AppServer: Tomcat
Operating Systems: UNIX, Windows
PROFESSIONAL EXPERIENCE
Confidential, Jacksonville, FL
ETL Tester
Responsibilities:
- Involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts.
- Extensively usedETLmethodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETLsolution usingETLtools likeTalend.
- Tested variousETLprocesses developed usingETLtools like Informatica.
- Tested the ETL Talendmappings and other ETL Processes (Data Warehouse Testing).
- Testing ETL data feeds from various data sources to ware house.
- Tested complex mappings using mapplets and reusable transformations.
- Established and documented ETL QA standards, procedures and QA methodologies.
- Extensively used Talendfor extraction, transformation and loading process.
- Extensively tested several ETL Mappings developed using Talend.
- Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scrfgjipts.
- Tested the reports generated by OBIEE and verified and validated the reports using SQL.
- Written SQL scripts to test the mappings and tested Cognos Reports
- Written several SQL statements to confirm successful data transfers between source and target.
- Executed SQL queries to perform backend database testing and verify/modify user data
- Reported debuging using Talend and tracked defects using Quality Center/ALM.
- Worked in AGILE Methodology and used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
- Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports.
Environment: Talend,Oracle 8i, SQL Server, SQL, PL/SQL, SQL*Plus, TOAD, Windows.
Confidential, East Norriton, PA.
ETL Tester
Responsibilities:
- Created Test Scenarios and Test Cases based on system use-cases and business use-cases.
- Identified various Business and Data Test Scenarios based on Source to Target Mapping and assisted in the preparation of extensive set of validation test case to verify the data.
- Design and maintain the infrastructure for theETLprocess, metadata maintenance, and data validation.
- CreatedETLtest data for allETLmapping rules to test the functionality of the Informatica.
- Involved on ETL Functional testing. Involved in testing Reports. Requirements gathering and freezing of those requirements.
- Involved in ETL process testing using TalendETL tool.
- Created ETL test data for all ETL mapping rules to test the functionality.
- Written Test Cases forETLto compare Source and Target database systems.
- CreatedETLtest data for allETLmapping rules to test the functionality of Informatica mappings.
- Worked with Data profiling, Data Validation and Data Integrity and Data Cleansing and ETL processes using Informatica.
- Validated the Cognos Reports against Data warehouse.
- Performed InformaticaETLtesting to validate end-to-end data from source system MS SQL Server and Target system Teradata environment.
- Extensively usedInformatica Power Center for extraction, transformation and loading process.
- Perform User Acceptance Testing with UAT test scenarios.
- Working with Data base testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.
- Evaluate and suggest improvements to the software development process.
- Monitor Testing Activities within the team and report regular progress to the Test Manager.
Environment: Informatics Power Center 8.1/7.1, Oracle 10g, MS SQL Server 2005/2000, PL/SQL, Windows 2000, HP-UX.
Confidential, Atlanta, GA.
ETL Tester
Responsibilities:
- Prepared data mapping document for various data feeds for ETL to write and develop the data extraction routines.
- Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application.
- Coordinated between offshore and onsite team and managed multiple OLAP and ETL projects for various testing needs.
- Extensively used Informatica for extraction, transformation and loading process.
- Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
- Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
- Monitoring ETL jobs in Informatica which involved analyzing the issues and providing corrective actions.
- Tested Cognosreports and written test cases using Quality Center.
- Tested and validated the cube data, ensuring that the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms.
- Defects were tracked and prioritized using Quality Center and analyzed the variation between expected result and actual result.
- Designing and creating new reports, freeform SQL reports in cognos.
- Designed and prepared scripts to monitor uptime/downtime of different system components.
Environment: Informatica, SQL Server, Quality Center, SQL, TOAD, Oracle, PL/SQL, MS Access/Excel/Visio
Confidential, New York, NY.
ETL Tester
Responsibilities:
- Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
- Analyzing requirements and creating and executing test cases
- Involved inETLprocess testing using Data Stagetool.
- Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Data Stage
- Working on Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.
- Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews
- Performed data validation testing writing SQL queries.
- Wrote complex queries in SQL assistant to check the data from Source and Target.
Environment: Datastage,SQL, DB2, Oracle, HP Quality Center, Windows, UNIX.