Senior ETL Test Engineer - Data Warehouse (NO SPONSORSHIPS / NO 3RD PARTIES)

25 May 2024

Vacancy expired!

NO SPONSORSHIPS / NO 3RD PARTIES Senior ETL Test Engineer - Data Warehouse

Philadelphia, PA / HYBRID

Develop comprehensive data verification and validation for backend data-oriented systems using modern frameworks such as Pandas, Informatica and other industry tools approved for use at Client as applicable.

Using languages like Python and R with a modern IDE (Anaconda, Jupyter notebook, or similar), and source code management products like GIT.

Develop solutions to automate testing of databases and ETL processes built using technologies and frameworks such as SSIS, Oracle Integration products (Oracle Exadata preferred), Data Warehouse products

and other industry tools approved for use at Client as applicable. Work closely with Sr. QA Engineers and key SMEs such as the Product Owner, System Architect, and/or Scrum Master to plan the test strategy/approach for scalable/risk-based test coverage, inculcating the development and execution of scripts/scenarios and mining/creation of custom and applicable testing data. Incorporate the tests aligned with the application under test database schemas using complex stored procedures and queries in environments such as SQLServer, Oracle, or similar. Participate on Client, department, or system projects of moderate to high complexity. Demonstrates effective Core Competency skills for grade and position. Performs other related duties as assigned. Actively involved in the accomplishment of departmental and Client wide quality initiatives. Complies with all applicable information security policies, guidelines, and practices. Mentor junior QA Engineers by providing direction and guidance when needed. with a concentration in Information Technology or Computer Science or equivalent significant experience in information technology and software testing is required.

Knowledge and Skills:
  • Strong written and oral communications skills. Independently, presents both orally and in writing, findings and assessments; prepares and presents information and responses to higher complexity inquiries; demonstrates the ability to manage the communication process; the ability to communicate with clients, colleagues and management to explain complex issues clearly and concisely; actively engages in transferring technical knowledge; diffuses conflict and builds consensus.
  • Strong analytical and problem-solving skills.
  • Logical, analytical, and creative approach to problems; Demonstrates strong level analytical and problem-solving skills; organizes data and information in a manner that effectively communicates issues; identifies underlying issues or problems and recognizes symptoms that indicate more severe problems or issues.
  • Strong interpersonal skills.
  • Demonstrates the ability to lead and participate effectively on a team; leads complex and diverse team efforts by virtue of both technical expertise and leadership skills of influence; draws on experience to resolve higher complexity issues; displays strong interpersonal skills in dealing with people at all levels of an organization.
  • Strong time management skills. Possess a meticulous and organized approach to work; Identifies and assesses complex supervisory issues; effectively manages complex issues to meet our objectives and goals.
  • Strong knowledge of various computer systems and technologies with an ability to learn new skills and technology quickly. An awareness of current issues affecting the industry and its technologies.
  • Subject to minimal or no oversight in work performed; serves as mentor and/or coach and provides constructive feedback to less experienced staff; engages other stakeholders in collecting feedback and input to complete work activities.

Education and Experience:
  • Bachelor's Degree
  • CTFL and Product Specific Certifications as applicable per track are preferred.
  • Minimum 7 years of experience designing and developing tests for ETL and Data Warehouse solutions using a software development approach. Minimum 5 years of automation development experience with technologies described above.

Client offers a great benefits package that features:
  • Medical (4 options), Prescription, Dental (3 options), and Vision Insurance with no waiting period
  • 401k/Thrift Plan with generous employer match
  • Employer-funded Pension Plan
  • Paid Vacation/Sick Time & Holidays
  • Monthly $100 Commuter Allowance
  • Flexible Spending Accounts and Healthcare Spending Accounts
  • Flexible Work Schedule available in most departments
  • Life Insurance and Long Term Disability Insurance
  • Tuition Reimbursement (undergraduate and graduate)
  • Parental Leave
  • Free onsite 24/7 Fitness Center including training classes, Peloton bikes and locker room / shower facilities
  • Onsite Cafeteria & Coffee Shop
  • Additional Convenience Benefits, Discounts and More

#tech

  • ID: #49992641
  • State: Pennsylvania Philadelphia 19019 Philadelphia USA
  • City: Philadelphia
  • Salary: USD TBD TBD
  • Job type: Permanent
  • Showed: 2023-05-25
  • Deadline: 2023-07-23
  • Category: Et cetera