We provide IT Staff Augmentation Services!

Senior Etl Developer Resume

4.00/5 (Submit Your Rating)

SUMMARY

  • Over 15+ years of experience in various phases of software development life cycle including analysis, functional requirements, design, development, conversion/migration, testing and implementation of projects using Oracle Oracle12c/11g/10g/9i/8i/7.x. Possess technical expertise in Oracle SQL, PL/SQL, Data warehousing, Informatica, OBIEE and UNIX Shell scripting.

TECHNICAL SKILLS

Operating System: SUN SOLARIS, AIX, LINUXWINDOWS 2000/NT, WINDOWS 2000

Database: ORACLE 12c/11g, 10G/9i/, SQL Server, XMLDB, Teradata

BI: OBIEE 10.1.3.2/ 10.1.3.3/ 10.1.3.4/11g, BI Publisher

Languages: SQL, PL/SQL, XML, HTML, Java Script

Tools: Enterprise Manager, Crystal Reports, JDeveloper, BI BeansDiscoverer, Informatica Power Center 9.1/8.6, TOAD, PGP

Data modeling: DESIGNER 2000, ERWIN, VISIO

Data warehouse: Oracle Warehouse Builder 3i, CONSTELLAR 2.11

PROFESSIONAL EXPERIENCE

Senior ETL Developer

Confidential

Responsibilities:

  • Converted teh data mart from logical design to physical design, defined data types, Constraints, Indexes
  • Defined various facts and dimensions in teh data mart including Fact less Facts, Aggregate and Summary facts
  • Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor
  • Involved in Dimensional modeling (Star Schema) of teh Data warehouse and used Erwin to design teh business process, dimensions and measured facts
  • Extracted teh data from teh flat files and other RDBMS databases into staging area and populated onto Data warehouse
  • Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in teh Informatica Designer
  • Developed mapping parameters and variables to support SQL override
  • Created mapplets to use them in different mappings
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse
  • Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner
  • Performance tuning of teh Informatica mappings using various components like Parameter files, Variables and Dynamic Cache
  • Performance tuning using round robin, hash auto key, Key range partitioning.
  • Used shell scripts for automating teh execution of maps
  • TEMPEffectively interacted wif teh end users for requirement gathering and defined requirement specifications document

Environment: Oracle 11g/12C, Informatica Power Center 9.6/9.5, SQL, PL/SQL, Sun-Solaris

ETL/OBIEE Developer

Confidential

Responsibilities:

  • Involved in DB Design, implementation of standards and best practices in terms of coding standards, referential integrity, logical grouping of business logic
  • Developed Oracle packages, triggers, functions as per requirements
  • Used Oracle’s data pump utility to move teh data across teh databases
  • TEMPEffectively interacted wif teh end users for requirement gathering and defined requirement specifications document
  • Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables
  • Created different types of Customized Reports Drilldown, Aggregation to meet client requirements
  • Built Business model and established relationships & Foreign Keys Physical & Logical between tables
  • Generated various Analytics Reports using global and local filters
  • Identified teh aggregate levels for each source and created dimension sources for each level of aggregates
  • Added users and configured security in web logic console of OBIEE 11g
  • Change, Release Management & Version Control using ClearCase and ClearQuest

Environment: Oracle 11g R2, OBIEE 11G, BI Pubisher, Clearcase, Clearquest, Statspack, Tkprof, SQL* Plus, Erwin, PL/SQL, Sun-Solaris

Senior ETL Specialist

Confidential

Responsibilities:

  • Designed table structures to support new functionalities
  • Developed Oracle packages, triggers, functions as per requirements
  • Used Oracle’s bulking techniques to process huge number of rows
  • Monitored database for slow performing queries and halped teh developers to fix them
  • Maintained ETL packages that loaded data into Data warehouse
  • Used teh OBIEE 10.1.3.4 Administration tool to develop and enhance Data Model
  • Configured and created OBIEE Repository
  • Designed schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables. Built Business Model and established relationships & Foreign Keys (Physical & Logical) between tables
  • Identified teh aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement
  • Created executive level Reports and Dashboards catering to provide insight into teh sales / marketing data
  • Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards
  • Developed BI Consumer reports using OBIEE 11g

