We provide IT Staff Augmentation Services!

Etl Qa Engineer Resume

SUMMARY

  • Around 7+ years of total IT experience and very good knowledge QA of Software Applications and Testing.
  • Extensive experience in testing of data warehouse / data marts for business applications with Banking, Financial, Brokerage, Insurance, Pharmaceuticals, Manufacturing.
  • Experience in Data Warehousing technology in building and managing various data warehouse / data marts using Informatica products such as Informatica Power Center/Power Mart, Power Connect, Power Analyzer and Power Exchange Tools.
  • Expertise in ETL backend and Business Objects Reports testing
  • Experienced testing Web Services using SOA, SOAP UI, and REST & Custom Based Approach.
  • Experience in using SOAP Sonar for providing simple, intuitive and comprehensive testing for SOAP - , XML- and REST-based services
  • Experience inSDLCand Agile methodologies.
  • Experience working in using Databases like Oracle, Teradata, SQL Server, DB2, MS Access and DB2. Expertise in Database Programming (Stored Procedures, Triggers, Packages, PL/SQL, Joins) using Oracle.
  • Extensive testing ETL experience using Informatica Power Center 9.0/8.x/7.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer.
  • Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
  • Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
  • Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
  • Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
  • Extensive experience in Business Intelligence reporting tools using Cognos Series, Power Play, Transformer, Impromptu Web Reports (IWR).
  • Extensively used SQL, PLSQL to create complex queries, SQL Override, Stored Procedures, and Triggers.
  • Experienced in Data Modeling, Erwin, Star/Snow Flake Schema Designs, Logical Data Modeling, Normalization, Physical Design, Data Analysis, Data Modeling, Reports and Report Design.
  • Expertise in writing Unix Shell Scripts.
  • Excellent Analytical and Logical Programming skills with a good understanding at the Conceptual Level and possess excellent Presentation, Interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.

TECHNICAL SKILLS

OS: Sun Solaris 2.7/2.6, IBM AIX 4.3/4.2, MS DOS 6.22, Win NT/2000/98/95.

