ETL Tester

Position: ETL Tester

Location: Pittsburgh, PA (Hybrid 3 Days/Week)

Note: 3 Days/week Hybrid

Summary: The role is aligned to the delivery team responsible for planning, development, and delivery of Insurance products for the Benchmarks and Indices business. This is a hands-on ETL Tester with focus on delivering results on-time, in-full to the expected quality levels.

Job Description:

EDW source to target testing (SQL scripting - manual and automation).

Data transformation/manipulation testing (SQL scripting - manual and automation).

Data quality/completeness validation (SQL scripting - manual and automation).

Experience in running the processes through the scheduler.

Quality Assurance, Process Improvement and Collaboration:

Develop and execute (Develop) comprehensive test plans to validate data within on-prem and cloud data warehouses.

Conduct thorough testing of ETL processes, dimensional data models, and reporting outputs.

Identify, document, and track data quality issues, working closely with data engineers to resolve them.

Job Responsibilities

Bachelors or Masters in Computer Science or equivalent.

Strong understanding of Data Warehouse & Data Quality fundamentals.

3 to 5 years of experience in data warehouse development/testing.

3 to 5 years of experience with SQL Server and SSIS/SSAS/SSRS testing.

Must be experienced in Data Warehousing Projects with good knowledge of ETL testing.

Strong in SQL, RDBMS, ETL, and DW concepts.

We can offer you:

A highly competitive compensation and benefits package

A multinational organization with 52 offices in 20 countries and the possibility to work abroad.

Laptop and a mobile phone

10 days of paid annual leave (plus sick leave and national holidays)

Maternity & Paternity leave plans

A comprehensive insurance plan including medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region)

Retirement savings plans

A higher education certification policy

Commuter benefits (varies by region)

Extensive training opportunities, focused on skills, substantive knowledge, and personal development.

On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses.

Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups.

Cutting edge projects at the world’s leading tier-one banks, financial institutions and insurance firms.

A flat and approachable organization.

A truly diverse, fun-loving and global work culture.

SYNECHRON’S DIVERSITY & INCLUSION STATEMENT

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Synclusive’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.