Data testing - automation tester - C11 - PUNE

The IT Quality Intmd Analyst is a developing professional role. Deals with most problems independently and has some latitude to solve complex problems. Integrates in-depth specialty area knowledge with a solid understanding of industry standards and practices. Good understanding of how the team and area integrate with others in accomplishing the objectives of the subfunction/ job family. Applies analytical thinking and knowledge of data analysis tools and methodologies. Requires attention to detail when making judgments and recommendations based on the analysis of factual information. Typically deals with variable issues with potentially broader business impact. Applies professional judgment when interpreting data and results. Breaks down information in a systematic and communicable manner. Developed communication and diplomacy skills are required in order to exchange potentially complex/sensitive information. Moderate but direct impact through close contact with the businesses' core activities. Quality and timeliness of service provided will affect the effectiveness of own team and other closely related teams.

Candidate is expected to

Build Data Pipelines: Create programs using PySpark (a powerful data processing tool) to extract data from various sources (like databases and data lakes), clean and transform it, and load it into target systems

Testing and Validation: Develop automated tests to ensure the data pipelines are working correctly and the data is accurate. This is like quality control, making sure everything meets the bank's standards

Work with Hive, HDFS, and Oracle data sources to extract, transform, and load large-scale datasets

Leverage AWS services such as S3, Lambda, and Airflow for data ingestion, event-driven processing, and orchestration

Create reusable frameworks, libraries, and templates to accelerate automation and testing of ETL jobs

Participate in code reviews, CI/CD pipelines, and maintain best practices in Spark and cloud-native development

Ensures tooling can be run in CICD providing real-time on demand test execution shortening the feedback loop to fully support Handsfree execution

Regression , Integration, Sanity testing, Regression automated suites, reports issues – provide solutions and ensures timely completion

               Own and drive automation in Data and Analytics Team to achieve 90% automation in Data, ETL space.

               Design and develop integrated portal to consolidate utilities and cater to user needs.

               Supports initiatives related to automation on Data & Analytics testing requirements for process and product rollout into production.

               Specialists who can work with technology team to design and implement appropriate automation scripts/plans for an application testing, meeting required KPI and automation effectiveness.

               Ensures new utilities are documented and transitioned to testers for execution and supports for troubleshooting in case required.

               Monitors and reviews code check-ins from peers and helps maintain project repository.

               Ability to work independently as well as collaborate within groups on various projects assigned.

               Ability to work in a fast-paced, dynamic environment and manage multiple priorities effectively.

               Experience and understanding of Wealth domain specifically in private bank(banking) , lending services and related Tech applications.

              Supports and contributes to automated test data generation and sufficiency.                                                  

Successful candidate ideally would have following skills and exposure:

           4-8 years of experience on automation testing across UI, Data analytics and BI reports in the Financial Service industry

           Hands on experience on Selenium BDD Cucumber using Java, Python

          Extensive knowledge on developing and maintaining automation frameworks, AI/ ML related solutions

          Experience on automating BI reports e.g., Tableau dashboards and views validation.

          Hands on experience in Python for developing utilities for Data Analysis using Pandas, NumPy etc.

         Exposure and some experience on AI related solutions, ML which can help automate faster.

         Experience with mobile testing using perfecto, API Testing-SoapUI, Postman/Rest Assured will be added advantage.

         Detailed knowledge data flows in relational database and Bigdata systems

         Strong knowledge of Oracle SQL and HiveQL and understanding of ETL/Data Testing.

         Experience using Bitbucket or equivalent code version control tool.

         Experience with CI/CD tools like Jenkins.

         Detailed knowledge data flows in relational database and Bigdata (Familiarity with Hadoop (a platform for processing massive datasets)).

         Strong experience with PySpark for batch and stream processing deploying PySpark workloads to AWS EKS (Kubernetes)

         Proficiency in working on Cloudera Hadoop ecosystem (HDFS, Hive, YARN)

         Hands-on experience with ETL automation and validation framework.

         Solid understanding of AWS services like S3, Lambda, EKS, Airflow, and IAM

         Scripting knowledge in Bash, Python, and YAML

         Strong problem-solving and debugging skills

         Excellent communication and collaboration abilities to lead and mentor a large techno-functional team across different geographical locations

          Strong Acumen and presentation skills

         Able to work in an Agile environment and deliver results independently

Education:

• Bachelor’s/University degree or equivalent experience