We provide IT Staff Augmentation Services!

Sr. Etl Engineer Resume Profile

New, YorK

Summary:

I have over 7 years of diverse experience in Information Technology with an emphasis on Software Quality Assurance in industries like Healthcare, Banking, and Finance. My ambition is to take up a challenging position in the area of Software Quality Assurance and Testing in a progressive, fast-paced dynamic environment that will allow me to align my skills in the organization in the most efficient manner.

Career Summary

  • Over 7 years of Experience in Data warehousing Analyst, Quality Assurance and 5 years of ETL/BI testing experience with extensive backend testing Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
  • Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices.
  • Extensive experience in testing of Financial, Healthcare and Banking clients.
  • Expertise in designing the test scenarios and scripting the test cases in order to test the application.
  • Experience in developing the Manual Test Suites and Automated test suites.
  • Expertise in QA process and different levels of testing like unit, Functional, Regression, and Integration testing with business scenarios.
  • Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
  • Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
  • Experience in testing and writing SQL and PL/SQL statements.
  • Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading ETL
  • Strong experience in testing tools like TestDirector, Quality Center RQM and RTC
  • Expertise in writing SQL and PL/SQL statements.
  • Good expertise in using TOAD, SQL Developer and SQL Management Studio.
  • Experience in testing and writing complex SQL, T-SQL and PL/SQL statements.
  • Experience in all aspects of project development life cycle.
  • Expert level skills in testing Enterprise Data Warehouses using Informatica Power Center, Data Stage, Ab Initio and SSIS ETL tools.
  • Experience in debugging the issues.
  • Proficient in working with UNIX shell scripts putty Environment.
  • Involved in jobs scheduling, monitoring and application support in a 24/7 environment.
  • Excellent communication skills and Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.
  • Application Data warehousing experience in Banking, Financial, HealthCare, Retail and Consumer.

Confidential

Sr. ETL Engineer

Responsibilities:

  • Gathered business scope and technical requirements
  • Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
  • Mapped the source and target databases by studying the specifications and analyzing the required transforms.
  • Involved in developing detailed test plan, test cases and test scripts using RQM Rational Quality Manager for Functional and Regression Testing.
  • Worked in RTC Relational team Concert for SDLC life cycle
  • Interacted with Management to identify key Dimensions and Measures for business performance.
  • Completed Data Migration test cases as well as web based test scripts.
  • SQL queries were written to verify the data in both source and target schemas to validate the data migration.
  • Perform Regression testing EDW after facet upgrade
  • Mapping Data Items from Source System to the Target System.
  • Validate Interface files from EDW and ADW.
  • Validate Cognos Report.
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Used Informatica to move data to the warehouse using the stored Procedure thereby enabling faster moment of data.
  • Validating the Target data based on the test cases.
  • Preparing the process flow diagram for ETL Jobs.
  • Validated all the applications and successfully executed and unit tested the jobs with RQM.
  • Verified the data in DW tables after extracting the data from source tables by writing SQL queries using TOAD
  • Tested SQL queries, PL/SQL scripts to validate the data and performance of the database.
  • Validate the reports by running SQL Queries against the source system s .
  • Compare the new reports to the original requirements for complete functionality.
  • Created Test input requirements and prepared the test data for Data Driven testing.
  • Created ETL execution scripts for automating jobs.
  • Creation of jobs sequences and job schedules to automate the ETL process.
  • Documented the purpose of mapping so as to facilitate the personnel to understand the process and incorporate the changes as and when necessary.

Environment: Informatica, FACETS 5.01/4.81, ORACLE, RTC, RQM, SQL/PLSQL, COGNOS, TOAD 11 and TOAD for analyst 3.0, CDMA Mapping Application,

Confidential

Sr. ETL Quality Assurance Analyst

