We provide IT Staff Augmentation Services!

Lead Qe Engineer Resume

Seattle, WA

PROFESSIONAL SUMMARY:

  • Around 8.5 years of experience in ETL with big data testing and Automation Testing with various competencies in the Information Technology Industry in various technologies and domains and has expertise in Analysis, Documentation, Reporting activities, Automating.
  • Proactively communicate and collaborate with external customers to analyze information and functional requirement.
  • Experience in validating connectivity products that allow efficient exchange of data between core database engine and Hadoop ecosystem.
  • Experienced in Java Selenium Automation with BDD/Cucumber framework, TestNg class, POM class, locator, Error handling exception handling, Hook, Tag Hook Maven.
  • Experience in Map Reduce programming model for analyzing the data stored in HDFS.
  • Familiar with data architecture including data ingestion pipeline design, Hadoop information architecture, data mining and transformation, distribution and optimizing ETL workflows, entitlement system using swagger application.
  • Experienced on Hadoop testing, HDFS, Querysurge, Data Lake, Kafka message, NDM, Spring XD, Autosys jobs, spark job, Hive and H - Base databases with different data format and batch jobs.
  • Expertise in ETL testing, reporting, data transformation testing on banking application.
  • Experienced on SCD, snowflake, star schema, Dimension table and fact table, partitions Type.
  • Expertise in DDL,DML,TCL, Staging, ODS, Mart, DWH and database testing like functions and triggers
  • Experienced on structured, semi structured and UN -structured data.
  • Experienced on different data bases like tera-data, PostgreSQL,SQL server, MySQL, Sybase,
  • Expertise in finance, Insurance and BFSI domain like lumpsum payments, Withdrawal, Transfer, Loans and good experienced on Agile methodology and there tools like RTC.
  • Understanding of Data Models, Data Schema, ETL and created extensive store procedures, SQL queries to perform back-end data warehousing testing.
  • Expertise in Confidential billing, Web-services API, SOA, Batch jobs, database testing, triggers, functions, backend application process.
  • Experienced on testing tool like SoapUI, filezilla, Mobile Apps, Sauce Lab and Unix/Linux operating system.
  • Expertise in oracle database toad, Postgress,SQL Developer, .
  • Experienced in Test Estimation and identifying the Automating test cases .
  • Experienced in test management tools like QC ALM, Jama, Jira, confluence page.
  • Experienced in using BI tool Cognos, tableau, informatica, abinitio

TECHNICAL SKILLS:

Big Data Technologies: Apache Spark, HDFS, Yarn, Hive, MapReduce, Pig, Sqoop, Flume, Oozie, Kafka, BFSI, Confidential billing, Insurance, Retirement, Telecom, Captial Market

Programming Languages: Core Java

RDBMS: Postgres, MySQL, TOAD,SQL Server & Developer, Oracle11g, Snowflake,Aginity

NoSQL Databases: HBase

Operating Systems: Linux and Windows

Testing Tools: Test Manager, SoapUI, Mobile apps, sauce lab, Unix, ALM, Jama, Jira, GitHub, Autosys,MTM,TFS, Cognos BI tool, tableau, informatica, abinitio

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Lead QE engineer

Responsibilities:

  • Team collaboration documentation handling the offshore team.
  • Understand data mapping from Source to Target tables and the transformation logics applied in staging tables
  • Verifying the each level of data load History, Stage, Presentation, Dimension and tables and views.
  • Involve in setting up the test data and environment for sap to BI/BW process, T-Codes, Queues
  • Validate missing, duplicates, null, and default records as per the design specifications
  • Verify the data between snowflake and Netezza table and data flow in S3 bucket Running the job from DataStage and checking the EC2 logs.
  • Involved in developing Test Cases, Test Plans, Test Execution, Defect Tracking, and Report Generation using JIRA on functional specifications.
  • Identified defects, root cause, and prepared detailed information for developers and business stakeholders.
  • Running the shell and python script jobs form the Putty or tidal and verify the logs in EC2 serve.
  • Automating the manual test cases into automation using python
  • Setting the defect Triage meeting and attending the on-shore scrum call with the team
  • Experience in preparing weekly status, test execution, and test metrics reports
  • Experience in testing of BI/BW data stage and cloud snowflake and Netezza DB, AWS S3 bucket