Environment: Oracle 11g, OBIEE 10.1.3.4, Clearcase, Clearquest, Statspack, Tkprof, SQL* Plus, Erwin, PL/SQL, Sun-Solaris

Senior ETL Developer

Confidential

Responsibilities:

  • Actively involved in teh entire SDLC of teh IR2 analytical reports development
  • Designed, developed and unit tested PL/SQL packages to load DataMart wif OLTP data
  • Used dynamic SQL to create tables and indexes for various business needs
  • Used Oracle CTAS (Create Table As Select) wif nologging (to avoid undo and redo) for teh faster creation of huge temp tables
  • Used statspack utility extensively to capture database statistics
  • Implemented local partitioned Indexes on teh daily partitions
  • Used Oracle's PEL (partition exchange loading) to exchange data from temp table wif fact table partitions
  • Used features such as bulk binds and NOCOPY to improve performance
  • Employed Explain Plan and SQL*Trace to analyze query path and performance
  • Developed Unix shell scripts and automated their running
  • Worked closely wif requirements analysts, Business users, QA and Operations teams

Environment: Unix- Sun Solaris, Oracle 10g, Embarcadero, TOAD, Clear Case/Quest

ETL Developer

Confidential

Responsibilities:

  • Responsible for Business Analysis and Requirements Collection
  • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor
  • Created ETL coding and mapping standards based on design specification
  • Designed and customized data models for Data warehouse supporting data from multiple sources on real time
  • Created mapping documents to outline data flow from sources to targets.
  • Extracted teh data from teh flat files and other RDBMS databases into staging area and populated onto Data warehouse.
  • Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in teh Informatica Designer
  • Created mapplets to use them in different mappings
  • Developed mappings to load into staging tables and tan to Dimensions and Facts.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of teh workflow
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly changing dimension tables
  • Extensively used SQL* loader to load data from flat files to teh database tables in Oracle
  • Modified existing mappings for enhancements of new business requirements
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels
  • Prepared migration document to move teh mappings from development to testing and tan to production repositories

Environment: Unix- Sun Solaris, Informatica Power Center 8.6.1, PL/SQL, Oracle 10g/9i, SQL Server 2005, UNIX Sun Solaris

Senior Database developer

Confidential

Responsibilities:

  • Designed and developed packages to load Land and Fact tables wif Usage data
  • Extensively developed stored procedures and functions for data validation
  • Developed Unix shell scripts and automated their running
  • Developed Teradata queries to extract data, perform business rule validations
  • Used PGP encryption to encrypt customer files and send to third party vendors
  • Tuned SQL queries for their optimal performance using optimizer hints
  • Used Oracle's Export/Import utilities to backup data on a weekly basis
  • Used Oracle's SQL*Loader to stage data from Teradata into Oracle databases
  • Worked wif Sprint’s marketing team in implementing marketing promotions to customers
  • Communicated wif external vendors on file transmissions and issue resolution, if any

Environment: Unix - Aix 4.3, Oracle 10G, SQL, PL/SQL, SCP, Teradata, PGP

Development DBA

Confidential

Responsibilities:

  • Created Oracle databases using database creation scripts and monitored their running
  • Developed several migration routines using PL/SQL packages and functions to load source data from different sources into a central Oracle database
  • Automated teh migration process and incorporated error handling and validation using Unix shell scripts
  • Installed Oracle 9i RAC in a Unix environment for multiple nodes using ASM for a storage manager
  • Involved in performance tuning on a 10G RAC database
  • Developed backup and recovery strategy for Real Application Clusters databases
  • Analyzed statspack reports to find performance bottlenecks
  • Tuned DB initialization parameters to improve database performance
  • Employed Explain Plan and SQL*Trace to analyze query path and performance
  • Tuned SQL queries for their optimal performance using indexes and optimizer hints
  • Designed and created PL/SQL functions and packages to implement business rules
  • Used Data pump and SQL*Loader extensively
  • Developed several reports using SQL and PL/SQL and formatted teh output using SQL*Plus
  • Developed shell scripts to automate running of SQL reports at teh end of each month
  • Worked closely wif requirements analysts, Business users, QA and Operations teams

