Project :- Medical Devices Integration with Axtria Product Client :- Pharma Client 2
Roles and Responsibilities:-
•Design and implemented the ETL workflows using PostgreSQL, Matillion and S3 to integrate the data of various sources into one single downstream system.
•Written Python scripts to generate the files based on their business rules.
•Implemented Encryption Decryption logic using RSA algorithm on Inbound and Outbound Data Sets using Python as per the client requirements.
•Worked on enhancements in the code and involved in Code Reviews.
Project :- MDM Integration with Axtria Product
Client :- Pharma Client 3
Roles and Responsibilities:-
•Design and implemented the ETL pipelines to integrate the data of various feeds (multiple source systems) into one single downstream system.
•Created jobs for delta detection process and Load.
•Automated the unit testing process using SQL procedures.