Resume of ETL Developer

Title
ETL Developer

Primary Skills
Informatica Designer Components: Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer.

Location
US-CO-Denver

Posted
Apr-07-07

PROFILE
* 3 1/2 years of total IT experience.
* 2 years of Oracle experience, 1 Years of Informatica experience.

EXPERIENCE SUMMARY

* Extensively worked on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
* Developed and supported Extraction, Transformation and Load process (ETL) using Informatica Power Center to populate the tables in Data warehouse and Data marts
* Extracted and transferred source data from different databases like Oracle, SQL SERVER, and DB2and flat file into Oracle.
* Proficient in SQL, PL/SQL, Procedures/Functions, Triggers and Packages in Oracle 9i
* Developed complex mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Source Qualifier, Stored Procedure transformation etc.
* Developed several reusable transformations and mapplets.
* Developed Slowly Changing Dimension Mappings of type I, II and III.
* Experience in Debugging and Performance Tuning of targets, sources, mappings and sessions.
* Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts, Stored Procedures and execution of test plans for loading the data successfully into the targets.
* Experience in Installation, Configuration, and Administration of Informatica Power Center/Power Mart on Client/Server environment.
* Handled large volumes of data warehouse database. Experience in writing UNIX shell scripts (Korn Shell/Bourne Shell), SQL*Loader, Performance & Tuning of Database, Backup and Recovery.
* Experience in Database Design, Entity-Relationship modeling, Dimensional modeling like Star schema and Snowflake schema
* Thorough understanding of Entire life cycle of Software and various Software Engineering Methodologies.
* Experience in Business Intelligence tools like Business Objects 6.5/6.0/5.1, Web Intelligence 2.5, Business Objects Designer, Business Objects Developer Suite (Broadcast Agent, Supervisor, Designer, Info View), Business Object Universe Developer, Business Objects Set Analyzer 2.0, Business Objects Reporting.
* Experience in Cognos Impromptu 7.0, Cognos Transformer, Cognos Power Play (Cognos Series 7 and Cognos 6.x).
* Knowledge on Reportnet 1.1.
* Diverse background with fast learning skills and creative analytical skills.
* Good communication skills, interpersonal skills, team coordination and versed with Software Development processes.


EDUCATION

Masters in Computer Science, UMES, MD

TECHNICAL SKILLS

ETL Tools: Informatica 5.1, 6.2, 7.1, Datastage 7.5

Reporting Tools: Business Objects 5.1,6.1,6.5 ,XI,Info View, Web Intelligence 2.6,6.0, Cognos Impromptu 7.1, Cognos Power play (Cognos Series 7 and Cognos 6.x), IWR, Cognos Transformer, Reportnet 1.1

Databases: Oracle 7.x/8i/9i/10g, SQL Server, DB2, MS Access 97/2000,
Teradata4.x/5.0

Languages: SQL, PL/SQL, C, C++, JAVA, PASCAL, COBOL, HTML

Data Modeling: E-R Modeling, Dimensional Modeling, and Star Schema, Snow
Flake Schema, Fact and dimension tables

Data Modeling Tools: Erwin 3.5.2/4.0/4.1

Operating Systems: Windows NT / 98 / XP / 2000 / Server 2000, UNIX, MS DOS, Sun Solaris 2.6/2.7

Other Tools: iSQL*Plus, SQL*Plus, SQL*Loader, TOAD, SQL Navigator 4.2, UML and MS Visio 2000

PROJECT EXPERIENCE
Great West Insurance, Denver, CO Dec'06 - till date
Informatica Developer

Great West Insurance Company serves more than 3.6 million Americans through a full range of managed healthcare, life and disability insurance, and retirement savings products and services. This system gives full information regarding benefits, plans offered by the company, educate people about diseases, prevention, ICD codes, HIPPA act and users can enroll and can avail the benefits offered. This project includes developing Data warehouse from different data feeds and other operational data sources.
Built a central Database where data comes from different sources like oracle, SQL server and flat files. Actively involved as an Analyst for preparing design documents and interacted with the data modelers to understand the data model and design the ETL logic. Reports were generated using Business Objects.

Responsibilities:
* Created new mappings and updating old mappings according to changes in Business logic
* Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
* Used ETL (Informatica) to load data from source to ODS.
* Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
* Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
* Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status
* Used Debugger to troubleshoot the mappings
* Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier
* Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
* Defined Target Load Order Plan for loading data into Target Tables
* Prepared Unit Test Cases.
* Generated various reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas as per client requirements
* Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies

Environment: Windows 2003, Oracle 9i, PL/SQL, Informatica Power Center 7.1.2, Business Objects 6.5, TOAD, Erwin 4.1

Biological E Limited, Hyderabad, India Sep'04- Jun'05
ETL Data Warehouse Programmer

