ETL Tester - Pennsylvania, United States - iSpace, Inc.

Description

Title: Business Intelligence QA Analyst (Data Integration)

Location: Malvern, PA (REMOTE) 3 Days Onsite every month

Contract:- 6+ Contract

ONLY W2, NO C2C

This QA Analyst will be ensuring that data is moving efficiently from an application to a Data Warehouse and focus on improving the information going from the application to the Data Warehouse. Areas that this BI QA Analyst will support will include Data Warehousing, Reporting (the reporting layer is Cognos and Tableau), and Analytics. Duties will include the following:

• Review requirements and design documents with developers and quality assurance manager to confirm expected functionality with technical and business needs
• Implementation, evaluation, and documentation of the developed test cases and scenarios
• Determine test environment and test data requirements, often in concert with integrated systems' owners
• Must be able to communicate with leads regarding project readiness, status, and potential risks.
• Document, quantify, and elevate risks as appropriate
• Provide statistical reporting and analysis as necessary
• Tracks and coordinates defect resolution and retesting, quantifying and mitigating risk accordingly
• Enthusiastically collaborates with business partners to ensure Client Mission and Core Values are fulfilled
• Consult with clients and teammates to identify all facets of an issue and generate a solution
• Understand potential impacts to processes and systems across organization and factors these into solution
• Participate in discovery meetings, provide estimates, analyze, and validate project requirements and technical specifications, perform impact analysis and document key issues.
• Develop the testing strategy and manage the testing effort
• Evaluate data changes and anomalies against previous tends; and provide guidance to resolve variances
• Conduct peer reviews of other analysts' work to assure testing meets specifications
• Resolve issues and develop benchmarks for testing data and provide metrics reporting on test execution and defects
• Participate in testing including Functional Testing, Results validation, Regression Testing, System, Integration Testing, Automated Testing and User Acceptance Testing
• Communicate with data warehouse team (business analysts, data modelers and developers) regarding status, issues, and risks on a timely basis. Identify, mitigate, and drive project issues and risks to resolution
• Analyze data trends, draw conclusions, and recommend direction
• Develop algorithms for capturing data changes and trends to facilitate continuous monitoring of data quality
• Establish validation benchmarks and automated processes for data quality improvements for the weekly/monthly validations and data quality checks to ensure data is accurate for analytics
• Develop trending reports and data quality metrics for reporting
• Provide staff mentoring and guidance to foster a strong team atmosphere with an eye to customer service

Required Technical Skills and Expertise:

• Minimum of 2 years of experience supporting the testing efforts affiliated with Business Intelligence and Data Warehousing efforts
• Knowledge of data mining, statistical analysis, or healthcare data analytics
• Experience with Informatica PowerCenter, Tableau, Cognos, and Anaplan
• Skilled in developing algorithms for capturing data changes
• Strong experience in writing SQL statements (DML/ DDL) and must have familiarity at the application server level
• Must have backend date experience/knowledge of relational databases - can navigate and extract data
• Ability and experience navigating in a Linux and a Unix session
• ETL experience
• Integration Testing experience
• Able to analyze root cause of a problem and demonstrate good sense when handing the problem over to development.
• Assimilates information quickly, communicates complex requirements and issues clearly and concisely.
• Experience working with development team from the initial development of business requirements, through all the Agile/Scrum steps and providing on-going maintenance and support.
• Knowledge of Software testing processes and automated tools, with an ability to apply software testing methods and techniques in a business intelligence environment.
• Excellent critical thinking, negotiation, and problem-solving skills.

If you're interested in above role, please send me your updated resume to or you can call me at