Assistant Consultant
Tata Consultancy Services Ltd
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
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
Open to travel worldwide
