ETL & BI Tester

AYR Global IT Solutions Inc; Hartford (CT); On-site; USD 80,000 - 100,000; Full time

Job summary

A technology solutions company is seeking an experienced ETL & BI Tester to join their Hartford, CT team. The ideal candidate will have strong expertise in data warehouse testing, particularly with ETL, BI reports, and cubes, and must be knowledgeable in databases such as Teradata and Oracle. Responsibilities include participating in requirement gathering, defining test strategies, and managing project deliverables. Strong communication skills are essential for effective coordination with stakeholders.

Qualifications

• Expert in data warehouse testing for ETL, BI reports, and cubes.
• Strong database knowledge including Teradata, Oracle, SQL Server, DB2, and MySQL.
• Good knowledge of HP ALM, TFS, and JIRA.
• Excellent communication skills to coordinate with project stakeholders.

Responsibilities

• Participate in requirement gathering.
• Define program level test strategy for ETL & Reporting.
• Document test scenarios and define test data approach.
• Manage project deliverables with team members both offshore and onsite.

Skills

Data warehouse testing

Database knowledge - Teradata, Oracle, SQL Server, DB2, MySQL

Communication skills

Agile environment

Tools

HP ALM

TFS

JIRA

AbInitio

Cognos

Job description

Job Description

Job Role: ETL & BI Tester

Loction: Hartford, CT

Position Type: Permanent Role

Work Authorization: US Citizen and Green card and EAD GC

Responsibilities

• Participate in Requirement gathering
• Estimation of work and involve in resource planning
• Define program level test strategy for ETL & Reporting
• Document test scenarios and define test data approach
• Identify scope for automation and develop automation utilities with Java/VB to aid in the testing
• Manage day to day project deliverables along with team members at offshore and onsite
• Review project artefacts prepared by team members
• Experience working in Agile environment
• Strong exposure to tools like AbInitio, Cognos

Qualifications

• Expert in data warehouse testing – ETL, BI – reports & cubes
• Strong database knowledge- Teradata, Oracle, SQL Server, DB2, MySQL
• Sound knowledge of DB stored procedures
• Good knowledge of HP ALM/TFS/JIRA
• Excellent communication skills for co-ordination with all the project stakeholders including business
• Metrics & Governance reporting to stakeholders
• Insurance Domain experience preferred.

Additional Information

If you are interested please share your resume at kkahn(at)ayrglobal(dot)com or you can directly call me on(281) 670-9343.