We provide IT Staff Augmentation Services!

Senior Etl Analyst Resume

Santa Monica, CA

SUMMARY

  • Over 7+ years of experience in manual testing on web based, Client/Server and data warehousing applications.
  • Well - versed with all stages of Software Development Life Cycle (SDLC ) and Software Testing Life Cycle (STLC ) with good working knowledge on testing methodologies, disciplines, tasks, resources and scheduling.
  • Professional experience in SQL, Metadata, Functional, Regression, BI Testing, UAT Testing and GUI testing.
  • Extensive ETL testing experience using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) and other ETL Processes (Data Warehouse Testing )
  • Extensive Experience in SQL and PL/SQL scripting.
  • Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL, PL/SQL for data integrity.
  • Sound Knowledge and experience in Metadata and Star schema/Snowflake schema . Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
  • Experience in using Bugzilla, Test Director and HP Quality Center for Bug Tracking and Defect Reporting.
  • Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
  • Experience in working with Software Development team in resolving Defects, presenting Defect Status reports, resolving requirement, and observed design inconsistencies.
  • Experience in Reports testing in Crystal Reports XI Environment.
  • Strong working experience in Windows NT/2000/XP and UNIX environments.
  • Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad for developing Oracle applications.
  • Experience in Web based applications like online banking, transactions applications.
  • Clear understanding of business procedures and ability to work as an individual and as a part of a team.
  • Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

TECHNICAL SKILLS

Operating Systems: Windows 95/98/2000/NT/XP, UNIX, Linux, Sun Solaris

Languages: SQL, PL/SQL, UNIX Shell Scripting

Bug Reporting: Mercury Test Director 8.0, Rational Clear Quest, HP Quality Center 11.0, Bugzilla

Databases: Oracle 9i/10g/11g, SQL Server 2005/2008

ETL Tools: Informatica Power Center 8/9

Database Tools: TOAD, SQL Developer

Reporting Tools: Crystal Reports 10.0/XI R2, OBIEE

PROFESSIONAL EXPERIENCE

Confidential,Santa Monica,CA

Senior ETL Analyst

Responsibilities:

  • Wrote SQL validation scripts and executed SQL stored procedures to validate the output data.
  • Create Validation Views for various scenarios on top of LOAD tables and validate the data in these Views.
  • Extract data files from HP, convert EBCDIC files to ASCII format and place the ASCII files in Informatica Server
  • Loading the files onto STAGE tables, validating the files and their counts against the Files from HP.
  • Validate the date loaded in the views created on top of STAGE tables against the data provided by HP.
  • Wrote complex SQL queries including Join Conditions, SQL Functions, Sub Queries to check the data from Source and Target.
  • Validated data being loaded into OMX is matched with data sent from HP.
  • Reviewed the ETL mappings (Informatica) to ensure the transformation rules are applied correctly.
  • Developed parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling.
  • Executed batch processing and verified the jobs status and data in database tables
  • Used JIRA for documenting Test Plans and Test Cases and log the expected results.
  • Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
  • Done retesting the existing test cases with the different kind of source systems.
  • Worked with developers to understand the functionality and Business rules to better validate the data

Confidential,Westlake Village,CA

Senior QA Engineer

Responsibilities:

  • Worked with Business Analysts to define testing requirements to satisfy the business objectives.
  • Created and executed SQL queries to perform source to target testing on DB2 database. Performed the following tests: DATA COMPLETENESS, VALIDITY, UNIQUENESS, DATA INTEGRITY, DATA TRANSFORMATION, DATA QUALITY, and INITIAL/INCREMENTAL LOAD TESTS.
  • Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
  • Wrote complex SQL queries including Join Conditions, SQL Functions, Sub Queries to check the data from Source and Target.
  • Executed the workflows in the workflow manager to start the ETL process.
  • Validated the load processes of ETL to make sure the target tables are populated according the data mappings provided that satisfies the transformation rules.
  • Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
  • Performed Integration, End-to-End, system testing, involved in Functional Testing & Regression Testing.
  • Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.
  • Used HP Quality Center for storing, maintaining the test repository, bug tracking and reporting
  • Prepared documentation for some of the recurring defects and resolutions and business comments for those defects.

