We provide IT Staff Augmentation Services!

Sr. Oracle Etl Developer Resume

NJ

PROFESSIONAL SUMMARY

  • 7+ years of experience in Information Technology with expertise in Database Development, Data Warehousing, Implementation, Maintenance and Support.
  • Expert in building and migrating ETL processes using PL/SQL and ODI
  • Sound experience in best Data Quality practices
  • ODI expert with extensive experience with Designer, Operator, Topology Manager and Security Manager modules and troubleshooting of packages.
  • Excellent knowledge of Database architecture, ODI Architecture and related best practices.
  • Experience in Code and Data migration.
  • Experienced in developing/ tuning complex SQL queries, PL/SQL blocks, stored packages, procedures, functions, Partitions, triggers, and views.
  • Hands-on new development as well as support, maintenance or enhancement of existing applications.
  • Involved in all phases of the SDLC from analysis, design, development, testing Implementation and Maintenance with timely Delivery against aggressive deadlines.
  • Expertise in Database Performance Tuning, Performance Monitoring and Optimization using tools such as Oracle Hints, SQL Trace, Explain plans and Table partitioning
  • Involved in large volume data migration to Enterprise Data Warehouse using UNIX(IBM AIX, Solaris, Linux) scripts, SQL*Loader, PL/SQL.
  • Implemented Packages (Stored Procedures, Functions, Cursors, Triggers), Data Cleansing, Transformation Scripts and necessary test plans to ensure the successful execution of the data loading processes for Data Warehouse and Data Marts.
  • Extensive experience carrying analysis, design, normalization and de–normalization, database modeling using Erwin.
  • Involved in Requirement gathering and conceptual design of databases in multiple projects.
  • Ability to perform well as a Team member and as an Individual, with dexterity to blend well in any situation and environment.
  • Excellent Analytical and Problem solving skills.
TECHNICAL SKILLS

Databases
Oracle 8.x/9x/10g, DB2 UDB 7.2,MySql 5.0/4.1, PostGreSQL 8.4
Oracle Tools
Oracle Enterprise Manager, TOAD, Statspack, TKPro
ETL Tools
Oracle Data Integrator, Informatica 6.0/7.1, Data stage 7.5.1/7.
OLAP/ Reporting Tools
Developer 2000(Forms 5.0,6i Reports 6i), Crystal Reports 10
Operating Systems
HP-UX 11, Sun Solaris 9/10, Windows 2000
Programming Skills
Shell Scripting, PL/SQL, JAVA, HTML.
Data Modeling
ERwin 4.0, Visio 2000
WORK EXPERIENCE

Confidential , NJ
Sr. Oracle ETL Developer
Confidential is leader in fiber optics, mainly business into phone, Internet, TV, wireless and service bundles to residential, business, government and wholesale clients. Confidential is migrating all legacy ETL processes into the ODI suite.

Responsibilities:
  • Mapping functional requirements to technical design documentation.
  • Interacted with individual application owner to understand the respective system.
  • Created over 100 interfaces to map the data between source and target
  • Implemented CDC to capture the changed data
  • Customization of Knowledge Modules to build reusable components
  • Developed and modified Existing Packages, Stored Procedures, Stored Functions and Cursors with a focus towards reusability of code
  • Developed complex SQL queries for data retrieval from various database objects including tables and views.
  • Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
  • Handled PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for business logic modification, Granting and Revoking Schema Object Privileges and Roles, responding to System Events through Triggers.
  • Developed the Procedures to be able to customize the report according to the specifications.
  • Tested the reports for quality and end user validation
  • Performed tuning and optimization on SQL Queries using analyze, explain plan, TKPROF utility and optimizer hints.
  • Run the SQL queries to fetch test data and database testing to validate the database.
  • Participated in daily status meeting to report any bugs , issues and risks.
  • Performed Verification and validation.
Environment: ODI, Oracle 9i/10g, Solaris 10, VMware, Toad 9.2, XML, PL/SQL, SQL*Loader, PostGreSQL 8.4

Confidential, PA
Database Developer
  • Hands-on new development as well as support, maintenance or enhancement of existing applications.
  • Creating .sql files that select data from an Oracle 10g database.
  • Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Trace sessions for Cost based and Rule based Optimization.
  • Using PL/SQL, Stored procedures and functions to support the database side of the application.
  • Analyzed the existing method for data repository refresh and then developed a new package with tuned queries to improve the performance and reduce the time taken for the refresh.
  • Handling PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for business logic modification, Granting and Revoking Schema Object Privileges and Roles, Responding to System Events through Triggers.
  • Wrote PLSQL procedures to generate DDL scripts that created database objects dynamically based on user inputs.
  • Creating Shell Scripts (KSH) in UNIX environment that run the .sql files, schedule them in UNIX CRONTAB, Autosys.
  • Developed Source to Target mapping using Informatica.
  • Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
  • Designed and developed Informatica Mappings to load data from Source systems Data Mart.
  • Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
