We provide IT Staff Augmentation Services!

Etl Developer Resume

Folsom, CA

PROFESSIONAL SUMMARY

  • IT Professional with over 8 years of IT full life-cycle development experience working as programmer / analyst in designing and developing data warehouse applications using ORACLE Database and PL/SQL procedures.
  • Excellent knowledge of data warehouse architectures, concepts and technologies, dimensional Star Schema and Snowflakes Schema methodologies.
  • Extensively worked with Oracle products, tools and utilities like stored procedures, functions, packages, triggers, indexes, views, synonyms, sequences, 10g/9i/8i/8.x, SQL*PLUS, PL/SQL, SQL Loader, Oracle Enterprise Manager, Developer 2000 Forms and Reports.
  • Good knowledge working on ETL processes like mapping, workflow, transformations etc. using Informatica 7.1 and PL/SQL procedures.
  • In depth understanding in data modeling using ERWIN.
  • Exposure to reporting tools like Crystal Reports and Oracle Discoverer.
  • Experienced in performance tuning of complex queries and database procedures using Explain plan and hints under Cost Based Optimizer (CBO).
  • Extensive knowledge of SQL*Plus, cursors with parameters, Index-by-tables in PL/SQL.
  • Good experience in data migration from Legacy system to Oracle based client Server System using data mapping and Oracle SQL*Loader.
  • Experience in UNIX based Application development and supporting UNIX shell script programs.

TECHNICAL SKILLS

Hardware
Sun Enterprise 3500/4500/5500 Server, Sun Sparc/20, HP Servers (T500, K570/580,D370), IBM-RS 6000, Intel based PCs

Operating Systems
Sun Solaris 2.9/2.8, HP UX 10.20/11.0, AIX 5.2/4.3, Linux, Windows XP/ 2000 / NT 4.0

RDBMS
Oracle 10g/9i/8i, SQL Server 6.5/7.0, MS-Access

Development /
Data Modeling
Tools
ERWIN, Visual Basic 4.0/5.0/6.0, Oracle Forms 4.5, Oracle Reports 3.0, PL/SQL, Unix Shell Script

ETL/DW
Oracle Warehouse builder,Informatica

Database
Experience
PL/SQL Programming, Oracle Installation and Configuration, Application SQL Tuning,, Backup/recovery techniques, SQL*NET configuration, SQL Loader.

PROFESSIONAL SUMMARY

Client : Confidential, Folsom, CA
Role : ETL developer
Environment : Oracle 10g, PL/SQL, SQL Loader, Toad,
Mercury Quality Center

Responsibilities
  • Work closely with Tech lead and Business analysts to understand functionality, scalability, performance, security and integration requirements.
  • Create Stage and target schemas and tables with partitions and constraints as per the design specifications.
  • Create and maintain metadata to define source-target mappings, transformation formulas, load mechanisms, versioning keys and other parameters for each table.
  • Create packages, procedures and functions for the ETL process. Most of the procedures and functions were designed to accept parameters to enable reuse with all source systems.
  • Identify performance bottlenecks and provide specific solutions to address them.
  • Work closely with Tech Lead to define alternate solutions for data that could not be loaded through the regular process due to structural or logical constraints.
  • Create PL/SQL procedures to generate validation scripts for the testing team. This enabled the test team to test all tables and all data instead of just relying on some sample data for testing. Some of the tasks accomplished through these procedures were:

Client : Confidential,West Haven, CT
Role : ETL Lead developer
Environment : IBM RS-6000, Sun-Servers, Oracle 10g/9i, PL/SQL, SQL Loader, Toad,
SQL Navigator, Aix 5.2/4.3, Sun-Solaris 2.9/2.8

Responsibilities
  • Work in conjunction with other IT/development and business groups to understand functionality, scalability, performance, security and integration requirements.
  • Designed and developed ETL data model for the project using ERWIN.
  • Transformed business requirements into technical specifications, source-to-target mappings.
  • Creation of triggers, procedures, packages and functions using Toad.
  • Perform ETL tasks as part of ETL Business operations for data dissemination, suggest and implement improvements in ETL Business process.
  • Data analysis and cleansing of source data.
  • Creation of database procedures to extract and transform source data.
  • Extensive use of SQL loader to load external data into Oracle Staging tables.
Client :Confidential, Miami, FL
Role : PL/SQL Developer
Environment : IBM RS-6000, Sun-Servers, Oracle 10g/9i, PL/SQL, SQL Loader, Toad,
SQL Navigator, Aix 5.2/4.3, Sun-Solaris 2.9/2.8
Project : ETL project for MIS data warehouse.
Responsibilities
  • Played a key role in designing and developing ETL data model for the project using ERWIN.
  • Defined structure of dataflow for seamless migration from large mix data systems.
  • Creation of triggers, procedures, packages and functions using Toad.
  • Data extraction from multiple databases for data warehouse using PL/SQL procedures.
  • SQL Tuning of existing applications using SQL Monitor and Explain Plan.
  • Set the Standards for naming conventions for all entities, data stores and data elements.
  • Ensure the overall integrity of the System Design.
  • Guide developers on PL/SQL standards and troubleshooting.
  • Also assist DBAs for creation of all database objects.
  • Data transfer from external sources using SQL*Loader.

Client : Confidential, Minneapolis, MN
Role : PL/SQL Developer
Environment : Sun Servers, Oracle 10g/9i8i, PL/SQL, Pro* C, Power Builder,
Windows NT, SQL Station Plan Analyzer, OEM 1.6, Sun-Solaris 2.6/2.7/2.8,

Responsibilities
  • Responsible for backend programming, writing stored procedures and triggers. Wrote around 50 triggers, 30 stored procedures, functions and packages.
  • Also assist DBAs for Creation of all database objects, Allocate system storage and Plan future storage requirement.
  • Develop and maintain Application and Database Security Standard. Written and troubleshoot database triggers/Stored Procedures.
  • Database Security - This activity included Creating roles, creating/revoking users.
  • Tuning of the database for the optimum performance.
  • Trouble shooting database related problems in the other divisions of the organization.
  • Import of data into staging tables using SQL*Loader 8.x from flat files, data conversion & data verification.
  • Analysis of uploaded data by using PL/SQL Stored procedures.
  • Migration of the staging data tables into final tables, converting the data using Stored Procedures, PL/SQL and Triggers.
  • Job also included testing Windows based GUI reports developed in Developer 2000, using Manual-testing methodology.
  • Authored and executed test cases under the plans defined by the manager.
  • Defects tracking using BUG database in Microsoft Access, and regression testing.
  • Analyzed and documented Results. Generated Bug and Performance Report.

Hire Now