Summary
Overview
Work History
Education
Skills
Certification
Awards
Professional Highlights
Languages
Accomplishments
References
Timeline
Generic

Anuj Jain

Pune

Summary

QA Lead with extensive experience in ETL and DWH testing at IRIS SOFTWARE. Expertise in SQL and Informatica, focusing on data integrity validation and automation. Developed effective test strategies that enhance collaboration and ensure high-quality deliverables. Proven track record in driving efficiency in data integration projects.

Overview

12
12
years of professional experience
1
1
Certification

Work History

QA Lead

IRIS SOFTWARE
Pune
06.2022 - Current
  • Accumulated over four years of ETL and data integration experience focusing on testing and script development using Informatica PowerCenter.
  • Executed test data management, analysis, design, development, and implementation processes effectively.
  • Developed complex SQL queries to assess technical requirements and validate data transformations.
  • Extracted and loaded data from Oracle and flat files into Oracle DWH using ETL processes.
  • Debugged Informatica mappings and validated data integrity in target tables post-load.
  • Created and monitored workflows utilizing Workflow Manager and Workflow Monitor for optimized operations.
  • Implemented various transformations, including XML parser, XML generator, data masking, lookup, filter, and router transformations.
  • Designed ETL processes for loading data from diverse source systems like flat files, SQL Server, Teradata, and Oracle.

Senior Specialist

LARSEN & TOUBRO INFOTECH
Pune
11.2017 - 05.2022
  • Accumulated over four years of ETL and data integration experience with a focus on testing and script development using Informatica PowerCenter.
  • Executed data management, analysis, design, development, and implementation processes efficiently.
  • Developed complex SQL queries to validate data transformations and assess technical requirements.
  • Extracted and loaded data from Oracle and flat files into Oracle DWH utilizing ETL processes.
  • Debugged Informatica mappings and ensured data integrity in target tables after loading.
  • Created and monitored workflows through Workflow Manager and Workflow Monitor for enhanced operations.
  • Implemented various transformations such as XML parser, XML generator, data masking, lookup, filter, and router transformations.
  • Designed ETL processes for loading data from multiple source systems including flat files, SQL Server, Teradata, and Oracle.

Senior Associate

SYNECHRON TECHNOLOGY PVT. LTD.
Pune
02.2017 - 12.2017
  • Analyzed business requirements to prepare comprehensive test strategies and approaches.
  • Collaborated with developers and team leads to create detailed test plans, scenarios, and scripts throughout testing cycles.
  • Constructed complex SQL queries to validate technical implementations and data transformations.
  • Executed, reviewed, and developed test scripts to ensure coverage of all functionalities.
  • Reported defects in JIRA, managed follow-ups, retesting, and ensured closure.
  • Streamlined testing efforts through automation using Excel VBA.
  • Conducted data reconciliation with SQL scripts to verify data integrity.
  • Communicated testing activities and findings effectively in both oral and written formats.

Associate

COGNIZANT TECHNOLOGY SOLUTIONS
Pune
05.2013 - 01.2017
  • Analyzed business requirements to prepare comprehensive test approach and strategy documents.
  • Collaborated with developers and team lead to create detailed test plans, scenarios, and scripts.
  • Constructed complex SQL queries to validate technical implementations and data transformations.
  • Developed, reviewed, and executed test scripts for effective quality assurance.
  • Tested Business Objects reports utilizing Excel and SQL for accurate data validation.
  • Reported defects in SharePoint, ensuring thorough follow-up, retesting, and resolution.
  • Reduced testing efforts through automation using Excel VBA techniques.
  • Executed data reconciliation processes via SQL scripts for accuracy verification.

Education

Information Technology

ORIENTAL INSTITUTE OF SCIENCE & TECHNOLOGY (RGTU BHOPAL)
Bhopal
06-2012

HSC -

S.K.R HIGHER SECONDARY SCHOOL (M.P BOARD)
01.2007

SSC -

S.K.R HIGHER SECONDARY SCHOOL (M.P BOARD)
01.2005

Skills

  • DWH Testing
  • ETL /BI Testing
  • SQL
  • Unix
  • PYTHON
  • SPARK
  • PL/SQL
  • VBA
  • Informatica
  • Teradata
  • Business Objects
  • Cognos
  • JIRA
  • Mainframe

Certification

  • Jun-2024, AWS Solution Architect-Associate
  • Dec-2015, Oracle 11g SQL Fundamental Exam, Oracle
  • DEC-2014, ISTQB Foundation Level, Software Testing Board, New Delhi

Awards

  • Received Rising Star from Cognizant for good performance as fresher.
  • Received Feather in Cap Award for Exception performance.
  • Appreciations from client for timely execution and delivery.

Professional Highlights

  • 10 years of experience in Data warehouse testing (ETL and Reporting) in Life-Sciences and Banking domain.
  • 2 years of experience in Software analysis, ETL Informatica TDM development, Implementation of business applications for Insurance domain.
  • Strong Background in Informatica, SQL, UNIX, Mainframe, Capital Market and Excel VBA writing.
  • Strong in data warehousing concepts, dimension modeling.
  • Experience in doing the Environment setup for UAT Users using UNIX.
  • Experience working with huge volume of data, analyzing data quality using SQL Manually.
  • Experience in developing validation plans, Test strategy documents.
  • Experience in complete life-cycle of test case design, test execution and defect management.
  • Able to automate ETL testing using Excel VBA programming.
  • Dynamic team player who is consistently motivated towards success and completion of project.
  • A quick learner who can swiftly adapt to new challenges.

Languages

Hindi
First Language
English
Proficient (C2)
C2

Accomplishments

  • Honored with the highest accolade award from IRIS Software for creating the RTM automation, which will create RTM in a single click and save a lot of manual effort and savings

References

References available upon request.

Timeline

QA Lead

IRIS SOFTWARE
06.2022 - Current

Senior Specialist

LARSEN & TOUBRO INFOTECH
11.2017 - 05.2022

Senior Associate

SYNECHRON TECHNOLOGY PVT. LTD.
02.2017 - 12.2017

Associate

COGNIZANT TECHNOLOGY SOLUTIONS
05.2013 - 01.2017

Information Technology

ORIENTAL INSTITUTE OF SCIENCE & TECHNOLOGY (RGTU BHOPAL)

HSC -

S.K.R HIGHER SECONDARY SCHOOL (M.P BOARD)

SSC -

S.K.R HIGHER SECONDARY SCHOOL (M.P BOARD)

Similar Profiles

CREATE PROFILE
Anuj Jain