Informatica ETL Developer/Oracle Database Administrator Resume Washington DC - Hire IT People

SUMMARY:

Over 10 years of IT experience with extensive experience in Oracle Database Administration, ETL Development and Administration using informatica power center, Data warehousing, SAS Administration, Data Migration, Data Modeling, Development, Maintenance and Documentation of Processes in an Agile environment.
Team player and self - motivated, able to set effective priorities to achieve immediate and long-term goals and meet operational deadlines.

TECHNICAL SKILLS:

ETL: Informatica Power Center 9.5/9.6

Databases: Oracle 9i/10g/11g, SQL Server

Tools: SQL Loader, TOAD, SQL Plus, Data pump Export/Import, Oracle Streams, Oracle active data guard, RMAN Backup and Recovery, RAC

Programming: UNIX Shell Scripting, SQL, Batch scripting

System: Sun Solaris, Redhat Linux, Windows 2000/2008

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

Informatica ETL Developer/Oracle Database Administrator

Responsibilities:

Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle, Web XML, SQL Server and Delimited Flat files.
Installation and Configuration of Oracle Databases and Informatica power center.
Development of ETL using Informatica Power center 9.5 and 9.6. transformations .
Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.
Prepared various mappings to load the data into different Staging and Target tables.
Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.
Developed Workflows using task developer and workflow designer in Workflow manager and monitored the results using workflow monitor.
Performed XML ETL with XML Definition, Parser and Generator Transformation.
Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
Prepared SQL Queries to validate the data in both source and target databases.
Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
Worked extensively on SQL as part of the process to develop several scripts to handle different scenarios.
Prepared the error handling document to maintain the error handling process.
Automated the jobs using UNIX shell scripting.
Closely worked with the reporting team to ensure that correct data is presented in the reports.
Create databases and configuring them to meet developers and user requirements
Backup and recovery Implementation
Database Migration across OS platforms and Upgrades
Application of Oracle patches
Database Tuning for Application and User optimal performance
WebLogic installation, Deployment and Patching
SQL, Shell Script development, deployment and scheduling
Database refresh using Data pump
Deployed Oracle High Availability using RAC and Active Data guard
Monitors database activity and resource usage via scripting and OEM.
Created internal DBA & Informatica documents including problem resolutions documents, lessons learned documents, and basic knowledge transfer documents.
User support and account management

Confidential, Bowie, MD

Database Administrator

Responsibilities:

Served as DBA team member in the completion of medium scale implementations, managing projects from business requirements analysis to solutions delivery and support.
Quickly resolve performance related issues with production databases
Developed and tested storage strategies
Developed and tested backup and recovery strategies
Enhanced end users' understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials.
Running AWR report for performance tuning of database
Deployed Oracle High Availability based on Streams Replication and Active Data guard
Database upgrades and patching
Experienced with Real Application Cluster 11gR2

Confidential

Database Administrator

Responsibilities:

Configured Oracle Active Data guard for failover to a DR site.
Configured Oracle Streams Replication to a Database Reporting Server
Advanced RMAN technologies including RMAN CATALOG and RMAN DUPLICATE
SQL Tuning with SQL Tuning Advisors
ADDM & AWR Reports for performance Monitoring and Tuning
Database upgrades and patching
Manage User access

Confidential

Junior Database Administrator

Responsibilities:

Installed Oracle using OUI
Developed scripts and reports that were instrumental to the success of high-priority development projects
Manage table space size and schema objects
Configure Oracle network settings using NETCA
Create database using DBCA
Used SQL Developer to quickly design database objects
Managed backup and recovery using RMAN and flash backup and recovery
Implemented database patches to current releases

We provide IT Staff Augmentation Services!

Informatica Etl Developer/oracle Database Administrator Resume

Washington, DC

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship