We provide IT Staff Augmentation Services!

Senior Etl Developer Resume

PROFESSIONAL SUMMARY:

  • Over 10 y ears of diversified experience in the field of Information Technology with an emphasis on complete software life cycle implementation of Data warehousing and Decision Support Systems (DSS).
  • Proficient in understanding business processes / requirements and translating them into technical requirements.
  • Have good Hands on Experience in Informatica 9.1 version.
  • Have good experience in CRM application. Handled two different projects with CRM applications.
  • Have knowledge in OBIEE.
  • Have knowledge in implementing mappings using Informatica .
  • Also implemented complex business rules by creating robust mappings, mapplets, and reusable transformations using Informatica Power Center.
  • Strong in Data warehousing concepts, Star Schema and Snowflake Schema methodologies.
  • Experience in optimizing query performance, session performance and fine tuning the mappings for optimum performance and resolving the bottlenecks in Source, Target, Transformations, Mappings and Sessions.
  • Experience in Slowly Changing Dimension Techniques
  • Have good experience with Informatica IDQ.
  • Proficient in using Informatica workflow manager, workflow monitor, pmcmd (Interactive, command line utility) to create, schedule, control workflows, tasks and sessions.
  • Used Debugger to test the mappings and get troubleshooting information about data and error conditions.
  • Efficient team player with excellent analytical, communication and interpersonal skills.
  • Ability to work in - groups as well as independently, well motivated to rapidly acquire new skills on the job and successfully implemented several projects.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5/ 8.x/7.x/6.x, Informatica Designer, Workflow Manager, Workflow Monitor, Repository Manager,IDQ

Business Intelligence: Business Objects

Databases: Oracle 10g/9i/8i, DB2 UDB, MS-SQL Server 2000/7.0, Microsoft Access.

Languages: C, C++, SQL

Web Technologies: HTML, JavaScript, VBScript, ASP 3.0, XML

Environment: UNIX, Windows NT 4.0, Win 95/98/2000/XP, MS DOS, IBM AS/400, IBM AIX.

PROFESSIONAL EXPERIENCE:

Confidential

Senior ETL Developer

Responsibilities:

  • Developed technical specifications of the ETL process flow
  • Designed the Source - Target mappings and involved in designing the Selection Criteria document.
  • Worked in Onsite-offshore model.
  • Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in SQLServer and Oracle.
  • Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different sourcesystems (SQL server, Oracle, Flat files).
  • Handled offshore team of 12 members having seniors and Juniors in the ratio 5:1
  • Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, SequenceGenerator and Normalizer.
  • Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
  • Used version mapping to update the slowly changing dimensions to keep full history to the target database.
  • Implemented sending of Post-Session Email once data is loaded.
  • Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
  • Used Debugger to test the mappings and fixed the bugs.
  • Tuned performance of mapping and sessions by optimizing source, target bottlenecks and implemented pipeline partitioning.
  • Worked with DBA for partitioning and creating indexes on tables used in source qualifier queries.
  • Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.
  • Scheduled various daily and monthly ETL loads using Control-M
  • Involved in writing UNIX shell scripts to run and schedule batch jobs.
  • Involved in unit testing and documentation of the ETL process
  • Involved in Production Support in resolving issues and bugs.

Environment: Informatica 9.5, Oracle 10g, Unix Shell scripts

Confidential

Senior ETL Developer

Responsibilities:

  • Requirement Gathering
  • Formulation of design strategy.
  • Used IDQ and have done Data cleansing.
  • Have majorly involved in preparing the Application Design for Landing to Staging.
  • Daily Co Ordination with the customer to ensure any update in the requirement is clearly conveyed to team members.
  • Review the Mappings, Workflows, Sessions.
  • Support for Defect fixes in CIT environment.

Environment: Informatica 9.5, Teradata, Unix Shell scripts

Confidential

ETL Developer

Responsibilities:

  • Requirements capture
  • Formulation of design strategy.
  • Preparation of HLD and LLD.
  • Designed the detailed ETL architecture, including agents, scenarios, packages, data mapping, data extractions, transformations and validations. ETL design and implementation include stand-alone and Java EE agents, ODI data services, ODI Console, ODI studio, and other appropriate development tools.
  • Assist infrastructure personnel to define and document the technical architecture that includes ODI, DRM.
  • Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets including Hyperion Planning, Essbase, Relational Database Management servers (including Oracle RDBMS, SQL Server, and IBM DB2), flat files (including CSV, Excel, & XML file formats), and web services (SOAP, WS-I Security).
  • Integrated ODI mappings and translations with Oracle Data Relationship Management (DRM) web services to support meta-data management approach to maintaining account and entity hierarchies.
  • Created the hierarchies using oracle DRM.
  • Created versions in DRM with different hierarchies and blended the data.
  • Export/Import data from DRM using the DRM migration modules.

