ETL Tester - BI Tester

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