Senior Automation Specialist -Python/SQL

Job Description

Job Description About the Company/Team Oracle FSGIU?s Finergy division focuses exclusively on the Banking, Financial Services, and Insurance (BFSI) sector, delivering deep domain expertise to address complex financial and operational needs. The team specializes in accelerated implementation methodologies, enabling fast deployment of multi-channel solutions with minimal IT intervention. With a strong foundation in personalization, analytics, and integrated delivery platforms, Finergy supports end-to-end banking services?trade, treasury, cash management, and more. The team also offers comprehensive consulting services from strategy to execution, ensuring technology aligns seamlessly with business goals. This role joins a high-performing team operating in a fast-paced, agile environment, contributing to high-impact BFSI solutions used by customers worldwide. Job Summary The Automation Test Engineer will play a key role in designing, developing, and executing automation test suites to support agile product development. This role requires strong technical capability in Python and SQL, solid understanding of end-to-end testing cycles, and the ability to work independently while collaborating closely with development and QA teams. The ideal candidate thrives in complex business environments, brings strong analytical thinking, and can translate business scenarios into robust test cases and scripts. Responsibilities Key Responsibilities Work independently with minimal supervision to plan and execute automation testing activities. Analyze and understand system specifications, business processes, and integration points. Estimate testing efforts and resource needs to support sprint planning and prioritization. Collaborate with QA engineers to build comprehensive automation scenarios and test plans. Develop and execute automated test cases; analyze and document results. Create detailed logs and documentation for test phases, results, and defects. Identify, report, and track defects using tools such as JIRA; collaborate with development teams for resolution. Support development teams in troubleshooting and root-cause analysis. Plan and execute regression and post-release testing, ensuring product quality and stability. Qualifications & Skills Mandatory 5+ years of hands-on experience in automation testing. Strong proficiency in Python for test automation. Expertise in writing complex SQL queries. Solid experience with API testing. Comprehensive understanding of the test cycle process and software QA methodologies. Experience with web application testing and Continuous Integration processes. Familiarity with version control and test ecosystem tools, including GIT, Jenkins, and JIRA. Good-to-Have Experience working in agile environments within BFSI domain projects. Exposure to test management tools and automation frameworks. Understanding of CI/CD pipelines and DevOps practices. Ability to analyze complex business logic and translate it into effective automation coverage. Self-Assessment Questions Candidates can use the following to evaluate their fit for the role: Do I have at least 5 years of hands-on automation testing experience, particularly using Python? Can I independently write and optimize complex SQL queries to validate test scenarios and data conditions? Am I comfortable performing API testing and validating backend integrations? Do I understand the end-to-end test cycle, including planning, execution, defect reporting, and regression testing? Am I proficient in using tools like GIT, Jenkins, and JIRA within a CI/CD or agile development environment? Qualifications Career Level - IC2 About Us As a world leader in cloud solutions, Oracle uses tomorrow?s technology to tackle today?s challenges. We?ve partnered with industry-leaders in almost every sector?and continue to thrive after 40+ years of change by operating with integrity. We know that true innovation starts when everyone is empowered to contribute. That?s why we?re committed to growing an inclusive workforce that promotes opportunities for all. Oracle careers open the door to global opportunities where work-life balance flourishes. We offer competitive benefits based on parity and consistency and support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs. We?re committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by emailing [email protected] or by calling +1 888 404 2494 in the United States. Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans? status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.