Successfully developed and maintained ETL maps to Extract, Transform and Load data from various sources like Flat files, relational data and XML files into the Enterprise Data warehouse called Pharma Data Warehouse Management system. This includes creating and running scripts, loading data into Dimension tables, Fact tables. Data warehouse collects full life cycle data for Biological Pharmaceutical's products right from the new product introduction through its manufacturing, testing, shipping, and success and failure analysis. The data is used to make decisions for new product improvements, failure analysis of existing products, improve customer service. Various reports are generated using Cognos Impromptu reporting functionality such as slice and dice, drill down, sorting and filter for full reports.

Responsibilities:
* Documented business requirements, functional specifications and test requirements.
* Used Informatica PowerCenter 6.2 for extraction, transformation and loading (ETL) of data in the data warehouse.
* Implemented logical and physical data modeling with STAR and SNOWFLAKE techniques using Erwin in Data warehouse.
* Created Informatica Mappings with different transformations including Source Analyzer, Lookup, Filter, Expression, Rank, Aggregator, Stored Procedure, Look up Transformations and more.
* Developed mapplets, mappings and configured sessions.
* Created and monitored workflows and tasks using Informatica PowerCenter Work flow Manager.
* Worked Efficiently with Designer tools including Source Analyzer, Warehouse designer, Mapping and Mapplet Designer, Transformations.
* Extracted data from different sources like Oracle, SQL Server and Flat files implemented business logic and loaded into the target Warehouse (Oracle).
* Handled slowly changing dimensions type 1, 2 and 3.
* Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse (Oracle 8i).
* Created reusable transformations and mapplets to use in multiple mappings.
* Created different types of reports, such as; Master/Detail, Cross Tab and Chart (for trend analysis). Use of Prompts, filters, conditions, calculations, slice and dice etc.
* Created Cubes using Cognos for pulling the data for online reporting and Analysis.
* Used Cognos Impromptu and IWR for designing and creating Queries and Reports
* Involved in Performance testing of all the reports, which helped in analyzing its performance before moving into production.

Environment: Informatica PowerCenter 6.2, Cognos 7.1, Oracle 8i, SQL, PL/SQL, Windows NT

APTS, Hyderabad, India May'03-Mar'04
Oracle Developer

Involved in the development of the project called Attendance recording system that integrates with and extends the functionality of access control mechanism and the associated software. While the card reader based access control system logs all door transactions and implements present time zones and access levels to the office, the attendance recording system facilitates import of these raw transactions via text files, implementing the office rules. This system also facilitates database loading, maintenance backup and a powerful report generation feature.

Responsibilities:
* Created schemas, tables, views and appropriate indexes on table columns at database level.
* Imported data from text files using SQL* Loader into oracle database tables.
* Involved in developing optimized code using PL/SQL for Server related Packages to centralize the application through procedures, functions and packages.
* Different database triggers containing PL/SQL were created and stored in the database and fired off when contents of database were changed.
* Created users and roles and implemented security at multiple user levels by allocating a certain role to a specific hierarchy of employees.
* Developed report to retrieve employee's attendance details.
* Developed "performance evaluation reports" for of the employees with different parameters like Day wise, Month wise, Department wise and Designation wise.
* Interacted with the client on a regular basis for project specifications.
* Involved in training the employees in Oracle database.

Environment: Oracle 8i, SQL, PL/SQL, SQL *Loader, TOAD, Windows 2000.

GE, Bangalore, India. May'02-Apr'03
Oracle Developer

Indentation for sales, this project is designed to promote the sales for the organization. Every quarter company will set a target for each sales unit. Based on the target they will manufacture their product. The aim of the project is to handle the additional requirements comes from their client. If the additional requirements come by the bottom level sales unit, it goes for some authority to validate it and that authority should give the confirmation ,then only it will go for purchase department to Purchase the raw material to handle the additional requirements.

Responsibilities:
* Created, monitored and maintained Oracle databases.
* Created Table spaces for Data and Indexes.
* Created Tables, Indexes, Sequences, Clusters, Triggers, Procedures, Functions and Packages.
* Re-organized databases and managed the databases for optimum performance levels.
* Wrote database scripts for user management and roles.
* Provided On-call support
* Configured ODBC connectivity for new instances and clients.
* Formulated optimization strategies based on performance cost and rules.
* Managed Rollback Segments, Log Files, Control Files
* Performed SQL query optimization using hints, Indexes and Explain plan.
* Wrote PL/SQL Scripts for DDL operations such as to create alter and drop database objects like tables, views, sequences, procedures and functions.
* Created materialized views to increase the speed of queries
* Wrote stored procedures and functions to retrieve the data from database using PL/SQL.
* Different database triggers containing PL/SQL were created and stored in the database and fired off when contents of database were changed.
* Designed various complex reports using Crystal Reports.

Environment: Oracle 8i, PL/SQL, SQL *Loader, TOAD, Java, Windows 2000.

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-CO-Denver »
View all resumes in US-CO »

View other ETL Developer resumes, Database Administrator resumes