Staff 4

EY

1. Review and analyze the functional requirements, mapping documents, problem solving and troubleshooting.
2. Developed ETL Programs using Informatica to implement the business requirements.
3. Created UNIX scripts to tune the ETL flow of the Informatica workflows.
4. Parameterized for defining mapping variables, Workflow variables, FTP Connections.
5. Used Debugger in identifying bugs in existing mapping by analyzing the data flow, evaluating transformations.
6. Created and Ran the Jobs/Workflow for ETL process.
7. Prepared and ran SQL queries in Teradata, Azure Data Bricks.
8. Verifying the data in target database after ETL process.
9. Performed column data mapping between source & target database.
10. Analyzing and fixed Defects JIRA.
11. Interactions with BA & Dev teams to resolve the issues.
12. Identifying sensitive fields (Customer personal information) in database.

Senior Software Engineer

Cigniti Technologies Pvt Ltd

1. Elicit requirements using interviews, document analysis, business process descriptions, use
2. cases/user stories, scenarios, and workflow analysis.
3. Identifying sensitive fields (Customer personal information) in database.
4. Creating Database Connection, Project in TDM for Database which needs to Obfuscate.
5. Creating Obfuscate Rules, Data Domains, Policies like PCI, PII, etc. in TDM for database columns.
6. Creating a plan for the rules applied columns and generate Workflow, Execute plan.
7. Validating the obfuscated data w.r.t original data in Database and consistency between them.
8. Troubleshooting the errors from TDM or Informatica while obfuscating data.
9. Creating Test plan and Tests in Data Validation Option for Obfuscated data w.r.t backup data.
10. Running Test plans, Generating reports in DVO.
11. Creating Data Domains and Classification Policies like PCI, PII, etc. in Secure@Source for database columns.
12. Creating Data Stores for databases in Secure@Source/DPM.
13. Creating Scans by selecting those Data Stores for Meta Data and also Meta Data with Data.
14. Run the Scans and find the Sensitive Fields.
15. Validate sensitive fields in backend by running SQL queries in MS SQL
16. Export all Scans/Reports into local machines and place in SharePoint.
17. Reporting Daily, Weekly and Monthly status reports.
18. Prepared Data Quality, Operational Metrics, Also prepared project estimations for the team.
19. Handled PCI of the project as a POC using Selenium JAVA.
20. Handled a team of 2, and mentoring them to execute the tasks and explain the business functionalities
21. Run UFT script to update the source data to give test data requested by sub teams in Synovus
22. Run Web services script in SOAP to create test data in source system for sub teams in Synovus
23. Create and edit Workflow mappings in Informatica power center to pull matched records from source system which are request by sub teams.
24. Creating Customers, Accounts, and modifications of customer details in FIS application supply sub teams in Synovus.

Test Engineer

eMids Technologies Pvt Ltd

1. Involved in functional study of the application.
2. Building E2E ETL Testing scenarios by developing Data preparation and SQL Queries
3. Generating Test data by using Java script
4. Created test data to execute the scenarios in a Controlled environment and UAT
5. Executed SQL queries to validate the results
6. ported and tracked defects. Verified changes and closed bugs in HPQC Application Lifecycle Management.
7. Upload and follow the process of Project Management Tool JIRA
8. Handling a team of 3, and mentoring them to execute the test cases and explain the business functionalities
9. Developed and maintained ETL Testing test cases using Oracle11g SQL standard
10. Participated in the daily status calls to address issues.
11. Designed and developed reconciliation report between legacy database to XML DB
12. Interactions with BA & Dev teams to resolve the issues.

Test Engineer

Cenduit(India) Services Pvt Ltd

1. Involved in functional study of the application.
2. Running the Jobs/Workflow for ETL process.
3. Prepared and ran SQL queries.
4. Designed & executed test cases.
5. Verifying the data in target database after ETL process.
6. Performed column data mapping between source & target database.
7. Prepared test data for testing.
8. Defect Analyzing and Reporting in QC.
9. Interactions with BA & Dev teams to resolve the issues.
10. Involved in the Report testing.
11. Reporting daily testing status report.

Process Analyst

Fidelity National Financial India Pvt Ltd

1. Involved in understanding of the Software Requirement Specification
2. Running the jobs for ETL process.
3. Verified the ETL mapping and data between Source and Target database.
4. Interactions with BA & Dev teams to resolve the issues.
5. Reporting daily testing status report.
6. Developed, Reviewed & Executed Test Scripts/Test cases and Designed test data.
7. Identified Test Scripts for Regression testing.
8. Defect Analyzing and Reporting in QC.

Jawarharlal Nehru Technological University

Master Of Computer Applications