Senior ETL Test Engineer

Senior ETL Test Engineer

28 May 2024
Pennsylvania, Philadelphia, 19190 Philadelphia USA

Senior ETL Test Engineer

Vacancy expired!

Our banking client is seeking a Senior ETL Test Engineer (Data Warehouse) to join the team onsite in Philadelphia. This is a hybrid schedule and a direct hire opportunity.

Job Summary:
This position designs or modifies testing/data validation/quality assurance for automated applications and procedures for solutions to business problems of moderate to high complexity. Also has full operational knowledge of all phases of testing and is able to work at a high level of complexity related to quality assurance with minimal supervision. Directs and reviews work of lower-level personnel and/or may perform as an individual contributor on large and complex systems. Has working knowledge of one or more FRS system testing platforms.

Responsibilities:
  • Develop comprehensive data verification and validation for backend data-oriented systems using modern frameworks such as Pandas, Informatica and other industry tools 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.
  • 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 Bank, 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 Bank 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.

Required Skills:
  • 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.
  • 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.
  • 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.

Related jobs

  • Reference #: R45953 Company Overview At Motorola Solutions, we\'re guided by a shared purpose - helping people be their best in the moments that matter - and we live up to our purpose every day by solving for safer. Because people can only be their best when they not only feel safe, but are safe. We\'re solving for safer by building the best possible technologies across every part of our safety and security ecosystem. That\'s mission-critical communications devices and networks, AI-powered video security & access control and the ability to unite voice, video and data in a single command center view. We\'re solving for safer by connecting public safety agencies and enterprises, enabling the collaboration that\'s critical to connect those in need with those who can help. The work we do here matters.Department OverviewThe Product Development & Operations Group at IPVideo design and manufactures IoT based products for the safety and security industry. The team has developed the HALO and SentryERS products and continues to develop many more to add to the product portfolio. Within the Product Development team, the Software Engineer will design, develop, and maintain embedded firmware and software on Electronics systems and products ensuring timely delivery of projects.Job Description We are seeking a Senior Embedded Software Engineerwho will design, develop, and maintain firmware and software on IoT electronics systems and products. This person will be responsible for applying principles of firmware and software engineering to various products ensuring they meet product requirements. You will be responsible for capturing project requirements, proposing implementation options, implementing firmware/software, testing software and releasing into production.

  • IT Advisor, Technology Consulting - Digital and Emerging Technologies - Senior Engineer (Integration Architect) (Manager) (Multiple Positions) (1498382), Ernst & Young U.S. LLP, Philadelphia, PA.

  • Description:

  • Reference #: 1332 TYLin is a globally recognized, full-service infrastructure consulting firm committed to providing innovative, cost-effective, constructible designs for the global infrastructure market. With over 3,000 employees throughout the Americas, Asia, and Europe, the firm provides support on projects of varying size and complexity. Together, we enhance conventional designs with smarter, more resilient systems. We provide people with better mobility. We steward precious resources by finding more sustainable solutions.

  • Reference #: 0963 TYLin is a globally recognized, full-service infrastructure consulting firm committed to providing innovative, cost-effective, constructible designs for the global infrastructure market. With over 3,000 employees throughout the Americas, Asia, and Europe, the firm provides support on projects of varying size and complexity. Together, we enhance conventional designs with smarter, more resilient systems. We provide people with better mobility. We steward precious resources by finding more sustainable solutions.

  • Reference #: R184307 Locations: VA - McLean, United States of America, McLean, Virginia

  • Reference #: R180417 802 Delaware Avenue (18052), United States of America, Wilmington, Delaware

Job Details

Jocancy Online Job Portal by jobSearchi.