Etl Tester Resume
Framingham, MA
SUMMARY
- Over 6+ years of IT experience in Analysis, working as ETL tester on various Data Warehouse Environments in multiple domains.
- Experience in full software Development Life Cycle (SDLC) and Quality Assurance Life Cycle (QALC) analysis, design, development, testing, implementation and maintenance in data warehousing environment.
- Expertise in understanding Business Requirements, Functional Requirements, decomposing into HLD's and ETL Specifications into Test Cases for positive and negative test conditions.
- Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading.
- Experience in Data Analysis, Data Validation, Data modeling, Data Cleansing, Data Verification and identifying data mismatch.
- Experience in gathering functional requirements from users and designing data model for ETL development.
- Experience in writing and development of test cases, test scripts and test procedures.
- Identifying and tracking performance issues and defects during testing.
- Extensive experience in performing different types of testing including White Box, Black Box, System, Functional, Integration, Regression, Smoke, GUI, Database and User Acceptance Testing (UAT) and Unified Functional Testing (UFT, Selenium).
- Experience in automation test scripts using Unified Functional Testing (UFT).
- Experienced with coordinating cross - functional teams, project management and presenting technical ideas to diverse groups & proven ability to implement technology-based solutions for business problems.
- Experience in Data Profiling, Data Extraction, Data Integration, Data Testing and Data Cleansing.
- Excellent communication skills, team player and hard working.
- Have academic exposure to software development life cycle like Feasibility, Design, Coding, Testing, Implementation and Maintenance.
- Experienced working in Data warehousing and ETL Programming using Informatica ETL tool.
- Proficient in creating PL/SQL Procedures in Oracle 11G and ETL Development (Informatica).
- Experienced in running SQL queries using Toad (Oracle), Teradata SQL Assistant and SQL server.
- Experience in Performance Tuning of SQL and stored procedures.
- 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
Testing Tools: Informatica, Datastage
ETL Tools: Business Object, Cognos, Ab Initio, SSIS, Power BI
Reporting Tools: Selenium, QTP/UFT, Quality Center, Jira
Defect/Test Management Tools: Quality Center, Jira, ALM
Languages: Java, SQL
Databases: Oracle 9i/10g, IBM DB2, MS SQL Server, MS Access
WebServer/AppServer: Tomcat, IIS, Weblogic, WebSphere
Operating Systems: UNIX, Windows
PROFESSIONAL EXPERIENCE
Confidential, Framingham, MA
ETL Tester
Environment: Informatica, SQL Server, Teradata SQL Assistant, Teradata, Business Objects, Quality Center/ALM, Oracle, Agile, UNIX
Responsibilities:
- Prepared Test Cases for the mappings developed through theETLtool Data Stage and executed those Test Cases
- Involved in performing Smoke, Functional, integration, and regression testing.
- Review Business requirement for different Specialty center modules and provide Test estimation to project management.
- Analysis of Business requirements & Design Specification Document to determine the functionality of theETLProcesses.
- Designed and tested UNIX shell scripts as part of theETLtesting process to automate the process of loading, pulling the data for testingETLloads.
- Developed Test Cases for Deployment Verification,ETLData Validation, Cube Testing and Report testing.
- Written Test Cases for ETL to compare Source and Target database systems.
- Identified requirement and Code gaps to reduce business risk ahead.
- Create Test design estimations timeline based on reviewed scope.
- Create Master test plan and review testing approach with Project management, Development, Business Analyst to identify dependencies and make changes where it is necessary.
- Written several complex SQL queries for validating Business Objects Reports.
- Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
- Tested variousETLprocesses developed usingETLtools like Informatica Power center and Data stage.
- Worked with Data Conversion projects for testing data quality after migration.
- Production reconciliation was performed before the deployment of the developed application to the production systems to ensure that the data is being processed efficiently and to test the correctness of the data.
- Tested reports based on the statistical analysis of the data from various time frame and division using SQL Business Objects.
- Tested all Business Objects Dashboards according to the requirement.
- Reported debugging using Informatica and tracked defects using Quality Center/ALM.
- Written SQL to data validation in migration as part of backend testing Worked withETLgroup for understating mappings for dimensions and facts
- Worked in AGILE Methodology and used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
Confidential, Milwaukee, WI
ETL Tester
Environment: Quality Center, Informatica Power Center, Erwin, Ms Excel, Oracle, SQL, PL/SQL, Teradata utilities, TOAD, Autosys Scheduler, UNIX, Windows.
Responsibilities:
- Worked with Business analysts to understand Business/System requirements in order to transform business requirements into functional test cases.
- Responsible for reviewing Functional specs, user documentation and use cases and developing manual test cases out of it.
- Responsible for planning and directing Quality Assurance and Software change control policies.
- Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types
- Coordinated in setting up Test Environments and Test Plan needs with team members.
- Developing various Test Scripts, Test Execution using Quality Center based on the Functional Specifications.
- Involved in validating the Data mart tables as per the business logic applied to the staging tables.
- Executed the test scripts against TeraData source and validated the rules according to mapping documentation.
- Testing and validation of the developed Informatica mappings.
- Worked with Testing of Flat File and source data.
- Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
- Validated the source system data with the staging data using SQL and Pl/SQL scripts.
- Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability
- Expertise with System Testing, Functional Testing, Regression Testing.
- Prepared Traceability Matrix with requirements versus test cases.
- Tested several UNIX shell scripting for File validation and also PL/SQL programming
- Executed Test Cases using positive and negative data in Quality Center’s Test Lab and reported results and defects using Quality Center’s Defects tool.
- Involved in identifying the defects and developed Defect Tracking report using Mercury Quality Centre which involved Bug life cycle.
- Provided daily and weekly status reports.
Confidential, Framingham, MA
ETL Tester
Environment: Java, J2EE, Oracle, Citrix, XML, Mercury Quality Center, MS-Office.
Responsibilities:
- Involved in preparing Test Plan based on User requirement documents.
- Written test cases as per the Functional Specification documents and executed them.
- Performed Interface/flow, Functionality & Data validation for Modules like Tax Calculation, Customer ID, Recipient, Payment and Confirm Validate Orders.
- Performed Integration, Regression, Acceptance, System, Usability, etc. testing during different stages of the application development.
- Requirements changed documented and test cases were modified/incorporated in respective Functional Specifications.
- Responsible for performing various types of process evaluations during each phase of the software development life cycle including, audit, review, walk through and hands on system testing.
- Involved in Functional testing, business requirement testing, data requirement testing, regression testing, system integration testing, data validation, and non-functional testing.
- Analyzed the EDW mapping documents, Dimension tables and fact tables.
- Involved in testing the data warehouse for both the initial load and the incremental loads of the target.
- Tested application, logged found bugs into Mercury Quality Center, monitored their progress and verified their fix.
- Actively participated in enhancement meetings focused on making the product more effective in real time scenario.
- Created Orders in UOC and Verified Created order in backend system Assist & Validated file transfer of data in XML.
- Data was set up in Universal Administrative System (UAS) and verified in front at UOC.
- Attended Walk through, Meeting with Project manager & QA team.
- Responsible for sending Daily & weekly status report using MS-Office tools.
Confidential
ETL Tester
Environment: Quality center, Informatica, Oracle, TOAD, SQL Developer, SQL, JIRA, ETL, Windows.
Responsibilities:
- Analyzed user requirements, scenarios, and business rules and attended periodic meeting for changes in the application.
- Flexible, resourceful, and self-motivated and can work as a team and independently.
- Worked with cross-functional teams to manage defects, compile test results and communicate issues, risks and status on a timely basis to ensure solution meets the business requirements.
- Involved in Functional testing, business requirement testing, data requirement testing, regression testing, system integration testing, data validation, and non-functional testing.
- Responsiblefor Smoke testing, Regression testing, Integration testing and System testing.
- Involved in Manual Testing to check the basic functionality of the modules under test.
- Prepared test plans and test cases to test application functionality.
- Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
- Prepared Requirement traceability matrix (RTM) for the application.
- Analyzed the EDW mapping documents, Dimension tables and fact tables.
- Wrote SQL queries to do the column level verification of the Dimension and Fact tables.
- Involved in testing the data warehouse for both the initial load and the incremental loads of the target.
- Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.
- Involved in the Informatica up-gradation testing to make sure that the existing, updated and new workflows are working as expected when migrated to Informatica from Informatica 8.6. Created and documented the test plan for the same.
- Involved in database testing by writing and executing SQL queries to ensure that data entered has been uploaded correctly into the database.