We provide IT Staff Augmentation Services!

Etl Developer Resume

SUMMARY:

  • 8 years of Experience in Information Technology in designing, developing, administration and implementation of Data Warehouse Applications under different environments. Core focus on Data Warehousing OLAP tools mainly ODI.
  • ODI: Extensive DW experience using Oracle Data Integrator, Configured and setup ODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Interfaces, Scenarios, Filters, Condition, Metadata.
  • Data Modeling: Data Modeling experience using Dimensional Data modeling, Star Join Schema modeling, Snow - Flake modeling experience using Normalization, Fact and Dimensions Tables, Physical and Logical Data Modeling.
  • Extensively worked with large Databases in Development, Testing and Production environments.
  • Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
  • Thorough knowledge of Software Development Life Cycle (SDLC) with deep understanding of various phases like Requirements gathering, Analysis, Design, Development and Testing
  • Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
  • Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
  • Expertise in creating stored procedures, functions, packages, Scenarios.
  • Primary responsibility includes but not limited to installing and configuring the Oracle Data Integrator (ODI) software tool in a three-tier environment and performing source-to-target mappings, storage capacity planning, developing ETL.
  • Experience in building procedures, functions, packages and database triggers using Oracle SQL and PL/SQL to improve query performance.
  • Established and maintained productive working relationship with Management, Clients and Team Members. Self-starter, entrepreneurial, highly motivated team- player with excellent communication / problem-solving skills. Quick learning ability vis-à-vis new technology. Easy adaptability to new environments.

TECHNICAL SKILLS:

ETL Tools: Oracle Data Integrator(ODI) 10G,11G, Informatica

Database: Oracle 11g/10g, Netezza.

Languages: SQL, PL SQL

Operating System: Windows 2000/XP, Windows NT, UNIX.

Database Tool: Winsql, SQL Developer, SQL Plus

EXPERIENCE:

Confidential

ETL Developer

Responsibilities:

  • Primary responsibility includes configuring (Topology) the Oracle Data Integrator (ODI) software tool in a three-tier environment.
  • Gathering requirements from users to develop interfaces, packages.
  • Deploying Scenarios from one environment to another environment.
  • Resolving Upgrade issues to make sure daily loads run efficiently.
  • Experience in configuring ODI Agent and creating new agents and test them in ODI 11G.
  • Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
  • Export/Import interfaces across different environments
  • Created Topology which includes creating Master/Work repositories, Physical/Logical schemas, Agents, and Context.
  • Purged the logs in the operator.
  • Performed sending mails to team whenever any ODI jobs are failed by using ODI tools.
  • Worked in importing data from different sources like database tables, flat file.
  • Experience with Business systems such as Sales, Inventory and Order Management.
  • Used Interfaces to load data from Flat files, CSV files in to staging area (Oracle) and load in to Oracle data warehouse
  • Experience in increasing efficiency of data load from source to target by doing performance tuning.
  • Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
  • Used odiparam.bat file for updating recently encoded password for master repository and used startscen.bat file to start the scenario using agent. These scenarios are finally deployed to production.
  • Applied slowly changing dimensions (SCD) in various Mappings to load data from source to target and maintained current and historical data on year wise in all brand dimensions.
  • Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.

Environment: Oracle Data Integrator (ODI) 11.1.1.7/10.1.3.5 , Netezza, winsql, WinNT/XP and UNIX.

Confidential, Houston, Texas

ETL Developer

Responsibilities:

  • Primary responsibility includes analyzing the architecture of the data warehouse with the Solution architects, requirement gathering from the business for building the ELT design process for the backlog project.
  • Gathering requirements from users to develop interfaces, packages, and corresponding business logics using ODI.
  • Deploying Scenarios from one environment to another environment.
  • Resolving issues to make sure daily loads run efficiently.
  • Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
  • Export/Import interfaces across different environments
  • Created Topology which includes creating Master/Work repositories, Physical/Logical schemas, Agents, and Context.
  • Experience in running RCC (Repository consistency check) to see if master and work repositories are consistent.
  • Purged the logs in the operator.
  • Performed sending mails to team whenever any ODI jobs are failed by using ODI tools.
  • Worked in importing data from different sources like database and flat file.
  • Experience with Business systems such as Sales, Inventory and Order Management.
  • Used Interfaces to load data from Flat files, CSV files in to staging area (Oracle) and load in to Oracle data warehouse
  • Experience in increasing efficiency of data load from source to target by doing performance tuning.
  • Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
  • Used odiparam.bat file for updating recently encoded password for master repository and used startscen.bat file to start the scenario using agent. These scenarios are finally deployed to production.
  • Applied slowly changing dimensions (SCD) in various Mappings to load data from source to target and maintained current and historical data on year wise in all brand dimensions.
  • Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.

