# Prerana Jain

Prerana Jain is a remote worker on Himalayas, Test Specialist – Technical Lead at Coforge Ltd, based in India.

Source: https://himalayas.app/@preranajain

```text
ETL Test Specialist and Technical Lead at Coforge, validating migrations from OmniPro to Infor M3 across data and API projects.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 16600k+ INR |
| Job categories | ETL Tester, ETL Developer, Data Engineer, Database Tester, BI Tester |
| Skills | ETL Testing, Data Warehouse Testing, Data Migration Testing, Database Testing, API Testing, BI Report Testing, Functional Testing, SQL, Data Validation, Test Strategy, Test Planning, Test Case Design, Defect Tracking, Agile, Waterfall |

## About

```text
At Coforge, I validated end-to-end data migration and ETL from OmniPro to Infor M3 across UAT, QA, pre-production, and production environments. I also checked data quality and reconciliation across warehouse data and tested APIs and interfaces.

At LTIMindtree, I tested Snowflake data and finance dashboards in Power BI and Tableau for the ServiceNow project. On the CBDT project, I led a QA team of 3+ members and tested data-quality rules and BI reports.

For MoSPI’s NAD units, I created complex MS SQL stored procedures and supported data migration and data mart preparation. I’ve also led QA teams, mentored teammates, and worked across ETL, database, BI report, functional, and mobile testing.
```

## Experience

### Test Specialist – Technical Lead

[Coforge Ltd](https://himalayas.app/companies/coforge-marketing). Nov 2024 - Jul 2026

```text
Executed end-to-end data migration and ETL validation from legacy system to ERP, performed data quality checks and reconciliation, and defined validation strategy and test approach.
```

Skills: ETL-Testing, Data-Migration, API-Testing, BI-Report-Testing, Infor-M3, Jira, Azure-Data-Factory, Power-BI, SQL, Snowflake

### Individual Contributor

[LTIMindtree](https://himalayas.app/companies/ltimindtree). May 2019 - Nov 2024

```text
Delivered on an average a Sprint in 3 weeks, prepared test cases using Source to Target Mapping documents, and performed data validation at Snowflake.
```

Skills: ETL-Testing, Database-Testing, BI-Report-Testing, Functional-Testing, Snowflake, Power-BI, Tableau, Jira

### Specialist – Data Engineering

[LTIMindtree](https://himalayas.app/companies/ltimindtree). May 2019 - Nov 2024

```text
Created complex MS SQL Stored procedures, involved in data migration and preparation of DataMart structures, and led QA team of 5+ members.
```

Skills: ETL-Development, DWH, Data-Migration-Testing, Functional-Testing, MS-SQL-Server, Jira

### Consultant/Module Lead

[LTIMindtree](https://himalayas.app/companies/ltimindtree). May 2019 - Nov 2024

```text
Led QA team of 3+ members, prepared test cases using Source to Target Mapping documents, and performed data validation at Teradata and Snowflake.
```

Skills: ETL-Testing, DWH, BI-Report-Testing, Functional-Testing, Jira, Teradata, SAS-VA, Snowflake

### QA Tester

[Aon Hewitt](https://himalayas.app/companies/aon). May 2017 - May 2019

```text
Analyzed user requirements, created test scenarios and test cases, and performed database testing using SQL.
```

Skills: Manual-Testing, Database-Testing, TFS, MTM, MS-SQL-Server

### QA Engineer

ImpactQA. Nov 2015 - Feb 2017

```text
Gathered user requirements, designed test plans and test scenarios, and performed end-to-end testing through mobile devices on different platforms.
```

Skills: Functional-Testing, Mobile-Testing, Database-Testing, Jira

### Test Engineer

KPIT. Nov 2014 - Aug 2015

```text
Provided end to end functionality flow of the product during customer demos, and carried out smoke, functional, system, regression, and user acceptance testing.
```

Skills: Functional-Testing, System-Testing, Regression-Testing, User-Acceptance-Testing, SQL, Redmine

### Test Engineer

[Target](https://himalayas.app/companies/target). Aug 2011 - Dec 2012

```text
Provided post production support and performed E2E testing including system acceptance, system integration, and user acceptance testing.
```

Skills: Functional-Testing, Database-Testing, Mobile-Testing, Quality-Centers

## Education

### Dayananda Sagar College of Engineering

Bachelor of Engineering, Engineering. Grade: 70%

```text
Completed Bachelor of Engineering with 70% from Dayananda Sagar College of Engineering, affiliated to VTU, Bangalore.
```

### Shri Bhagwan Mahaveer Jain College

Pre-University, Pre-University. Grade: 82%

```text
Completed pre-university education with 82% from Shri Bhagwan Mahaveer Jain College, Bangalore.
```

### The New Cambridge High School

Secondary School Certificate, Secondary Education. Grade: 91.2%

```text
Completed secondary education with 91.2% from The New Cambridge High School, Bangalore.
```

## Tech stack

- Snowflake
- Tableau
- MySQL
- Jira
- Bugzilla
- Python
- Redmine
- SQL
- Azure Blob Storage
- Power BI

To contact Prerana, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [MANISH PANDEY](https://himalayas.app/@manishpandey): QA Engineer, Onepoint IT Consulting Pvt Ltd.
- [A A](https://himalayas.app/@aa07): Senior Software Engineer, Cognizant Technology Solutions
- [varun Tulasigeri](https://himalayas.app/@varuntulasigeri): Associate Consultant/B1, Capgemini Technology Services India Ltd
- [DEBASHIS SAHOO](https://himalayas.app/@debashissahoo): ETL Testing and Data Analyst, Tata Consultancy Services
- [Nishant Pant](https://himalayas.app/@nishantpant): Senior Software Consultant (Test Lead / QA Strategist), Cognizant
- [Umesh R Gowda](https://himalayas.app/@umeshrgowda): Senior Specialist, Data Engineering, LTM
- [Satish N](https://himalayas.app/@satishn): Data Quality Analyst (ETL QA Lead), ACL Digital
- [bharathsokkondla User](https://himalayas.app/@bharathsokkondlauser): Senior Software Engineer, Wipro
- [Ravi Kiran Gottumukkala](https://himalayas.app/@ravikirangottumukkal): Test Lead QA, PWC
- [Meena Jose](https://himalayas.app/@meenajose): Technical Scrum Master, Wipro
