LPL Financial
Sr Database Tester & QE Engineer
LPL Financial, Fort Mill, South Carolina, United States, 29715
Job Overview
Our team is actively seeking a motivated and talented Sr. Database Tester / QE Engineer who is passionate about Data Ingestion, Quality and Lineage; and testing software through automation. You will be part of an interdisciplinary team of hardware, firmware, software, system, and test engineers to develop and integrate cutting-edge technologies for a Financial Services Company, building AI-driven E2E automation solutions connecting the Advisor, the Investor, and Data platforms.
You will work closely with product and engineering teams to understand features, develop and automate test cases, improve product quality, and shorten release time from development to production.
Responsibilities
Actively Participate in all Agile Scrum ceremonies – PI Planning, Sprint Planning, Daily Standups, Defect Review, Sprint Demo, Retrospective
Actively participate in Backlog Refinement, story grooming, analyze and understand user story acceptance criteria
Develop and execute both Manual and Automation Test plan, Test Cases based on the user stories and ensure proper test coverage
Identify manual processes and implement intelligent automation solutions using AI/ML frameworks to optimize overall test preparation and execution efficiency, to reduce cycle time.
Perform in-sprint testing, service/API testing, Integration / E2E testing, Regression Final Build Certification and Release Day testing
Reviewing user interfaces for conformity and functionality
Working with software engineers to understand product architecture, integrations and features
Creating and maintaining Gold Standard Test Data to support test plans and test cases
Ability to identify patterns, anomalies, and inconsistencies within data, ensuring accuracy and quality.
Analyzing test results, being a vocal proponent for quality in every phase of the development process
Documenting, tracking bugs to closure and reports on Project status to stakeholders
Working in an Agile/Scrum environment to deliver high-quality software
Serves as SME for one or more functional areas, acts as a technology ambassador for automation and builds efficient solutions
Requirements
Minimum of 8 years of hands-on experience in software development in test automation, concurrent coding skills in one of the programming languages: Python (preferably) or Java
Minimum of 2 years of hands-on experience working with AWS services like S3, RDS, DynamoDB, Lambda, and exposure to Bedrock model integration or experience with other cloud vendors and AI platforms.
Proven hands-on expertise in analyzing and understanding data pipeline architectures and ETL workflows
Developed and executed test automation strategies using tools like Selenium and TestNG.
Hands-on experience with test processes, test methodologies, test strategy, test plan and test case design & execution
Technical Requirements
Solid experience in testing SQL procedures and the ability to understand/write complex SQL queries to perform data validation
Hands-on experience analyzing data, comparing with mapping documents, and debugging to identify the root cause
AI Tools / Models / Training Data Set exposure is a plus for adoption in testing methodologies
Hands-on experience with Manual and automation Testing for Batch Jobs, Data Feeds, API / Web services / Swagger.
Experience with CI/CD with Octopus/GitHub; and integrating AI-based quality gates and observability into CI/CD pipelines like GitHub Co-pilot
Envision opportunities and apply AI low code/ no code automation techniques to improve the test coverage
Experience with Jira or similar Agile process tools
Preferences
Financial Industry experience
Cloud certification(s) are a plus
Gen AI hands-on around Test preparation, data generation, and automation solutions
Ability to thrive in a fast-paced environment where resourcefulness, determination, and strong problem-solving skills are necessary for success
Positive attitude and ability to take ownership of releases/features/stories/tasks to deliver with quality
Bachelor’s degree in computer science or related field, plus 8+ years of IT experience, or a Master’s degree with 6+ years of IT experience
This role is a hybrid position and must report into an LPL primary office either in Austin, TX or Charlotte/Fort Mill, SC.
Pay Range $91,425-$152,375/year
EEO Statement Principals only. EOE
#J-18808-Ljbffr
You will work closely with product and engineering teams to understand features, develop and automate test cases, improve product quality, and shorten release time from development to production.
Responsibilities
Actively Participate in all Agile Scrum ceremonies – PI Planning, Sprint Planning, Daily Standups, Defect Review, Sprint Demo, Retrospective
Actively participate in Backlog Refinement, story grooming, analyze and understand user story acceptance criteria
Develop and execute both Manual and Automation Test plan, Test Cases based on the user stories and ensure proper test coverage
Identify manual processes and implement intelligent automation solutions using AI/ML frameworks to optimize overall test preparation and execution efficiency, to reduce cycle time.
Perform in-sprint testing, service/API testing, Integration / E2E testing, Regression Final Build Certification and Release Day testing
Reviewing user interfaces for conformity and functionality
Working with software engineers to understand product architecture, integrations and features
Creating and maintaining Gold Standard Test Data to support test plans and test cases
Ability to identify patterns, anomalies, and inconsistencies within data, ensuring accuracy and quality.
Analyzing test results, being a vocal proponent for quality in every phase of the development process
Documenting, tracking bugs to closure and reports on Project status to stakeholders
Working in an Agile/Scrum environment to deliver high-quality software
Serves as SME for one or more functional areas, acts as a technology ambassador for automation and builds efficient solutions
Requirements
Minimum of 8 years of hands-on experience in software development in test automation, concurrent coding skills in one of the programming languages: Python (preferably) or Java
Minimum of 2 years of hands-on experience working with AWS services like S3, RDS, DynamoDB, Lambda, and exposure to Bedrock model integration or experience with other cloud vendors and AI platforms.
Proven hands-on expertise in analyzing and understanding data pipeline architectures and ETL workflows
Developed and executed test automation strategies using tools like Selenium and TestNG.
Hands-on experience with test processes, test methodologies, test strategy, test plan and test case design & execution
Technical Requirements
Solid experience in testing SQL procedures and the ability to understand/write complex SQL queries to perform data validation
Hands-on experience analyzing data, comparing with mapping documents, and debugging to identify the root cause
AI Tools / Models / Training Data Set exposure is a plus for adoption in testing methodologies
Hands-on experience with Manual and automation Testing for Batch Jobs, Data Feeds, API / Web services / Swagger.
Experience with CI/CD with Octopus/GitHub; and integrating AI-based quality gates and observability into CI/CD pipelines like GitHub Co-pilot
Envision opportunities and apply AI low code/ no code automation techniques to improve the test coverage
Experience with Jira or similar Agile process tools
Preferences
Financial Industry experience
Cloud certification(s) are a plus
Gen AI hands-on around Test preparation, data generation, and automation solutions
Ability to thrive in a fast-paced environment where resourcefulness, determination, and strong problem-solving skills are necessary for success
Positive attitude and ability to take ownership of releases/features/stories/tasks to deliver with quality
Bachelor’s degree in computer science or related field, plus 8+ years of IT experience, or a Master’s degree with 6+ years of IT experience
This role is a hybrid position and must report into an LPL primary office either in Austin, TX or Charlotte/Fort Mill, SC.
Pay Range $91,425-$152,375/year
EEO Statement Principals only. EOE
#J-18808-Ljbffr