Environment: Oracle Data Integrator (ODI) 11.1.1.7/10.1.3.5 , Netezza, winsql, WinNT/XP and UNIX.

Confidential

ETL Developer

Responsibilities:

  • Primary responsibility includes configuring (Topology) the Oracle Data Integrator (ODI) software tool in a three-tier environment.
  • Resolving day to day production issues.
  • Gathering requirements from users to develop interfaces, packages.
  • Deploying Scenarios from one environment to another environment.
  • Resolving Upgrade issues to make sure daily loads run efficiently.
  • Experience in configuring ODI Agent and creating new agents and test them in ODI 11G.
  • Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
  • Export/Import interfaces across different environments
  • Created Topology which includes creating Master/Work repositories, Physical/Logical schemas, Agents, and Context.
  • Purged the logs in the operator.
  • Performed sending mails to team whenever any ODI jobs are failed by using ODI tools.
  • Worked in importing data from different sources like database, flat files.
  • Experience with Business systems such as Sales, Inventory and Order Management.
  • Used Interfaces to load data from Flat files, CSV files in to staging area (Oracle) and load in to Oracle data warehouse
  • Experience in increasing efficiency of data load from source to target by doing performance tuning.
  • Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
  • Used odiparam.bat file for updating recently encoded password for master repository and used startscen.bat file to start the scenario using agent. These scenarios are finally deployed to production.
  • Applied slowly changing dimensions (SCD) in various Mappings to load data from source to target and maintained current and historical data on year wise in all brand dimensions.
  • Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.

Environment: Oracle Data Integrator (ODI) 11.1.1.7/10.1.3.5 , Netezza, winsql, WinNT/XP and UNIX.

Confidential

ETL Consultant

Responsibilities:

  • Worked along with business analysts, developers, management professionals and as well as with business users from various locations of Amway to gather requirements.
  • Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
  • Experience with Business systems such as Sales, Inventory and Order Management.
  • Used Interfaces to load data from Flat files, CSV files in to staging area (Oracle) and load in to Oracle data warehouse
  • Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
  • Used odiparam.bat file for updating recently encoded password for master repository and used startscen.bat file to start the scenario using agent. These scenarios are finally deployed to production.
  • Applied slowly changing dimensions (SCD) in various Mappings to load data from source to target and maintained current and historical data on year wise in all brand dimensions.
  • Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration
  • Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
  • Scheduled batch jobs using ODI schedule
  • Created versions for interfaces using Version control.
  • Primary responsibility includes but not limited to installing and configuring the Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL.
  • Primary focus and/or development efforts were in the reengineering of the ETL processes using the Oracle Data Integrator (ODI).
  • Created SQL scripts for sourcing data, including creating tables, Materialized views, stored procedures, and loading data into the tables.
  • Used ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.
  • Implemented Change Data Capture (CDC) techniques on data model level and load updated data to target.
  • Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it.

Environment: Oracle Data Integrator (ODI) 11g/10.1.3.5, Oracle 11g/10g, WinNT/XP and UNIX.

Confidential

Software Engineer

Responsibilities:

  • Validate the required data at the database level by using tool Toad.
  • Used Toad for analysis and maintained Database using DDL’s, DML’s.
  • Worked with the development team to design, develop, test and implement the system.
  • Designing and modifying of Database tables, keys, indexes, grants, triggers, packages, functions and procedures etc.
  • Created partitioned tables, partitioned indexes for manageability and scalability of the application.
  • Did data profiling, data cleansing
  • Developed Database Triggers for the integrity and security purpose.
  • Oracle Job Scheduling and Advanced Queuing by Scheduled and Maintain Batch jobs.
  • Used PL/SQL Developer Tool to do the backend development.
  • Handled various Exceptions to trouble-shoot PL/SQL code.
  • Wrote complex Oracle SQL using joins, sub queries and correlated sub queries.
  • Responsible for the dealing with the problems, bug fixing and troubleshooting.
  • Develop and maintain the documentation.
  • Data loading using PL/SQL.
  • Used PL/SQL Developer Tool to do the backend development.
  • Wrote Oracle SQL using joins, sub queries and correlated sub queries.
  • Responsible for the dealing with the problems, bug fixing and troubleshooting.
  • Develop and maintain the documentation.

Environnent : Oracle 10g, SQL Developer, PL/SQL, UNIX, MS Office.

Hire Now