Keywords
Extract Transform Load (ETL)
Data Warehousing
Unix Shell
JIRA
Unit Testing
CA Workload Automation Ae
COBOL (Programming Language)
Databases
Data Visualization
Debugging
Skills
Autosys, Cobol, Control-M, Data Visualization, Data warehousing, data warehouse, database, ETL, extract, transform, and load, data loading, file transfer, Informatica PowerCenter, Jira, job scheduler, oracle, OBIEE, Oracle database, PL-SQL, Performance Tuning, SQL, debugger, Toad, Unit test, Unix shell scripts, Unix Shell Scripting
Project history
02/2022
-
10/2022
Assistant Consultant
Tata Consultancy Services Ltd
Tata Consultancy Services Ltd, Chennai
* Extensively used Informatica to extract, transform, and load
data from various source systems into the target database.
* Implemented Change Data Captures techniques.
* Implemented slowly changing dimensions according to the
requirement.
* Prepared and executed Unit test scripts for the developed
mappings.
* Extensively used Informatica to extract, transform, and load
data from various source systems into the target database.
* Implemented Change Data Captures techniques.
* Implemented slowly changing dimensions according to the
requirement.
* Prepared and executed Unit test scripts for the developed
mappings.
09/2018
-
01/2022
Data Visualization engineer
Cittabase Solutions Pvt Ltd
Cittabase Solutions Pvt Ltd, Singapore
* Used Informatica power exchange and created data capture
for dumping data from Cobol copybooks to oracle.
* Developed mappings involving constraint-based load ordering.
* Performance tuned the mappings.
* Used debugger for identifying errors and resolved.
* Worked in Unix shell scripts for data handling, file transfer.
* Used Informatica power exchange and created data capture
for dumping data from Cobol copybooks to oracle.
* Developed mappings involving constraint-based load ordering.
* Performance tuned the mappings.
* Used debugger for identifying errors and resolved.
* Worked in Unix shell scripts for data handling, file transfer.
11/2013
-
08/2018
Software engineer
Brain box technologies
Brain box technologies, Chennai
* Developed various kinds of mappings according to ETL
specification.
* Implemented slowly changing dimensions according to the
requirement.
* Developed re-usable transformations, mapplets to use them for
data loading to data warehouse.
* Developed complex mappings by handling complex logic using
an expression transformation.
* Developed various kinds of mappings according to ETL
specification.
* Implemented slowly changing dimensions according to the
requirement.
* Developed re-usable transformations, mapplets to use them for
data loading to data warehouse.
* Developed complex mappings by handling complex logic using
an expression transformation.
Local Availability
Available worldwide
