Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic
ARPITA JAIN

ARPITA JAIN

Bengaluru

Summary

Qualified Business Analyst with extensive background in Data Analytics and testing. Experience in Telecom and Banking domain. Develop and execute test plans and automated scripts to validate software functionality against requirements and specifications.

Overview

9
9
years of professional experience

Work History

Financial Systems Analyst II

American Express
01.2024 - Current
  • Responsible for assessing the data quality and integrity of regulatory filings, detecting issues and mitigating the risk of reporting errors
  • Supporting migration of bigdata system to Lumi (GCP)
  • Verify accuracy and compliance of all FED regulatory reports such as FRY9LP, FRY9C, Call Report etc before submission
  • Testing And analysis of data on Tableau dashboards
  • Responsible for Designing, developing, and implementing automated testing frameworks and scripts for Big Data and SQL systems.
  • Create and maintain test cases, test plans, and test scripts for Big Data and SQL environments.
  • Perform data quality assessments and audits, identifying and resolving data quality issues.
  • Collaborate with data engineers and developers to ensure data quality standards are met.
  • Develop and execute automated and manual test scripts, maintenance routines.

Technical Lead - Quality

Mobileum India pvt ltd
05.2021 - 11.2023
  • Troubleshooting of ETL jobs and addressing production issue.
  • Performing negative testing, Regression testing, performance testing, functional testing, UI testing to ensure quality of the code deployed.
  • Work with container orchestration tools (e.g., Kubernetes) to streamline application deployment, scaling, and monitoring.
  • Collaborate with development, testing, and DevOps teams to define and implement a comprehensive quality assurance strategy.
  • Setup kubernetes/Cloudera/Openshift environment for testing.
  • Data Visualisation - Cluster monitoring using Prometheus, Grafana and
    Kubernetes dashboards.
  • Deployment and testing of caddy, ignite, hivemetastore, keycloak, nattrmon, Prometheus, rabbitmq, sparkjobmanager, trinodb helm charts.
  • Defect Management, including defect creation, test case/script updates, and interaction with data engineers for clarification and issue resolution.
  • Partner with the Product Owners (to provide feedback and suggestions for improvement of requirements), Developers (to ensure the delivery of a high-quality product).

DWH/BI Test Engineer

Amdocs
08.2019 - 05.2021
  • Carried out automated testing using shell scripts to ensure the quality of ETL transformations
  • Aligning with vendors to gather their requirements and transfer interfaces with required data.
  • Contributing in E2E and UAT phases of BI playing multiple roles ranging from maintaining BI Infra ,executing data loads and functional data validation.
  • Conducted in-depth examination of data to determine necessary test requisites.
  • Ensured proper validation of designed test scenarios after code execution.
  • Code reviews and testing with developers and Client.
  • Performing negative testing to ensure quality of the code deployed.
  • Writing complex SQL queries to check kpis, aggregate data.
  • Performing RI checks ,duplicate checks ,BVA checks on data loaded.
  • Performing Regression ,performance and functional testing.

Systems Engineer

Big Data AI-Datalab, Deutsche Bank, Tata Consultancy Services Ltd
06.2016 - 08.2019
  • Preparing test cases and executing them on HP ALM.
  • Regression/Functional/QA testing of data.
  • Testing of RDBMS,JSON, XML,SKYPE,E-MAIL feeds.(big data).
  • Providing QA sign off to various development teams after testing of new changes.
  • Executing jobs through Control M on daily basis .Capturing test evidences for each feed.
  • Copy the data from lake area if not available in lower environments.
  • Performing negative testing to ensure quality of the code deployed.
  • Testing of data in big data/Hadoop environment.(Hive/Impala database).
  • Use of SQL oracle developer to run and create queries.
  • Create and execute automated test scripts and ensure they are integrated into the CI/CD pipeline.
  • Running daily jobs to check UAT/SIT environment status.
  • Testing of data in big data/Hadoop environment.(Hive/Impala database).
  • Use of SQL oracle developer to run and create queries.
  • Monitoring of production jobs in CONTROL-M.

Education

BACHELOR OF ENGINEERING - Information Technology

JABALPUR ENGINEERING COLLEGE
05.2016

HSC -

CBSE
05.2012

SSC -

CBSE
05.2010

Skills

  • Testing Technologies: ETL testing, Big data testing, Functional Testing, Regression Testing, Performance Testing, Dashboard testing, UI testing, Smoke Tesing, Sanity Testing
  • Tools: JIRA, HP ALM, CONTROL-M, Putty, Perforce, Oracle data integrator, Winscp, Microsoft excel, Confluence, Hue, oozie, OFSAA, Airflow, Rally, GitHub, Airflow, Jenkins
  • Languages: SQL, HQL
  • Databases: Oracle 10g/11g, Hive, Teradata, Presto, Trinodb, Postgres, Couchbase, Apache Ignite
  • Operation System: Unix, Windows, Ubuntu, RHEL
  • Framework/Platform: Hadoop, Kubernetes, Docker, AWS, Redhat Openshift, Spark, Podman
  • Messaging: kafka, Rabbit MQ
  • Scripting: Shell scripting/Python
  • Storage: AWS S3, GCP
  • Data Visualisation: Grafana

Languages

English
Proficient
C2
Hindi
Proficient
C2

Timeline

Financial Systems Analyst II

American Express
01.2024 - Current

Technical Lead - Quality

Mobileum India pvt ltd
05.2021 - 11.2023

DWH/BI Test Engineer

Amdocs
08.2019 - 05.2021

Systems Engineer

Big Data AI-Datalab, Deutsche Bank, Tata Consultancy Services Ltd
06.2016 - 08.2019

HSC -

CBSE

SSC -

CBSE

BACHELOR OF ENGINEERING - Information Technology

JABALPUR ENGINEERING COLLEGE

Similar Profiles

CREATE PROFILE
ARPITA JAIN