Responsibilities:

  • Worked on Agile SDLC approach implementation for the whole testing life cycle.
  • Reviewed Functional requirements documents, High level design requirement documents and finalize the testing in scoops and scenarios for Integration testing for each project.
  • Gathered requirements and created, executed and documented Test Cases as per requirements in Quality Center.
  • Tested HIPAA EDI Transactions and Code Sets Standards such as 837/835 and 834 transactions.
  • Interacted with the team member to ensure meaningful development of the scripts and simulated real time business scenarios.
  • Maintained QA lab standards, documentation review assisted in establishing and maintaining best practices for QA.
  • Acting as liaison between end user and Facets for user problems, outstanding issues, training needs and new software releases.
  • Maintaining knowledge of Medicare and Medicaid rules and regulations pertaining to the Xcelys configuration and evaluating the impact of proposed changes in rules and regulations.
  • ICD 9 ICD 10 Conversion Project Worked in the analysis of the ICD 9 10 codes conversion Project. Expertise in GEM processes and concepts.
  • Created test scripts for Security, Positive, Negative and System Integration Testing SIT .
  • Worked with team manager in supervising, guiding, and supporting their testing efforts for Integration.
  • Worked with Claims, enrollment, eligibility verification for members and providers and benefits setup.
  • Experienced with batch processing system for claims electronic and manual transaction.
  • Well known with frontend processing for the Claims, Subscriber/Family and with Providers.
  • Experienced with External claim editing system on frontend system of Xcelys6.3.
  • Responsible for writing the Test Cases and Test Scenarios based on the Functional Specification and technical Specification and documented in Mercury Quality Center.
  • Executed test cases for the existing market's various lines of business. The test cases covered: Authorization of claims, Accumulator, Benefits, Claim Payment and Pricing, as well as member and provider data updates
  • Created transactions in the Mainframe and verified them in the web and vice versa.
  • Worked on Quality Center for bug status tracking and maintained and created status reports for the application.
  • Work extensively for regulatory report for HEDIS Reporting
  • Involved in weekly defect review meetings to review the status of defect fixes and upcoming build releases.
  • Used Quality Center for version control, tracking defects, enhancement requests, assign work activities, and assess the real status of project throughout the life cycle.
  • Identifying Test Cases to be run for Regression Testing and conducting Regression testing as and when new builds were made.
  • Documented the test execution summary results and reported the status of assigned test tasks and issues to project manager for approvals.

Environment: Informatica 8.6.1/8.1, Xcelys 6.3, ORACLE, HP Quality Center ALM, SQL/PLSQL, Business Objects XIR2, QTP, TOAD, XML, Korn Shell Scripts, UNIX, Windows XP

Confidential

ETL Tester

Responsibilities:

  • Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 10.0
  • Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
  • Extracted Data using AB- Inito Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
  • 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.
  • Created the test environment for Staging area, loading the Staging area with data from multiple sources.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
  • Tested the ETL Ab- initio Jobs and other ETL Processes Data Warehouse Testing
  • Written several complex SQL queries for validating Cognos Reports.
  • Tested several stored procedures.
  • Involved in the error checking and testing of the ETL procedures and programs Ab-initio session log.
  • Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
  • Experience in creating UNIX scripts for file transfer and file manipulation.
  • Validating the data passed to downstream systems.
  • Worked with Data Extraction, Transformation and Loading ETL .
  • Involved in testing data mapping and conversion in a server based data warehouse.
  • Worked with business team to test the reports developed in Cognos
  • Tested whether the reports developed in Cognos are as per company standards.
  • Used Quality Center to track and report system defects
  • Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: Ab initio BRE, DB2, Java, Cognos, SQL, XML, IBM AIX 5.5, UNIX, Shell Scripting, WINSQL, Ultra Edit, HP Quality Center 10.0

Confidential

ETL Tester/QA analyst

Responsibilities:

  • As a QA lead I defined test plan, test strategies, test cases based on the requirements outlined in the test plan as part of the development cycle.
  • Participated in developing test plans templates and guidelines to be used by the project team with detailed screen layouts with regards to various types of corporate actions.
  • Involved in the development of Test Plans and Test Cases and coordinated the tests with the QA team to verify implementation of new features and enhancements.
  • Design, analyze and performed Integration and wrote System requirements on different leading health care software's such as FACETS.
  • Writing Test Plans/Test Scenarios/Test Cases/Test Matrix.
  • Followed the Agile methodology for the entire SDLC
  • Involved in writing and executing test cases using MQC based on the requirements
  • Performed Back-End testing using SQL Query.
  • Developed design Specification writing Test report s and documenting Test results
  • Identified customer requirements besides reviewing test plans and documented the development of these plans
  • Used Soap UI to check the status of environment
  • Analyzed the system requirements specification and developed appropriate test plans, test cases, test scripts and executed testing
  • Worked on claim processing module which involved Receipt, Enrolment 834 , Verification of Claims Form 837 and Claims Adjudication, Health Claim Payment/Advice 835 as per HIPAA guidelines.
  • Automated web services using Soap UI
  • Tested EDI 837, 835, 834 files in compliance with HIPPA 4010 and 5010.
  • Coordinate with reforms operations group to build new marketing strategies for exchange products on portals designing exchange products with addition of exchange specific attributes to SBCs
  • Mapped the Bloodhound tool clinical editing tool related data elements to the internal XML elements.
  • Created the data dictionary for the clinical aberrancy rules
  • Performed Health Care Reform audit for multiple Health Care Reform provisions. Provided recommendations for systems being developed to support the audit.
  • Developed automation test scripts for performing regression testing on the application using Quick Test Pro
  • Conducted interviews and workshops for soliciting customer requirements
  • Performed Test execution and wrote and executed Test scenarios /Test Scripts
  • Interacted with the technical team for the 837 claims transactions design
  • Manage the Requirements Business as well as System requirements , performed requirements analysis along with the creation of Test Scenarios.
  • Worked with the development team to make sure that they understood the user requirements and that the system developed met those requirements.

