Officer- ETL Automation Tester - QA - C10 - Hybrid - Pune

As a Testing Analyst at Citi, you will apply specialized knowledge to monitor, assess, and analyze processes and data. Your responsibilities will include identifying policy gaps, formulating policies, interpreting data, and making recommendations. You will work with various data sources to build data pipelines, develop automated tests for quality control, and leverage AWS services for data processing and orchestration. Key Responsibilities: - Extract, clean, transform, and load data from different sources - Develop automated tests to ensure data accuracy and adherence to standards - Work with Hive, HDFS, and Oracle data sources - Utilize AWS services such as S3, Lambda, and Airflow - Create reusable frameworks for automation and testing - Participate in code reviews and maintain best practices in Spark and cloud-native development - Drive automation in the Data and Analytics Team - Design and develop integrated portals for user needs - Collaborate with the technology team to implement automation scripts/plans - Monitor code check-ins and maintain project repository - Work independently and collaboratively on various projects Qualifications: - 2-4 years of experience in automation testing across UI - Experience in Automation ETL Testing and SQL query testing - Hands-on experience with Selenium BDD Cucumber using Java, Python - Knowledge of developing and maintaining automation frameworks - Experience with BI reports automation, data analytics, and AI/ML solutions - Proficiency in Python for data analysis using Pandas, NumPy, etc. - Exposure to AI and ML solutions for automation - Experience with mobile testing and API testing - Strong knowledge of relational databases and Bigdata systems - Proficiency in Oracle SQL, HiveQL, ETL/Data Testing, and CI/CD tools - Hands-on experience with ETL automation and validation frameworks - Understanding of AWS services like S3, Lambda, EKS, Airflow - Strong problem-solving and debugging skills - Excellent communication and collaboration abilities If you are passionate about technology, automation, and data analytics and possess the mentioned skills and experience, we encourage you to apply for the Officer- ETL Automation Tester position at Citi. Shape your future with us and be part of a dynamic team driving innovation in the banking industry.,