Automation Test Engineer + ETL

Job Description

Responsibilities: Maintain and adopt Agile best practices and lifecycles for process workflows (e. g. , Kanban, CI/CD). Collaborate with business users and analysts to refine and understand both functional and non-functional requirements during SIT & UAT stages. Develop automated test scripts to validate functional and technical requirements in data processing pipeline and perform data quality checks. Collaborate with data analysts in profiling data and monitoring data trends. Collaborate with Developers/DevOps Engineers on code management, peer review, and continuous integrated testing in CI/CD pipelines. Assure quality at different phases of SDLC by adhering to processes and strategies defined by Eastspring IT. Execute manual/automated/exploratory tests and provide QA sign-off to business users for releases. Maintain test process, design, and execution artifacts in test management system, complying with audit regulations. Prepare testing traceability reports and other testing metrics. Qualifications / Experience: Recognized degree or higher in Computer Science or related Engineering fields. At least 8 years of experience in Test Automation, using test frameworks for Database (ETL Testing) and Data analytical testing. Working knowledge of testing Data management platform tools similar to Golden Source . Sound knowledge in Java programming, SQL queries, and Cucumber (Java) testing framework. Good knowledge in testing scheduling/orchestration tools (e. g. , Control-M, Azure Data Factory). Working knowledge of relational databases and comfortable with testing SQL jobs and stored procedures with awareness of data security. Basic understanding of data quality, profiling, and analytics concepts. Working experience with test management tools such as Jira with Xray/Zephyr. Working knowledge of tools such as Bitbucket, Jenkins, Confluence, and familiar with Git branching model. Working experience in Agile projects, Behavior Driven Development (BDD) approach to software development and testing. Good to have basic programming knowledge in Python. Good to have knowledge of Azure cloud platform. Good to have working experience in the Investment Bank or Asset Management industry. Other Traits: Positive attitude and collaborative mindset. Willing to work across projects and perform manual/automation/exploratory testing. Highly motivated to stay updated with the latest developments in technology and acquire deep technical knowledge and skills. Excellent communication, presentation, and interpersonal skills. Java, Seleinum, Testing, Sql, Etl