Environment: Oracle 11g, OBIEE 11g, ODI 11.1.1.5, RTC, Linux

Confidential, Los Angeles, CA

Sr. ETL Consultant

Responsibilities:

  • Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
  • Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
  • Created salesforce External loader application and used this application to connect to salesforce.com.
  • Created Mapplets, reusable transformations and used them in different mappings.
  • Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
  • Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for clean up and update purposes.
  • Implemented parallelism in loads by partitioning workflows using Pipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
  • Validation of Informatica mappings for source compatibility due to version changes at the source.
  • Trouble shooting of long running sessions and fixing the issues.
  • Implemented daily and weekly audit process for the Claims subject area to ensure Data warehouse is matching with the source systems for critical reporting metrics.

Environment: Informatica PowerCenter/PowerMart 8, UNIX, Oracle.

Confidential, Los Angeles,CA

ETL Analyst

Responsibilities:

  • Informatica Designer tasks include creating mappings, mapplets and transformations and import of source and target metadata
  • Used complex data transformations in mapping.
  • Involved in performance tuning and resolving performance bottlenecks.
  • Identified and tracked the slowly changing dimensions/mini dimensions, heterogeneous sources and determined the hierarchies in dimensions
  • Used task developer in the Workflow manager to define sessions
  • Created reusable Worklets and mapplets and transformations
  • Responsible for monitoring all the sessions that are scheduled and involved in debugging the Mappings that failed
  • Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies
  • Scheduling and coordination of the Informatica tasks is done using UNIX cron and Perl scripts. Email and paging facilities are also utilized at key points in the process
  • Developed different types of Reports such as; Master/Detail, Cross Tab and Chart (for trend analysis) using Business Objects 6.5.1

Environment: Informatica PowerCenter/PowerMart 7,Business Objects 6.5.1 and Windows NT

Confidential

ETL Developer

Responsibilities:

  • Involved in Business Analysis and Requirements Gathering.
  • Designing and customizing data models for Data warehouse supporting data from different sources.
  • Developed and designed Datamarts Extensively using Star Schema.
  • Project life cycle - from analysis to production implementation, with emphasis on identifying the source and source data validation.
  • Designed, developed Informatica mappings, enabling the extract, data cleansing, transport and loading of the data into target tables.
  • Extensively used almost all of the transformations of Informatica including lookups, Stored Procedures, Update Strategy and others.
  • Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
  • Designed workflow, sessions and tasks using Workflow Manager and scheduled workflows .
  • Extensively worked on Informatica client tool Repository Manager to create Folders, Users and Groups.
  • Prepared Design documents to develop the Informatica mappings, Test cases to ensure the correctness and consistency of the data moved to the DDR.
  • Involved in fixing invalid mappings, testing of Stored Procedures and Functions, Unit test and Integration testing of Informatica Sessions, Batches and the Target Data.
  • Tested the data and data integrity among various sources and targets. Associated with Production support team in various performance related issues.

Environment: Informatica PowerCenter 6.1, Oracle 9i, Windows XP.

Confidential

ETL Developer

Responsibilities:

  • Worked closely with Project Managers, Business Analysts and Business Clients.
  • Involved in different Projects as a Business Objects Universe and Reports Developer for designing Universes to different Business Teams within the organization.
  • Built around 6 Universes for various applications required by different departments.
  • Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects universes and reports.
  • Designed, developed Informatica mappings, enabling the extract, data cleansing, transport and loading of the data into target tables.
  • Extensively used almost all of the transformations of Informatica including lookups, Stored Procedures, Update Strategy and others.
  • Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
  • Designed workflow, sessions and tasks using Workflow Manager and scheduled workflows .
  • Extensively worked on Informatica client tool Repository Manager to create Folders, Users and Groups.
  • Involved in Designing the universe by creating the Business Objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects which are grouped into classes. Created hierarchy and conditions at the designer level.
  • Utilized the feature of Derived Tables in Universe
  • Created Multi Dimensional analysis using Slice/Dice and Drill through methods to organize the data along a combination of “Dimensions” and “Drill-Down Hierarchies” giving the ability to the end-users to observe data from Heterogeneous viewpoints.
  • Migrated the Universes and the Reports between Development, Testing and Production Repositories
  • Created complex reports both in Business Objects 3 - Tier and Web Intelligence Java Report Panel like master/detail, drill down and cross tab using data from SQL server, Personal data files and Oracle.

Hire Now