OnBenchMark Logo

Siddhartha (RID : a49xldlpmgfw)

designation   Software Engineer

location   Location : Jaipur, India

experience   Experience : 4 Year

rate   Rate: $20 / Hourly

Availability   Availability : 1 Week

Work From   Work From : Any

designation   Category : Information Technology & Services

Shortlisted : 1
Total Views : 176
Key Skills
Oracle SQL PLSQL Developer Database testing UNIX

Project Name: Process Automation

Technology & Tool: Oracle SQL, PLSQL Developer, Database testing, UNIX, Dats.
Detail Project Overview and Workflow:

Lending institutions across India contributes data to CIC on regular intervals. There can beinstances where a data is incorrect or incomplete and it is further required to be modified on an urgent basis. In order to correct an incorrect record, lending institution share corrected information with the CIC separately. The data correction file may contain one to many records. Data correction files shared can be broadly categorized bureau wise in three categories, that is MFI, Consumer & Commercial. Bureau wise files shared are mostly similar with some variation from institution to institution. This activity is presently performed manually. On the shared files actions are identified at record level and accordingly corrections are performed. We automate this process of data correction to reduce manual intervention as much as possible in an efficient manner.

Task Handled:
 Involved in creating Tables, modification, mapping.
 Involved in writing SQL queries for accessing back-end of application.
 Participated in creating tables, views, indexes, triggers, functions, procedures, cursors and packages.
 Create the validation for data modification and mapping.
 Handling the validation and Modification rules through different queries.
 Supported all operation activities of oracle PL/SQL
 Filtering data from various stores with different formats and reformat the data according to requirements.
 Involved in importing source/target tables from the respective databases and created reusable transformations, mapplets and mappings using designer.
 Analyzed logs generated reports and identified failures.
 Identified bug trends and participated in general QA initiatives.
 Maintain a consistent look and feel throughout all modules.
 Prepare Traceability matrix to match use case and test case.
 Responsible for performance tuning activities in the project.

Project Name: Data Insights ( Data Engineer)
Technology & Tool: Oracle SQL, PLSQL Developer, Database testing, UNIX, Dats.
Detail Project Overview and Workflow:
Performs data analysis based on specific requirements developed by business partners, stakeholders, or direct manager. Using logical or statistical methodologies, expresses results to stakeholders. Analyze the received data verifies the accuracy and consistency of the data and interacting with client for the incorrect data, rejections, validations etc. Involved in data quality to data validations, data extraction, count extraction according to rules, data cleansing and rules creation and implementation.

Matching Resources
My Project History & Feedbacks
Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon

stuff goes in here!