Environment: HP Quality Center, DB2, Oracle, SQL, SQL*Plus, UNIX, Quick Test Pro 8.0, Test Director, Windows NT/2000

Confidential,Sunnyvale, CA

ETL Tester

Responsibilities:
  • Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
  • Performed manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
  • Analyzed application data using the SQL to identify the ETL processes
  • Modified and created SQL Queries and stored procedures for quality assurance and analysis.
  • Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
  • Performed backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.
  • Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs.
  • Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during that period.
  • Wrote complex queries to compare the counts and data from source to target.
  • Formulated the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing.
  • Performed database testing to verify backend database transactions.
  • Coordinated user acceptance testing activities for business groups and IT.
  • Involved in communication between UAT team members, business leaders, and IT.
  • Participated in application release planning and status sessions.
  • Used Agile testing methodology for achieving deadlines in UAT testing.
  • Created, maintained and updated regression suites upon receiving new build.
  • Modified and executed test scripts for web based environment-using Quality Center .
  • Created traceability relationship between requirements in the same module and also between different modules.
  • Analyzed requirements and creating and executing test cases
  • Extensively used Quality Center for documenting, organizing and tracking requirements.
  • Involved in formulating the test plan, procedures and Wrote test cases.

Environment: HP Quality Center, Oracle10g, SQL, PL/SQL, DB2, SQL*Plus, UNIX, shell scripting

Confidential

QA Tester

Responsibilities:
  • Involved in the meeting with business analysts and Marketing team for requirement gathering in Definition Stage.
  • Gathered and Analyzed Functional and Performance requirements.
  • Involved in project planning, coordination and implemented QA methodology .
  • Extracted test data by understanding relational database design diagrams Created.
  • Designed, Created and executed manual Test Cases.
  • Reviewed Test cases for automation and provided inputs about the scope of Automation.
  • Prepared documentation about the automation suite architecture.
  • Peer Review of the scripts and made recommendations for updates if any.
  • Performed extensive backend testing by writing Complex SQL queries .
  • Setup the Performance test environment with the support of technical team.
  • Response time, throughput, hits per second were studied by graphs and reported.
  • Created manual & automated test cases for testing web services.
  • Used Test Director for storing, maintaining the test repository, bug tracking and reporting
  • Prepared documentation for some of the recurring defects and resolutions and business comments for those defects
  • Assist QA Team with defining and implementing a defect resolution process including defect priority, severity, next steps, and assigned owner
  • Created detailed periodic Status Reports for senior management to keep them posted on the progress of implementation
  • Wrote SQL queries to test the data in database using TOAD and validated the data
  • Developed Test Matrix to give a better view of testing effort
  • Participated in Test Readiness Review Meetings

Environment: Java, Java Applet, JavaScript, Web logic Application Server, Oracle9i, SQL, PL/SQL, Test Director 8.0, UNIX (Solaris), Unix Shell Scripting.

Confidential

QA Tester

Responsibilities:
  • Involved in designing the Test Cases using Functional Specifications
  • Conducted extensive manual Black Box testing to better understand the functionality of the Application.
  • Peer reviewed the Test Cases and made recommendations.
  • Designed, Created and executed manual Test Cases.
  • Test Environment Setup and Performed the Functional and Regression Testing
  • Detecting bugs, classifying them based on the severity, and documenting them.
  • Open Defect's with help of Bugzilla wherever discrepancies found in the code and assigning them to development Team.
  • Involved in Testing Change Requests (CR) that is testing base enhancements to the existing code before implementing in the Production.
  • Created detailed periodic Status Reports for senior management to keep them posted on the progress of implementation.
  • Attended periodic meetings, teleconferences and led discussions on problem resolution.
  • Coordinated with Developers for Defect analysis and performed Regression Testing.
  • Developed Test Matrix to give a better view of testing effort.

Environment: Java, XML, Java Script, HTML, Bugzilla, Oracle, Mainframe, UNIX, Shell scripting.

Hire Now