ETL Tools: Informatica Power Center 9.0/8.x/7.x, (Source Analyzer, Warehouse DesignerTransformation Developer, Mapplet Designer, Mapping Designer, Data stage 7.x

BI Tools: Cognos 8.0 Series, Business Objects, SSAS, Crystal Reports and Siebel Analytics

Languages: SQL, PL/SQL, VB, C, C++, COBOL.

Databases: Oracle 11.6/10g/9i/8i, MS Access, SQL Server 2008, DB2 9.x, Teradata V2R6Other Tools Erwin 4.5/4.0/3.5.5/3.5.2

Testing Tools: Load Runner 7.8, QTP 8.2, Quality Center 10, and HP ALM 11.0

PROFESSIONAL EXPERIENCE

Confidential

ETL QA Engineer

Responsibilities:

  • Coordinating with (on-site/offshore) in their daily tasks which include project tasks, operations support tasks, and management of application defects and testing.
  • Created Test Strategy, developed Test Plan, Detailed Test Cases, wrote Test Scripts by decomposing Business Requirements, and developed Test Scenarios to support quality deliverables.
  • Collaborated with key stakeholders including infrastructure engineers, business analysts, development teams, project managers and management, to report test progress and escalate issues requiring attention
  • Maintained and updated the RTM to provide input to project managers and others on the testing process and progress
  • Responsibilities included acceptance testing, functional testing, Integration testing, System testing, UAT.
  • Conducted peer review of test cases and provided feedback on areas of improvement
  • Wrote and executed test scenarios, and coordinated and communicated the status of the testing effort to ensure that the QA Best Practices.
  • Used SQL queries to retrieve data from DB2 and validate them, tested on the Mainframe for data validation and also tested for ETL processes
  • Coordinated and carried out Black Box, Functional, Integration, and Regression
  • Performed backend testing of the DB by writing SQL queries to test the integrity of the application and Oracle databases.
  • Followed Agile/Scrum development process
  • Performed software support as necessary in both production and testing environments.
  • Used Quality Center to manage defects and track bug lifecycle
  • Identified severity and priority of bugs, communicated to development team and helped minimize duplication of defects during testing cycle via QC
  • Maintained and published all test results, planned and managed UAT process by interacting with stakeholders, analyzing UAT defects and also acted as support for User Education Issues post Go-Live
  • Coordinated defect review meetings with the project team to identify the process to address the open issues
  • Performed testing in composite tool from where the data has been pulled after the ETL processing is done and has been used for reporting purpose.
  • Worked on Web Services Testing (XMLs)

Environment: Mainframe, Putty, HTML, HP ALM, Share Point, XML, JIRA, JAZZ, Informatica 9.1, Teradata, Micro strategy - DART9.4, Dynamics 365, VSTS

Confidential, MD

ETL CQ Test Engineer

Responsibilities:

  • Interacted with clients to determine User requirements and goals, Participated in analysis of Business and functional requirements
  • Collaborating with work stream CQs and PDs to understand their needs, and then implementing, getting reviews and releasing the components
  • Developed Test Plan and overall Test Strategy for the Application.
  • Developed Test cases, Test plans, and Test procedures using MS Excel for Functional and Regression test.
  • Create test cases and automate them using Control-M
  • Automate tests which have file creation or file transfer on UNIX, verifying the jobs in Control-M, validate database and verifying the mapping
  • Automate tests for verifying Settlements functionality for Debit and Credit transactions.
  • Create test cases on control-M flows of various features like: Account Master, Customer master flow, DB2, Misc data, Authorization Log, Customer information.
  • Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
  • Attend defect calls with A/R Vendor TSYS.
  • Involve in QA Signoff of CM tickets for production issues after month-end releases.
  • Handle migration testing of Informatica 8.x to 9.x from Control-M part.
  • Work with Release Management team to get code push to various QA environments.
  • Support End to End defects.
  • Carry out Regression testing.
  • Demos of the functionality tests to the Product Owner before acceptance of stories.
  • Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs
  • Responsible for communicating Defect Status Reports to business in project meetings
  • Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts
  • Written several SQL statements to confirm successful data transfers between source and target
  • Worked on power exchange to compare the data from source to target.
  • Worked on EBCDIC files.

Environment: Informatica 9.1, 8.6, TOAD 11.6, Power exchange 9.1, Control-M, Putty, UNIX, WINSCP

Confidential

ETL QA Engineer

Responsibilities:

  • Developed Test Plan and overall Test Strategy for the Application.
  • Developed Test cases, Test plans, and Test procedures using MS Excel for Functional and Regression test
  • Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs
  • Involved in testing various EDI transactions like 837 and 835.
  • Involved in adding Clients, Groups, members and processed claims
  • Validated HIPAA edits are bypassed based upon trading partner settings.
  • Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, Performance, Scalability and Regression Testing.
  • Documented the validation rules, error handling and test strategy of the mapping.
  • Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
  • Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
  • Extensively used T-SQL to verify and validate the data loaded to the SQL Server
  • Created temporary tables for validations after understanding the transformation logic.
  • Tested several UNIX shell scripting for File validation and also PL/SQL programming
  • Tested complex mappings using mapplets and reusable transformations.
  • Established and documented ETL QA standards, procedures and QA methodologies.
  • Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts
  • Extensively used Informatica power center for extraction, transformation and loading process.
  • Extensively tested several ETL Mappings developed using Informatica.
  • Involved in testing data reports. Written several SQL queries for validating the front-end data with backend.
  • Conducted back to back meetings with developers and discussed about all open issues.
  • Conducted test case reviews to ensure scenarios accurately capture business functionality.
  • Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
  • Written several SQL statements to confirm successful data transfers between source and target.
  • Worked with data profiling, data scrubbing and data cleansing.
  • Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports

Environment: Informatica Power Center 6.1, Quality Center, Windows NT, Micro Strategy, Oracle 8i, SQL Server, SQL, PL/SQL, SQL*Plus, Toad, VSAM Files, XML, XSD

Hire Now