4 + years of expertise as Engineer on SQL Server and Oracle PL/SQL with hands on programming in Unix Shell Scripting.Also, have experience in Data Migration and Data visualization using tools like ApacheNIFI and Informatica PowerCenter.
Contribution:
• Onboarding new Clients as per contractual requirement and Standard Data object model.
• Setup Data Refreshes on Informatica PowerCenter for sync data from Salesforce to Database tables.
• Focused on Developing SQL Queries and PLSQL Procedures as per client requirement and integrating in Scripts.
• Developing extracts/reports with the help of Unix Shell Scripts, Perl and Python scripting.
• Developing Data Transformation and Loading using SQL*Loader from different heterogeneous source systems and store data in different targets like Flat files, Excel, andCSV.
• Scheduling Shell Script jobs by Crontab and for backup/restore of different schema using Imp/Exp utility
• Designed and Develop UNIX scripts for creating, dropping tables which are used in Scheduled Jobs.
Environment
Operating System : Linux, Windows
RDBMS : Oracle11g, SQL Server
Language : C, SQL, PLSQL
Scripting : Shell, C#, Perl
Cloud Services : Microsoft Azure
ETL Tools : Informatica Power Center
Tools : GCC, make, SQL* Loader, Apache, Imp/Exp