Sr. DW Informatica Developer Resume
|Desired Industry: Information Technology
|Desired Job Location: NYC, New York
||Date Posted: 7/24/2006
|Type of Position: Contractor
||Availability Date: 07/24/2006
|Desired Wage: $60/Hr C2C
||U.S. Work Authorization: Yes
|Job Level: Management (Manager, Director)
||Willing to Travel: Yes, 50-75%
|Highest Degree Attained: Bachelors
||Willing to Relocate: Yes
6+ years of IT experience in Software Analysis, Development, Implementation of business applications for Pharmaceutical, Financial, Insurance and Telecom verticals.
5+ years of ETL and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter 7.1/6.2/5.1 and PowerMart 6.2/5.1 using Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor.
Experience in Business Documentation especially in the Pharmaceutical Industry, Financial Industry, Insurance and Telecommunications Industry.
Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
Experience in Performance tuning of targets, sources, mappings and sessions.
Experience in integration of various data sources like Oracle, DB2, SQL server and MS access into staging area.
Hands on experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
Expertise at Enterprise Database Integration and Management among MS SQL Server, Oracle, MS Access, Teradata.
Strong experience in validation of Pharmaceutical Applications based on PDMA regulations.
5 years experience using Oracle 9i/8i/7.x, MS SQL Server 2002/7.0/6.5, SQL Server 12.0/11.x, Teradata V2R5/V2R4, MS Access 7.0/2000, SQL, PL/SQL, SQL*Plus, Sun Solaris 2.x.
Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
Excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations, and business rules.
Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.
Johnson & Johnson, NJ Sr. DW Informatica Developer Jun05-current
Johnson & Johnson is one of the Leading pharmaceutical industries in the United States. The main objective of Contract Sales System Data Mart is to support Sales Representatives with Physicians and Hospitals contract information. Sales, Marketing & Contract information was collected from different tests conducted on the subjects. Data mart helps build Monthly sales report for every Professional or Organization in contract.
Requirement gathering and Business Analysis.
Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.
Reviewed source systems and proposed data acquisition strategy.
Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
Designed the Data Mart defining Entities, Attributes and relationships between them.
Analyzed IMS Data using IMS tools such as Xponent and Xponent Plantrak, regarding segmentation & profiling.
Extensively used IMS Data component Xponent to get and send the encrypted data over the network.
Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
Extensively used Power Center/Mart to design multiple mappings with embedded business logic.
Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
Created Mapplet and used them in different Mappings.
Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
Performance tuning using round robin, hash auto key, Key range partitioning.
Used shell scripts for automating the execution of maps.
Designed and developed Oracle PL/SQL scripts for Data Import/Export.
Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
Designed and Deployed UNIX Shell Scripts.
Managed Change control implementation and coordinating daily, monthly releases and reruns.
Environment: Informatica Power Center 7.1, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Power Analyzer, IMS Data (Xponent, Xponent Plantrak, DDD), Maestro, PL/SQL, Oracle 10g/9i, Erwin 4.5/4.0, DB2 8.0, SQL Server 2005/2000, HP-UX 10.20, Windows Server 2003, Oracle 10g/9i, UNIX, Toad, Visual Source Safe (VSS).
Wells Fargo, IA Informatica ETL Developer Jan 04 - May 05
Wells Fargo is one of the nations leading Insurance providers, which offer a variety of products and services including life insurance, property, auto, business and home insurance. The primary objective of the project was to make a data warehousing system out of life insurance customers having different insurance policies.
End-to-end ETL development of the Premium Module Data Mart.
Maintained warehouse metadata, naming standards and warehouse standards for future application development.
Parsing high-level design spec to simple ETL coding and mapping standards.
Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting.
Used windows Scripting and Scheduled pmcmd to interact with Informatica Server from command mode.
Understand the business needs and implement the same into a functional database design.
ETL Migration process from legacy scripts to Informatica Power Center 5.2.
Designed and developed UNIX scripts for creating, dropping tables which are used for scheduling the jobs.
Data Quality Analysis to determine cleansing requirements.
Designed and developed Informatica mappings for data loads.
Extensively used Erwin for data modeling and Dimensional Data Modeling.
Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
Extracted data from Sales department to flat files and load the data to the target database.
Tuning Informatica Mappings and Sessions for optimum performance.
Created and maintained several custom reports for the client using Business Objects.
Generated reports using BO tools querying database.
Created List Reports and Cross Tab Reports and Drill Through reports.
Created standard and Ad hoc reports using Business Objects.
Environment: Informatica PowerCenter 6.2 (Source Analyzer, Data warehouse designer, Mapping Designer, Mapplet, Transformations, Workflow Manager, Workflow Monitor), Teradata V2R5, Business Objects XI/6.5, Erwin 3.5, PL/SQL, Oracle 8i/7i, DB2, Windows 2000, HP-UX, AIX 4.3.3, Shell Scripting.
B.S., Electrical Engineering
Michigan Technological University, Houghton, MI
Data Warehousing Informatica PowerCenter 7.1/6.2/5.1/4.7(Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplet, Transformations, Workflow Manager, Workflow Monitor, Worklets), Informatica PowerMart 6.2/5.2/4.7, Informatica PowerConnect, Test Director 8.0, Data cleansing, OLAP, ROLAP, MOLAP, Autosys, Control M, Star Schema, Snowflake Schema, OLTP, SQL*Plus, SQL*Loader, DTS Package.
Data Modeling Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.0/3.5.2/3.x, Oracle Designer, PL/SQL Developer 5.1.4.
Front-end tools TOAD 7.x, SQL Navigator 7.x, Eclipse 7.x, Visual studio 6.0.
Databases Oracle 9i/8i/8.0/7.0, MS SQL 7.0, SQL Server 2000, MS Access 7.0/97/2000, Teradata V2R5/V2R4.
BI & Reporting Tools Business Objects XI/6.0/5.1 (Web-Intelligence 2.5, Designer 5.0, and Developer Suite & Set Analyzer 2.0) Data Reports, SAS, Developer 2000, MS Access Reports.
GUI Visual Basic 5.0/6.0, Oracle Forms 6.0, Oracle Reports 6.0, VC++, MS Excel-VBA Macros, MS Word (VBA) Macros, FrontPage 97/98/2000, Visio.
Programming SQL, PL/SQL, ANSI SQL, Transact SQL, SQL*Plus 3.3/8.0, Java 1.4, HTML, DHTML, C, C++, UNIX Shell Scripting.
Environment HP-UX11/10/9, IBM-AIX 4.3/4.0/3.1, Sun Solaris 9/8/7/2.6/2.5, AS/400, SCO-UNIX, LINUX, Windows 95/98/2000/XP, WinNT4.0, MSDOS 6.22.
Candidate Contact Information:
|JobSpider.com has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response.