Environment: Oracle 10g/9i, SQL Server 2000, Windows 2000/XP, Toad, UNIX AIX 5.3(K-Shell), SQL, PL/SQL, SQL*Loader
Confidential, MN
ODI Developer
  • Developed ODI interfaces and packages for integrating data in the data warehouse.
  • Implemented ODI constraints for Data Cleansing, Transformation Scripts and necessary test plans to ensure the successful execution of the data loading processes for Data Warehouse and Data Marts
  • Tuned ODI Knowledge Modules for optimized SQL statements
  • Provided physical and logical design of star-schemas and slowly changing dimensions, including demonstrative detail in the construction of table partitioning, materialized views, query rewrite, and star transformation.
  • Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes
  • Involved in discussions with users, managers, team leads, business users to clarify programs issues and problems.
  • Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
  • Modifying triggers, functions, procedures to accommodate on going changes in business logics, Scripts to automate manual tasks using oracle built-in packages.
  • Extensively used SQL* Loader , Export tables, External Tables and Oracle utilities for data loading process.
  • Create the B.I reports using Cognos Report studio, Query Studio and scheduling reports, E-mail the reports to corresponding recipients.
  • Created sub programs with Dynamic SQL at both client and Server side (DBMS SQL, Native Dynamic SQL at Server Side and EXECUTE SQL at Client side).
  • Developed back end interfaces using PL/SQL packages, stored procedures Collections, Object Types and triggers.
  • Automation of the procedures using shell scripts batch jobs to copy the data from the production servers to the test servers on weekly basis.
Environment: Oracle Data Integrator, Oracle 10g/9i, Windows 2000/XP, Solaris 10, SQL Navigator, Toad 9.2, SQL, PL/SQL, SQL*Loader, Cognos 8.1, K-Shell, Toad, Informatica 7.1
Confidential, CA
Database Developer
Responsibilities:
  • Developed complex SQL queries for data retrieval from various database objects including tables and views.
  • Built data integration interfaces to FACETS
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Responsible for getting Requirements for creating data models for data analysis and reporting
  • Analyzing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions,Packages and Triggers.
  • Extensively involved in UNIX Shell scripting for writing Wrapper scripts, SQL Execution scripts in ETL processes.
  • Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment using PL/SQL and SQL*Plus.
  • Involved in developing UNIX Shell Scripts required for maintaining the data Models and processing job.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
  • Developed complex queries using SQL and PL/SQL (procedures, functions, triggers and packages) for data extraction, transformation, loading and to create reports.
  • Fine-tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Trace sessions for Cost based and Rule based Optimization.
  • Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints and Explain plans.
  • Created multiple customized PL/SQL Packages for various Business needs.
  • Created various ER diagrams and Dataflow diagrams using Oracle Designer.
Environment: Oracle 8i/9i/10g, SQL/PLSQL, FACETS, SQL Server 2005, Windows NT/2000/XP, UNIX-HP AIX,5.1 PL/SQL, SQL*Loader, Toad.
Confidential, CA
Oracle Developer
Responsibilities:
  • Tuned frequently used SQL Statements and PL/SQL Blocks using SQL-Lab and increased performance by utilizing optimization techniques.
  • Created various stored PL/SQL blocks including Stored Procedures, Functions, and Packages to manipulate and transform data according to the requirements.
  • Created and manipulated PL/SQL tables (i.e. Index-by Tables and Nested tables) and Varrys.
  • Involved in creating Procedures, packages and appropriate REF Cursors to handle BULK collects and BULK binds.
  • Created Ad-Hoc SQL queries to verify data integrity and data analysis.
  • Created Database Triggers to accommodate for data integrity and additional Referential Integrity.
  • Migrating data with utilities including Sqlldr, Logical backup (Export/Import), Transportable tablespaces and writing adhoc blocks to fulfill the requirements.
  • Study database to reveal the inconsistency between spaces allocated to transactive intensive tablespaces & other to specify the block level definitions Pct free, Pct used .
  • Performance tuned multiple SQL queries and PL/SQL blocks using Explain Plan, Hints and SQL Trace.
  • Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse Impact on integrated system environment.
Environment: Oracle 8i/9i, SQL, Windows, Solaris 9, Oracle Developer Suite, , SQL, PL/SQL, K-Shell, Clear case.
Confidential
Oracle developer/Oracle Developer DBA
Responsibilities:
  • Wrote scripts for indexes and Database Objects as per the Oracle Standards.
  • Created SQL, Object Views and PL/SQL database objects.
  • Extensively used PL/SQL Stored Procedures, Functions, Form Triggers and Packages.
  • Created generic scripts to dynamically compile database objects in their Dependency order.
  • Fine-tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Trace sessions.
  • Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts
  • Involved in performance tuning and monitoring.
  • Designed and developed backend PL/SQL packages in the database layer, stored procedures, functions and triggers
  • Established methods to migrate databases, objects and jobs to new servers.
  • Tuning of stored procedures & developed business logic in database layer using PL/SQL.
Environment: Oracle 8i, HP-UNIX, SQL, PL/SQL, SQL*Loader and Toad.

Hire Now