Environment: Unix - Sun Solaris, Oracle 10G, SQL Server 2000, SQL, PL/SQL

Confidential

National Patient Safety Network

Responsibilities:

  • Installed OWB 9i (Oracle Warehouse Builder) repository and runtime environments
  • Created mappings that involved Oracle views on XML tables as input data
  • Defined transformations based on business rules and stored teh output data in Oracle tables
  • Evaluated Oracle JDeveloper and Bi Beans as OLAP tools. Created sample cross-tab reports and tested them
  • Installed Enterprise manager, JDeveloper and Bi Beans. Fixed all teh installation issues and setup an integrated development environment involving teh above tools.
  • Created simple and complex dimensions and cubes catering to business requirements.
  • Setup OWB repositories and runtime environments
  • Sourced various clinical trail data into ODS (Oracle Data Store) and Data marts using Oracle Warehouse Builder
  • Developed ETL mappings, transformations and scheduled them using Oracle Workflow
  • Trained teh team wif teh OWB tool and lead teh OWB development effort
  • Incorporated Oracle 8i features such as materialized views to optimize queries
  • Used Expressions, Aggregations, Stored procedures, filters and lookup in mappings

Environment: Oracle 8i, PL/SQL, Oracle Warehouse Builder 3i, TOAD

Datawarehouse developer

Nextel Communications, USA Mar. ‘01 - Oct ‘01

Responsibilities:

  • Developed teh low level and high level design documents for individual NAR components
  • Developed SQL scripts and PL/SQL packages to cleanse data before loading into target tables
  • Created Database triggers, procedures and functions
  • Tuned SQL queries for their optimal performance using indexes and optimizer hints
  • Developed teh integrated, korn shell script that ran teh complete NAR process from start to end
  • Used materialized views and bitmap indexes for optimum performance
  • Designed, developed and implemented ‘Electronic Distribution’, a feature by which monthly commission systems are emailed to Partners and Sales representatives
  • Developed several Oracle PL/SQL procedures involving PL/SQL tables.
  • Designed and created database triggers to populate teh ID columns in teh table
  • Designed and implemented an automated system using Developer 2000 that generated partner statements based on teh region they belonged to
  • Designed data models for applications based on Star schema
  • Identified Dimension, Landing, Reference and Fact tables for applications and their relationships
  • Designed and developed packages to load Land and Fact tables wif Usage data
  • Tuned SQL scripts statements for their optimum performance
  • Used SQL*Loader to load rows in teh order of millions into teh Landing tables

Environment: Oracle 8.0, Unix - Sun Solaris, PL/SQL, TOAD

Database Administrator

Confidential,

Responsibilities:

  • Involved in developing data models for teh integrated datawarehouse structure
  • Implemented Oracle 8.0 feature, 'External Procedures' for sending mails from Oracle
  • Used Oracle's Export/Import utilities to migrate data between Oracle databases
  • Tuned SQL queries for their optimal performance using hints and Initialization parameters
  • Extensively worked in Unix, created shell scripts
  • Involved in teh Data Transformation stage of teh Data warehouse
  • Used Erwin to develop data models
  • Extensively developed stored procedures and functions for data validation
  • Developed Unix shell scripts and wrote code to automated their running
  • Loaded data into Oracle database using SQL*Loader
  • Developed complex forms for various modules using Forms 4.5
  • Developed specialized reports for various modules using Reports2.5.
  • Tuned teh application for optimal performance

Environment: Oracle 7.3, AIX, Developer 2000, Windows 3.11

We'd love your feedback!