Sr Database Tester & QE Engineer Job at LPL Financial in Fort Mill

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