Environment:Ascential Data Stage 7.5-Designer, Facets 4.7, Director, Manager, Windows NT 4.0, SQL Server 2000, Quality Center 8.0, DTS, TSQL, Oracle 9i , TOAD, SQL, PL/SQL, Cognos ReportNet8.0, Microsoft Visio 2003. MS Access, Flat Files

Confidential

QA Analyst

Responsibilities:

  • Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
  • Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
  • Tested the entire compliance reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
  • Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
  • Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.
  • Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
  • Tested different reports including detail, summary reports and on demand reports developed by SSRS Report Studio.
  • Extensively worked on designing various output and management reports Using SQL Server Reporting Services SSRS
  • Tested the XMLs feeds received from another source, which is a third party for data consistency.
  • Tested the ETL with XML as source and tables in the data warehouse as target.
  • Used Unix environment variables in various .ksh files which comprises of specified locations to build Ab Initio Graphs.
  • Observed the Extract, Transform, Load process with Ab Initio and tested the data load process using the Ab Initio ETL tool.
  • Tested several data validation graphs developed in Ab Initio environment
  • Monitored the UNIX and Sybase servers and collect Performance Testing Metrics.
  • Tracked defects to closure by coordinating with the dev team.
  • Tested source data for data completeness, data correctness and data integrity.
  • Performed End to end testing starting from the source to the report.
  • Conducted and coordinated integration testing and regression testing.
  • Participated in business requirements gathering and in modifications of the requirements based on the scope.
  • Worked with the DSO team to understand the source to target mapping document and accordingly helped them to clean the source data to decrease the defects and to ensure that final data matches with the data warehouse standards.
  • Prepared test data to cover all the test scenarios.
  • Maintained the entire test cases in HP Quality Center and logged all the defects into the defects module.
  • Tested the migration of reports from Business objects XIR2 to XIR3.
  • Provided the management with weekly QA documents like Test metrics, Daily status reports, Test schedules and Test Exit Report.

Environment: oracle 11g,sybase, Business Objects, SQL Developer, SQL Server 2008, TOAD, Ab Initio, HP Quality Center, SSRS,PL/SQL, UNIX, Putty, Session log files, Flat files, XML files, Remedy, Snag IT, Compare IT, MS Office, Clear Quest CQ and Clear Case.

Confidential

DWH Quality Analyst/Backend Tester

Responsibilities:

  • Gathered business scope and technical requirements
  • Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
  • Mapped the source and target databases by studying the specifications and analyzing the required transforms.
  • Interacted with Management to identify key Dimensions and Measures for business performance.
  • Mapping Data Items from Source System to the Target System.
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Create Informatica Jobs to extract, transformation and loading of the data using Informatica toll in the parallel processing mode.
  • Used Informatica to move data to the warehouse using the stored Procedure thereby enabling faster moment of data.
  • Create JILs and Run books to schedule the box and cmd jobs in autoSys.
  • Used the Informatica Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
  • Writing Jill file for Auto sys daily schedules.
  • Validating the Target data based on the test cases.
  • Preparing the process flow diagram for ETL Jobs.
  • Validated all the applications and successfully executed and unit tested the jobs with Informatica.
  • Verified the data in DW tables after extracting the data from source tables by writing SQL queries using TOAD
  • Tested SQL queries, PL/SQL scripts to validate the data and performance of the database.
  • Validate the reports by running SQL Queries against the source system s .
  • Compare the new reports to the original requirements for complete functionality.
  • Worked with VSAM files and loaded the data into Data warehousing using Informatica.
  • Worked with COBOL Copy Books and converted the record format into Informatica Metadata.
  • Worked with the DW Architecture team in Testing complex Delta processing Loads
  • Involved in Oracle SQL Development, Unit Testing and Performance Tuning
  • Involved in creating both positive and negative test data to cover all business scenarios
  • Involved in developing detailed test plan, test cases and test scripts for Functional, Security and Regression Testing. Wrote PL/SQL and stored procedures for extracting as well as writing data.
  • Experience in creating UNIX scripts for file transfer and file manipulation.
  • Developed automated test scripts using QTP to perform Functional and Regression testing.

Environment: Informatica, Windows NT 4.0, SQL Server 2000, Quality Center 8.0, DTS, TSQL, Oracle 9i , DB2, TOAD, SQL, PL/SQL, Cognos ReportNet8.0, VSAM, Cobol, Microsoft Visio 2003, MS Access, Flat Files.

Hire Now