QA Engineer
Location : Jaipur, India
Experience : 5 Year
Rate: $20 / Hourly
Availability : 1 Week
Work From : Any
Category : Information Technology & Services
Projects
Project Name ALPS SEO
Client iQuanti India
Role ETL and Power BI QA
Tools Used Snowflake, Amazon Athena, Matillion, Microsoft Power BI, JIRA.
Team Size 18
Description: ALPS is an SEO Tool that make search predictable by leveraging the power of data science in SEO strategy. ALPS provide unlimited access to them most comprehensive keyword and competitive database across all the industries. With its enterprise SEO platform user can effortlessly gain deep insights on trends and find patterns in search ranking and identify opportunity to optimize it’s with content.
Roles and Responsibilities:
Understanding the Business and Functional Specification Requirements.
Understanding Mapping documents and Transformation Rules.
Prepared and Executed SQL queries to verify the data from source to target.
Verified column mapping between source and target.
Responsible for creating complete test cases, test data, and reporting status ensuring accurate coverage of requirements and business processes.
Running the ETL Workflows & Jobs for ETL process.
Interactions with Development team to resolve the issue
Involved in detailed design and deployment documents.
Played key role in preparing SQL queries while preparing test scripts.
Designed, Reviewed & Executed Test cases.
Defect Analyzing and preparing test plan documentation.
Project Name Business Intelligence Application
Client CIMB Bank
Role ETL Tester
Tools Used SQL Developer, Oracle, Informatica, JIRA, MS Office
Team Size 15
Description: CIMB Bank as a Financial Institution uses various legacy systems in their day to day transactions. CIMB Bank is replacing its existing Corporate Client Solution Portal design and capabilities with new Siebel CRM System. The business area is Investment Banking the goal of this project is to build a Business Intelligence Application to provide Single Customer View, Client Management, Deal Management, Invoice Management and Revenue Management Dashboards for Bank’s Management and Operational Users.
Roles and Responsibilities:
Involved in ETL process testing using Informatica ETL tool.
Worked with ETL group for understanding mappings for dimensions and facts.
Regression scope Identification.
Involved in Functional Testing & Regression Testing.
Presented Test plan, Test approach, Test Scenarios to clients.
Proficient in validating the ETL flow by applying DW testing strategies like Record count, Data validation, duplicate records and business logic validations.
Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings (Table mappings and Field Mapping).
Working on Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.
Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
Running ETL jobs and finding and informing Job Failures to the DEV team.
Self-learning ability.
Analytical and Problem solving skills.
Flexibility and Adaptability
Ability to work with total commitment towards team work.
{{contact.cdata.phone}}
{{contact.cdata.email}}
View Resume
