SUMMARY

• Motivated and ambitious software test engineer with over 5+ years of professional experience in Quality Assurance
• Worked on Manual and Automation testing process for diversified application like ETL, Data warehouse, Business Intelligence Reporting.
• Proficient in writing SQL scripts to validate ETL flow, Data Reconciliation, Initialization, and Change Data Capture, Delta Processing, Incremental process.
• Good experience with different data sources, data staging, data profiling, data Cleansing, data Scrubbing, data validation and data Migration based on the business and functional requirements.
• Experience in testing Data Marts, Data Warehouse/ETL Applications developed in Informatica using Oracle, Teradata, SQL Server and UNIX.
• Data Warehousing experience using Informatica Power Center 9.x/8.x/7.x (Workflow Manager, Workflow Monitor, Source Analyzer, Mapping Designer) ETL.
• Proficient in designing, reviewing and documenting system test plans, defining test procedures and creating test cases on the basis of product release features, client requirements and related technical documents.
• Strong analytical and QA testing skills, capacity for work and diagnostic ability, gathering different kinds of project requirements. Covered various testing methodologies such as Agile and Waterfall models of SDLC.
• Experience in Test Management and defect tracking using tools like HP ALM, HP Quality Center, IBM ClearQuest, Rally, Test Director and Jira
• Worked with Datawarehouse/ETL tools like Informatica, DataStage, SSIS and Business Intelligence reporting tools like SSRS, Power BI.
• Proficient in Functional and Regression testing of Client - Server and Web-Based Applications. Hands -on experience with diverse testing tools like QC.
• Close co-ordination with Salesforce.com development and environment team to troubleshoot the issues and fulfill the data requirement.
• Strong leadership, interpersonal and excellent analytical skills

TECHNICAL SKILLS

ETL: Informatica Power Center, IBM DataStage

Reporting Tools: SSRS, SAP Business Objects, Power BI.

Databases: Oracle 12g/11c/10i, SQL Server 2014/2012/2008 R2/2005, PL/SQL,DB2, Teradata V2R6 Aws S3, Amazon Dynamo DB, HDFS, Hive SQL

Database Modeling: Star Schema, Snowflake schema, Fact and Dimensions Tables, Physical and Logical Data Modeling.

Programming: Unix Shell Scripting, Java, C#, HTML, XML

Testing Tools: QuickTestPro (QTP), IBM Rational Clear Quest and Load Runner, Selenium IDE, Test NG, SOAP UI, Postman

Defect Tracking Tools: HP Quality Center, Jira, Version One, Rally

Environment: Windows, Unix, Red Hat Linux

PROFESSIONAL EXPERIENCE

Confidential

ETL Test Engineer

Responsibilities:

• Analyzed business requirements, data mapping specifications and developed Test Plans, Traceability Matrix, Test Cases, Expected Results and Prioritized tests for the ETL Mappings
• Work closely with software developers/project owners and BAs to develop and execute thorough test suites in all phases of the software development cycle
• Tested Complex Informatica Cloud ETL Mappings based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables in Hive Tables.
• Responsible for Setting up Web Services project using WSDL in SOAPUI.
• Run API calls using SOAP UI and Postman
• Involved in meetings to discuss the findings in the executed tests and decide the next steps.
• Developed inline view queries and complex SQL queries and improved the query performance for the same.
• Performed extensive testing on big data Cloudera platform.
• Did extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.
• Update project leads on a day to day basis on the developments.
• Wrote UNIX Shell Scripts and pmcmd command line utility to interact with Informatica Server from command mode.
• Extensively written Hive SQL queries for data validation between source and target tables as per the mapping documents.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables in Hive tables.
• Preparation of Test Cases based on ETL Specification Document, Use Cases, Low Level Design document.
• Analyzed large data sets by running Hive and Impala queries
• Responsible to validate the data where the daily feeds are processed through HIVE and stored in the HDFS
• Created Cases in Salesforce service cloud and validated data in Salesforce standard and custom objects using SOQL.
• Created payment request, gift requests and payment request lines for cases in Salesforce service cloud and validated data in the custom objects.
• Involved in testing the Validation Rules, Workflows and Approval Processes for new Tasks, field updates, and Email generation according to application requirements.
• Involved in verifying security and sharing rules for different users at different levels of organization.
• Implemented TestNG Annotations and customized Testng.xml for parallel, cross - browser and re-run fail test cases.
• Interacted with the Business users to identify the process metrics and various keys dimensions and measures.

Environment: Informatica ICS, PL/SQL, Oracle 12g, Stored Procedures, UNIX Shell Scripting, Jira, Hadoop, Hive SQL, Impala, Ambari, Kafka, Sqoop, HDFS, Salesforce Service Cloud, Salesforce Sales Cloud, Salesforce Data Loader, Informatica Cloud, Java, Test NG.

Confidential

ETL Test Engineer

Responsibilities:

• Analyzed business requirements, data mapping specifications and developed Test Plans, Traceability Matrix, Test Cases, Expected Results and Prioritized tests for the applications for various modules using Quality center.
• Created complex SQL queries for querying data against different data bases for data verification process.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Executed test cases for web-based MicroStrategy reporting application.
• Tested Complex ETL Mappings based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created Test cases for Data Acquisition and Data Delivery and tested the data accuracy for all the transformations
• Developed Automation Test Scripts using Junit and Test Ng Framework
• Responsible for Setting up Web Services project using WSDL in SOAPUI and provided setup help to other team members
• Generated the detailed Bug reports and Defects were tracked, reviewed and analyzed.
• Involved in meetings to discuss the findings in the executed tests and decide the next steps.
• Validated that application meets requirements and functioning as per the technical and functional specifications.
• Used Quality Centre to state requirements, test plan, test cases, and update test run status for each iteration and to report the defects.
• Worked on issues with migration from development to testing
• Working in Agile environment attend daily stand up, sprint planning, backlog grooming refinement and retrospective meetings.
• Created Requirement Traceability Matrix by mapping the requirements with test cases to ensure that all requirements are covered in testing.
• Analyzed large data sets by running Hive queries
• Used Data Loader to insert, update, and bulk import or export of data from Salesforce.com Objects. Used it to read, extract, and load data from comma separated values (CSV) files.
• Responsible to validate the data where the daily feeds are processed through HIVE and stored in the HDFS
• Interacted with the Business users to identify the process metrics and various keys dimensions and measures.

Environment: Power BI, PL/SQL, Tera Data, Stored Procedures, Salesforce, UNIX Shell Scripting, Quality center, Java, GitHub, Jenkins, Maven, Test NG Framework, SQL Server 2017/2014, Apache Hadoop, Hive SQL, Scoop, HDFS