Environment: Python 2.6.6, Datastage, Aginity 4.9, snowflake, Tidal, EC2, SQL, GIT, UNIX, API, AWS S3 bucket

Confidential, Runnemede, NJ

Selenium/ Big data Consultant

Responsibilities:

  • Understand data mapping from Source to Target tables and the business logic used to populate target table
  • Involve in setting up the testing environments and prepare test data for testing flows to Validate and prove positive and negative cases
  • Verify and validate missing, duplicates, null, and default records as per the design specifications
  • Experience in preparing weekly status, test execution, and test metrics reports
  • Verify the Data flow (Data mapping, Counts, data Transformation logic) from source to target
  • Verify the Database structural changes if any, DB fields and field data is loaded without any truncation
  • Involved in developing Test Cases, Test Plans, Test Execution, Defect Tracking, and Report Generation using JIRA on functional specifications.
  • Involved in end-to-end defect management of assigned projects. Identified defects, assess root cause, and prepared detailed information for developers and business stakeholders.
  • Experienced in Data Validation and Backend testing of databases to check the integrity of data.
  • And also used extensively HQL Queries to analyze the HDFS data
  • Experience in testing of Data Warehouse/ETL Applications developed in Informatica, Ab initio using SQL Server, Oracle, Hadoop, DB2,
  • Evaluate ETL/BI specifications and processes and testing API in postman tool.
  • Handling the offshore team and attending the scrum, Requirement, Defect Triage call
  • Experience with different file systems /databases like Oracle, HDFS and MS SQL Server to extract and load data using Sqoop.
  • Validating the Mapping in Infomatica IDQ, Maplet, worklet, workflow, session.
  • Extensively tested Data Warehouse or Big Data applications using Hadoop and ETL.
  • Worked on queries, and scripting languages like HQL, Apache Pig, and SQL.

Environment: JAVA 1.8, Infomatica 10.1, AQT, PUTTY, SQL, SQL Server 2005/2008, UNIX,POSTMAN,Rest Api, Oracle 9i, Maven, Jenkins, Test NG, Intellij, GIT

Confidential

Senior ETL big data/Selenium Automation tester.

Responsibilities:

  • Involved in the requirement walk through and test estimation.
  • Designed test cases for positive, negative, alternative flows and ensured complete requirement coverage. selenium Automating using BDD/Cucumber , TestNg class, POM class, Hook, Tag hook, Junit
  • Code check in using the Git application
  • Tested range of Big Data architectures and frameworks including Hadoop and deployment of code build.
  • Validating the data flow between GitHub, Symphony, Maprf (Hbase) tables, swagger rest API for entitlement system, Batch Jobs.
  • Involved in validating HDFS for the client system against sourcefeed type (parquet and Avro file or DB pull) and validating data using hadoop commands.
  • Triggering the spring XD jobs and validating NDM data in down/up stream and Data Lake portal
  • Involved in validating the different abinitio pset jobs and deployment of Autosys jobs and control m tool for scheduling the job.
  • Validating internal and external table of hive to load large sets of structured, semi-structured data, NoSQL and a variety of portfolios and spark jobs.
  • Involved in testing the BI report using Cognos tool.
  • Validating the restapi requests and automating using postman application.
  • Involved in validating the data ingestion and data validating across the different ETL stages using HQL and SQL query
  • Followed the Agile Testing practices and guidelines, including Defect Management using HP ALM Quality Center tool and handling the small team.
  • Automating the large set of data using query surge tool and MD5sum tool.

Confidential

