Senior ETL Developer and DBA

• Mar 2022 - Present

a) I was involved in complex ETL design and development in ODI, SQL and PL/SQL queriesb) Resolving Data Integration and Replication Issuesc) Implementation of Change Data Capture (CDC) using ODI Toold) Collects production & history data from all data sources (Oracle, SQL Server, IBM AS400/ DB2 & Non- Database) working for FBR via live & passive links as per system requirements, Further it Disseminates acquired data to all stakeholders of FBR within and external departments, throughout the country.e) Migration of Data from MS Excel, Access and SQL Server to Oracle Databases and vice versa using Oracle SQL Loader, MS SQL Server DTS Packages and Import/Export utilities.f) Debugged existing ETL processes and did performance tuning to fix bugs.g) Interacted with third party vendors and identified different external and internal homogenous and heterogeneous sources and extracted and integrated data from flat files, Oracle, SQL Server sources and loaded to staging area and database target tables.

ETL Developer and DBA

• Jan 2012 - Present

Database Administration Task Installation, configuration, Maintenance and administration of Databases in Oracle and SQL Server on Windows Server and Linux Operating Systems. Monitoring Database Performance and tuning Using Oracle Recovery Manager (RMAN) with Catalog Database in Oracle to implement backups and recovery Managing databases structure and storage allocation and planned future requirement of the database. Trouble shooting Oracle Errors  Creating and altering database users , Roles Configuration of Database Alerts Creating, Scheduling and Monitoring JOBS  Configure Oracle Data Vault 11g to implement different policies to restrict insider userExtract Load & Transform Data– Interacted with third party vendors and identified different external and internal homogenous and heterogeneous sources and extracted and integrated data from flat files, Oracle, SQL Server sources and loaded to staging area and database target tables. Designed and implemented stored procedures, views and other application database code objects to aid complex mappings. Maintained SQL scripts and complex queries for analysis and extraction. Debugged existing ETL processes and did performance tuning to fix bugs. Configure Email Alerts against ETL Jobs. Coordinated and monitored the ETL jobs progress to ensure the timely flow and complete delivery of the jobs. Migration of Data from MS Excel, Access and SQL Server to Oracle Databases and vice versa – using Oracle SQL Loader, MS SQL Server DTS Packages and Import/Export utilities. Using ODI 11g integrate data from different Database Environment. Worked on Topology, Modeling, Projects (interfaces, packages, Procedures, scenarios, variables, knowledge modules) and Operator Level in ODI 11g Implemented and managed CDC by using Oracle Data Integrator (ODI 11g). Replicating data between different Database Servers using Database Links, Oracle Heterogeneous Services and Oracle Golden Gate.

dba

• Mar 2009 - Dec 2011

DBA

• 2013 - 2013