AVP Quality & Data Engineering, SDET Leader

Are you a team player? Are you curious to learn? Are you interested in working in meaningful projects? Do you want to work with cutting-edge technology? Are you interested in being part of a team that is working to transform and do things differently? If so, LPL Financial is the place for you!

Job Overview:

As an AVP, Software Development Engineer in Test (SDET) you will join a team of talented developers in test and work on next generation application software to enhance our engineering best practices, tools, design patterns and frameworks.

Responsibilities:

• Develop and execute test plans, test cases, and test scripts to validate software functionality, performance, and security, focusing on AWS, SQL, and financial commission systems.

• Perform database testing to validate data integrity and accuracy.

• Experience with Third party compensation tools like Varicent or Pega.

• Collaborate with product, engineering, and other domain teams to understand features, develop, and automate test cases, improve product quality and shorten release time from dev to production.

• Hands on Oracle Application Testing Suite & compensation SAS applications.

• Using different software testing methodologies to deliver quality software.

• Coordinating and driving E2E testing with cross-domains.

• Hands-on knowledge in any of the cloud provider like AWS, Azure etc. Also exposure to services like EC2, S3, RDS, Lambda etc.

• Being able to identify the manual processes and solve through automation.

• Working with software engineers to understand product architecture and features.

• Participate in code reviews to advocate and improve code quality and coding standards.

• Create and maintain data scenarios to support test plans and test cases

• Analyzing test results, being a vocal proponent for quality in every phase of the development process.

• Documenting and track bugs to closure.

• Working in an Agile/Scrum environment to deliver high quality software.

• Mentoring team and individuals on best automation practices, design and implementation.

• Documenting and maintaining respective processes.

• Strategic Quality Leadership, Cross-Functional Collaboration, Mentorship & Technical Enablement, Governance & Process Ownership.

What are we looking for?

We want strong collaborators who can deliver a world-class client experience. We are looking for people who thrive in a fast-paced environment, are client-focused, team oriented, and can execute in a way that encourages creativity and continuous improvement.

Requirements:

• Bachelor’s Degree, Computer Science or similar, plus 6+ years of experience OR Master’s Degree, Computer Science or similar, plus 5+ years of experience working as a Developer or QA Engineer or SDET working in Agile scrum teams.

• Solid experience in Oracle, SQL Server, PLSQL and ability to understand/write complex SQL queries.

• Proven ability to design, develop, and maintain automated test frameworks, utilizing tools like Selenium, python, Java or similar.

• Minimum of 5+ years of Hands-on programming/development experience in one of the programming languages: Python, Java, and automation frameworks like Selenium, Appium, TestNG, etc.

• Proficiency in creating and executing test plans, test cases, and test scripts to validate software functionality, performance, and security.

• Hands-on experience with test processes, test methodologies, test strategy, test plan and test case design & execution.

Technical Competencies:

• Excellent SQL knowledge with the ability to write complex queries for validation as well as review stored procedures for verification.

• Experience on ensures data accuracy and integrity during the Extract, Transform, Load (ETL) process, validating data flows, identifying discrepancies, and verifying data quality across systems, often using SQL and other relevant tools

• Experience creating strategies to cover vendor integrations.

• Excellent communication skills are both written and verbal.

• Ability to thrive in a fast-paced agile environment where resourcefulness, determination, and strong problem-solving skills are necessary for success.

• Positive attitude and ability to take ownership on releases/ features / stories / tasks to deliver with quality.

• Minimum of 2 years of hands-on experience working with AWS services like S3, RDS, DynamoDB, Lambda, and exposure to Bedrock model integrat