Lead Quality Assurance Engineer

Lead Quality Assurance Engineer

Overview

About Business Unit:

The Automotive Practice at Epsilon is a rapidly growing team, driving growth for major players in the automotive industry - from Original Equipment Manufacturers (OEMs) to dealerships across North America. Part of a 1,600-member multinational team, the practice provides the automotive world’s largest service reminder platform, alongside agency services and digital media solutions. A leader in the automotive space, the team supports over 50% of auto dealerships in North America and maintains relationships with over 280 million customers. Home to innovation and ground breaking technology, our Auto team leads the game in developing outstanding software and solutions for hyper-personalized digital marketing.

Lead SDET will be responsible for planning and performing both manual & automated testing and improving overall quality assurance practices.

The position requires strong Oracle database knowledge for the Data Services group of a complex rule based multi-channel marketing campaign platform that supports Fortune 100 companies.

The position’s purpose includes, but is not limited to:

• Leading the team of 4-5 database testers
• Performing code reviews and mentoring and the coaching the team on deliverables.
• Ensuring timely deliverables or release items.
• Provide services to ensure quality, efficiency and effectiveness of the testing effort
• Knowledge of database architecture and best practices for Oracle SQL and PL/SQL
• Design, develop and execute automated test cases and test scripts
• Review test cases and procedures to ensure coverage of and conformance to business requirements
• Implement testing as required according to test plan and project goals
• Communicate testing progress and results in a timely and accurate manner
• Review and continually improve quality assurance practices, including creation and update of documentation related to quality assurance processes and guidelines
• Provide impact analysis and regression testing of software changes
• Stay ahead of with technology, tools and software quality assurance practices and share knowledge with others
• Support system patch or version upgrade

Click here to view how Epsilon transforms marketing with 1 View, 1 Vision and 1 Voice.

Responsibilities

• Develop test plans and tools to thoroughly test Oracle software on Linux platform.
• Implement manual and automated tests and improve test coverage.
• Collaborate with developers, testers, project managers, business analysts and business users in conceptualizing, estimating, building and testing new software applications and enhancements.
• Assist in defining software development project plans, including scoping, scheduling, providing time estimates for programming tasks and implementation plans.
• Assist in the definition, development, and documentation of software’s objectives, business requirements, deliverables, and specifications in collaboration with internal users and departments.
• Develop technical documentation to define the system components, development environment and implementation planning/strategies
• Prepare and dispense work assignments, provide guidance, and/or review the work of other team members.
• Experience in testing data validation scenarios and Data ingestion, pipelines, and transformation processes.
• Collaborate with QA team to define test cases, metrics, and resolve questions about test results.
• Recommend business process flow improvements and clearly communicate problem/resolution process to project management.
• Perform root cause analysis (RCA)
• Work with multi-functional teams during crisis to address and resolve complex incidents and problems in addition to assessment, analysis, and resolution of multi-functional issues.
• Recognizes and identifies potential areas where existing policies and procedures associated with development requires improvement and helps in the process improvement activity.
• Update/create Knowledge Base Articles and case studies as necessary. Assist in the creation and improvement of Knowledge Management

Qualifications

• Tester with 9-12 years of experience required.

• Excellent skills in Oracle SQL and PL/SQL.

• Hands-on experience testing Unix Shell scripts.

• Hands-on experience on Java/python programming.

• Experienced in handling large volumes of data – for ex: dealing with tables that occupy hundreds of GBs.

• Excellent design and programming skills.

• Knowledge of programming languages and process management methodology.

• Knowledge of test methodologies and their corresponding tools.

• Excellent in impact-analysis and root cause analysis.

• Good experience on Automation Testing, Knowledge of various automation tools

• Proven analytical and problem-solving abilities with ability to anticipate and avoid problems.

• Experience in performance testing, application monitoring and support of production applications with distributed teams.

• Ability to work within tight deadlines and effectively prioritize and complete tasks in a high-pressure environment.

• Strong communication skills (verbal and written) and an ability to communicate with internal and external customers and all levels of management, including communicating technical information to nontechnical audiences.

• Ability to design and build flexible and extensible systems with focus on code reuse and generation.

• Experience in identifying the test strategy, test scenarios for back-end of systems.

• Preferred qualifications

• Educational

• Bachelor’s degree (BE/BTech) in Computer Science, or equivalent

• Experience with API & Web Services testing

• Non-Technical

• Good Analytical and problem-solving skills.

• Ability to diagnose and troubleshoot problems quickly to ma