We provide IT Staff Augmentation Services!

Etl Developer Resume Profile

Columbus, OhiO

PROFESSIONAL SUMMARY

  • Having around 8 years of SDLC experience in Data warehousing with extensive knowledge on Informatica 8.x, 9.x ETL tool and Business Objects XI R2 Reporting tool.
  • Having strong conceptual knowledge in Data Warehousing, Extensively used ETL methodology for supporting Data Extraction, Transformation Loading processing, in a corporate-wide-ETL Solution using Informatica Power Center.
  • Extensively worked on Informatica Powercenter Designer, Workflow Manager, and Workflow Monitor. Implemented Various Performance Tuning techniques on Mappings.
  • Worked on different phases of data warehouse development lifecycle, from gathering requirements to testing and implementation.
  • Thorough knowledge on Data warehouse Concepts like Star, Snow Flake Schemas and good understanding on Data warehouse architecture.
  • Having functional experience in design, analysis and development of Universe, Creating classes and objects as per the business requirements using Universe designer.
  • Involved in the Preparation, implementation and maintenance of the universe using universe designer.
  • Designed and developed reports using Desktop Intelligence, Web Intelligence, and Crystal Reports.
  • Extensively used Business objects reporting functionalities such as Sectioning, Grouping, Slice and Dice, Drilling methodology, Filters, alerts, Ranking and Breaks.
  • Having extensive knowledge on Dashboard manager and Key Performance Indicators KPI .
  • Extensively worked on large database applications and Data marts.
  • Extensively worked on Databases like Oracle 11g/10g/9i/8i, SQL Scripting.
  • Good knowledge on writing the PL/SQL Scripts like Procedures, Packages and Functions.
  • Testing skills include performing Unit, Regression, Integration, and Volume testing as well as Development, Execution, and Maintenance of Test plans, Test specifications and Test scenarios.
  • Experience in providing On Call 24 7 Support for Production Problem Resolution Resolve Production issues and problems in an expedited manner .
  • Good understanding of Data warehousing, ER Modeling and Dimensional Modeling concepts.
  • Worked on preparing Low level, High level design documents along with Release notes Run book.
  • Good understanding of Product Life Cycle and Comprehensive Delivery Process's.
  • Team player with strong People Management skills, excellent Communication and Problem Solving skills and exposed to various design and presentation tools like Visio and MS-Office utilities.

TECHNICAL SKILLS

Operating Systems

Windows XP/2003/NT, Unix, Linux

Languages

C , SQL

Databases GIU

SQL Server2000, Oracle 8i/9i/10g/11g, Netezza, Teradata, Toad, SQL Developer, MS-Access Visio.

Scheduling Tools

Informatica Scheduler, TWS Tiwoli , Control-M

Tools Utilities

Informatica 8.x, 9.x, Business Objects XI R2, Crystal Reports XI, Dashboard Manager, Xcelsius, Putty, PVCS, SVN, HP Quality Center11

PROFESSIONAL EXPERIENCE

Project Name

Confidential

Client

Confidential

Role

ETL Developer

Technologies

Informatica 9.5.1, Business Objects XI R2, Teradata

Duration

Confidential

Team Size

7

Environment

Software

Database: Teradata

Tools: Informatica 9.5.1, Business Objects XI R2

OS: Unix

Roles Responsibilities:

  • Involved in doing reverse engineering on existing EDW logic for preparing new mappings in ICDW.
  • Leading as an onsite/offshore coordinator and lead team by providing ETL Technical/Functional documents and acted as a Point of Contact POC for the offshore team.
  • Worked on Teradata TPT loads
  • Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation Connected and Unconnected , Joiner Transformation, and Router Transformation, and Normalizer Transformation in Informatica.
  • Interacted DBA team to make sure application data base and also created all necessary data base objects for our project in Dev and Test Environments.
  • Also provided all Database Object scripts for DBA team to deploy stage and prod DB environments.
  • Created and Configured Sessions, Worklets and Workflows to load the data into target/s using Informatica Workflow Manager.
  • Created Mapplets and Reusable Transformations to prevent redundancy of transformation usage.
  • Worked as onsite coordinator to transfer work to offshore and made sure the deliveries happen on time.
  • Created sessions and workflows for the mappings.
  • Involved in performance improvement on the long running jobs.
  • Documented the mapping process and methodology used to facilitate future development.
  • Prepared the CCR for deploying the code into production
  • Involved in requirement gathering meetings with clients.
  • Used performance improvement techniques in informatica for tuning mappings.
  • Involved in running the loads to the data warehouse involving different environments.
  • Analyzed business information requirements.
  • Involved in creating jobs using control M scheduler tool.
  • Involved in supporting the production jobs
Project Name

Confidential

Client

Confidential

Role

Team Member

Technologies

Informatica 8.6.1, Business Objects XI R2, Netezza, Oracle

Duration

Confidential

Team Size

4

Environment

Software

Database: Netezza

Tools: Informatica 8.6.1, Business Objects XI R2

OS: Windows XP

Roles Responsibilities:

  • Understanding the Business requirements.
  • Design ETL processes using Informatica to load data from various data sources to target Data Warehouse.
  • Developed mappings using Informatica Power Center for data loading.
  • Developed mapplets using Mapplet designer for usage of reusable.
  • Used Informatica Power Center Workflow manager to create sessions, workflows to run tasks.
  • Defined Target Load Order Plan for loading data correctly into different Target Tables and also done Unit testing
  • Worked with Slowly Changing Dimensions and Version Controlling.
  • Used Informatica Power Center Workflow manager to create workflows and Sessions to run tasks.
  • Used Debugger to debug the mappings and used target load order plan for loading data correctly into different Target Tables.
  • Participated in weekly meetings with client and discussed all the week days' activities/issues.
  • Improved the application performance by fixing bugs in the application.
  • Responsible for communicating the support processes within the team and to the customers.
Project Name

Confidential

Client

Confidential

Role

Team Member

Technologies

Informatica 8.6.1, Business Objects XI R2, Netezza, Oracle

Duration

Confidential

Team Size

4

Environment

Software

Database: Netezza

Tools: Informatica 8.6.1, Business Objects XI R2

OS: Windows XP

Roles Responsibilities:

  • Understanding the Business requirements.
  • Design ETL processes using Informatica to load data from various data sources to target Data Warehouse.
  • Developed mappings using Informatica Power Center for data loading.
  • Developed mapplets using mapplet designer for usage of reusable.
  • Used Informatica Power Center Workflow manager to create sessions, workflows to run tasks.
  • Defined Target Load Order Plan for loading data correctly into different Target Tables and also done Unit testing
  • Worked with Slowly Changing Dimensions and Version Controlling.
  • Used Informatica Power Center Workflow manager to create workflows and Sessions to run tasks.
  • Used Debugger to debug the mappings and used target load order plan for loading data correctly into different Target Tables.
  • Involving in preparation of Unit Testing, Test Case Execution. Involved in designing the universe and created classes and objects according to the requirement of the Reports using Designer.

Hire Now