ETL/Selenium Tester

Responsibilities:

  • Involved in the handing the integration team and conducting the scrum call
  • Identifying test artifact like Test out line, scenarios, writing test cases outline for HLD and LLD document.
  • Writing the Integration test cases for functional, UI, Batch testing.
  • Involved in test cases review and uploading in JAMA.
  • Involved­­­­­ in test data preparation, setting the test environment and preparing the different feed (Flat file) as per the file layout.
  • Involved in validating data in different table using join query in postgresql and validating the data in different level of ETL stages as per mapping FSD.
  • Involved in the configuring the jobs scheduler in informatica and validating the data in Staging, ODS, MART tables.
  • Modifying the transformation,maplet, work flow in the Infomatica IDQ
  • Involved in sanity, functional, system, regression and retesting in different environment and verifying DWH file
  • Involved in testing the BI reports in tableau tools
  • Debugging the error in the logs and capturing the evidence and logging defect in jira.
  • Involved in the performing the end to end testing the application.

Environment: JAVA 1.7, Infomatica 9.1.0, postgresql 10.6, Linux (openSUSE 10.1), filezilla, XML SoapUI 4.5, Oracle 11g, JUnit, Jira, JAMA

Confidential

ETL/Selenium Tester

Responsibilities:

  • Involved in the requirement walk though discussion, Comparing and adopting banking terminology with requirement and test estimation and handling the team.
  • Involved in converting manual test cases into automation selenium script.
  • Developing the automation script for new modules and worked on hybride module.
  • Involved in preparing the automation test data and preparing the selenium script for new functionality.
  • Involved in automating the lump sum Payments, end to end testing (Withdrawals), Transfer, Loans.
  • Debugging the error in the logs and capturing the evidence and logging defect in QC ALM linking the defect in RTC.
  • Involved in the Preparing Automation status report and updating with client in scrum meeting.
  • Involved in debugging error and documenting the logs.
  • BDD through Cucumber using Selenium automation using core java and Responsible for planning regression test stories in every Sprint.
  • Maintain Code versions through GIT, maven. log4j

Environment: JDK 1.7,Selenium 3.1.0 PRISM, QC ALM 12.5, RTC, SQL Developer 18,SoapUI 5.2, Oracle 11g, Eclipse 4.5, Maven, Jenkins, Test NG, Intellij, GIT

Confidential

Associate consultant

Responsibilities:

  • Involved in detail understanding of application and data flow for new CRs.
  • Involved in testing the web management, order management, 2G& 3G usage, MFS, AAM, POS, CRM, CSM.
  • Involved in Data base testing like trigger and back end validation.
  • Verifying and validating the data in table of ensemble, enabler DB using SQL queries.
  • Regression, compatibility, functional, system integration and sanity testing across different Releases and builds and also testing the SOA, API application using SOAPUI
  • Production sanity across the different releases and Confidential billing, port-in, port out testing.
  • Closely interacting with development, infra and delivery team
  • Bug reporting, defect retesting using the QC ALM 12.5
  • Involved in processing flat & XML file, running the batch jobs in back end and logs in the putty.
  • Involved in testing the Confidential mobile finance service like E-wallet, M-wallet, and Auto payment.

Environment: Enabler and Ensemble, Mainframe, toad (SQL) 6.5, SoapUI 4.5, Quality center 11, CRM8, CSM Confidential Billing, Linux, XML Bridge

Confidential

Test Engineer

Responsibilities:

  • Analyzing the problem of description and resolving it by understanding the GHLD.
  • Writing the unit test cases and identifying the regression suit.
  • Test environment configuration in the Data base as per the logs error.
  • Performing the unit testing of triggers, convertors and flat file on unix platform and debugging the root cause of failure.
  • Performing the regression testing for different operators and preparing the test detail reports to client.

Environment: C++, UNIX, QC, SQL Developer, Webservices, Resfull APL

Hire Now