We provide IT Staff Augmentation Services!

Etl Developer/informatica Resume

Omaha, NE

SUMMARY

  • 7 yearsof IT experience in System Analysis, Design, coding and testing of Data Warehousing implementations across Financial, Pharmaceutical, Insurance and Telecom Industries.7 yearsof IT experience in System Analysis, Design, coding and testing of Data Warehousing implementations across Financial, Pharmaceutical, Insurance and Telecom Industries.
  • Extensive experience in the fieldof Data Warehousing and on tools such as Informatica Power Center 9.1/8.6.1/8.1.1/7.1.1,PowerMart, Metadata Manager, IDQ, MDM, IDE, Power Connect for SAP/PeopleSoft/Oracle Apps/Siebel/DB2, Power Exchange, Autosys, Control M, Tidal, etc.
  • Expertise in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files, XML, COBOL files, etc.
  • Experience in Informatica Administration such as, creating users, folders, grant permissions, configuring parameters, deployment groups, configuring server settings for optimal performance, etc.
  • Proficient in performance tuning ETL processes, Informatica mappings, sessions, database, etc.
  • Extensive experience on Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
  • Highly experienced in Dimensional Data Modeling, Erwin 7.1/4.5/4.0/3.5.5/3.5.2, Ralph Kimball Approach, Star/Snowflake Modeling, and Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling, Power Designer and Oracle Designer.
  • Experienced in using Data Cleansing tools such as Trillium 7.6/6.5 (Converter, Parser, and Converter & Geo-coder), First logic 4.2/3.6, UNIX Shell Scripting and SQL coding.
  • Sound Knowledge inperformance tuningof data warehouse bottlenecks.
  • Experience in using Business Intelligence tools such as Cognos 7.0/6.0/5.x, Business Objects XI R2/6.5/5.1, etc. Developer 2000 (Forms 4.5/5.0, Reports 2.5/3.0), SQL Server Integration Server (SSIS), MS Access Reports.
  • Complete knowledge of data warehouse methodologies (Ralph Kimball, Bill Inmon), ODS, EDW etc.
  • Working knowledge of other integration tools such asSSIS, Data stage, Abinitio, etc.
  • Extensive experience using Oracle 10g/9i/8i, DB2 8.0/7.0/6.0, MS SQL Server 2005/2000/7.0/6.0, Teradata V2R5/V2R4/V2R3, Sybase 12.x/11.x, Netezza, MS Access 7.0/2000 database clients such asSQL server Management StudioandSQL Developer, SQL navigator, Toad, etc.
  • Individual driven by passion towards learning new things and working hard towards achieving goals.

TECHNICAL SKILLS

Data Warehousing

Informatica Power Center 8.1.1/7.1.2/7.1.1/7.1,Informatica Power Connect,Informatica Data Quality (IDQ),Informatica DataExplorer (IDE),Autosys, Control M, Siebel Warehouse 6.3, Siebel EIM, SQL*Plus, SQL*Loader, Tidal.

Data Analysis

Requirement Analysis, Business Analysis, detail design, data flow diagrams, data definition table, Business Rules, data modeling, Data Warehousing, system integration.

Dimensional Data Modeling

Dimensional Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 7.1/4.5/4.0/3.5/3.2, Oracle Designer, Power Designer.

  • BI Tools
  • Business Objects XI R2/ 6.5/5.1 (Web-Intelligence 2.5, Designer 5.0, and Developer Suite & Set Analyzer 2.0), SSIS, SSAS, Cognos Series 8.3/7.0.

Databases

Oracle 11g/10g/9i/8i/7.x, IBM DB2 UDB 8.0/7.0, MS SQL Server 2008/2005/ 2000/7.0/6.0, Teradata V2R6/V2R5/V2R4/V2R3, Sybase 12.x/11.x, MS Access.

Programming GUI

SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, Synopsis, Visual Basic .Net/6.0/5.0, Java, HTML, DHTML, C, C++,Unix Shell Scripting, PERL Programming

Environment

Sun Solaris 2.6/2.7/2.8/8.0/10, HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Win 3.x/95/98, Win NT, Red Hat Linux, Sun-Ultra, Sun-Spark, Sun Classic, HP9000, RS6000, Win 3.x/95/98, Win 2000, Win XP. MS-Dos

Professional experience

Confidential, Omaha, NE Sep 11 – Till Date
Role: ETL Developer/Informatica

Description:Confidential offers credit and debit card issuance and management services, transaction processing and merchant service management. The objective of this project is to consolidate the commission processes to an enterprise wide system and improve product and sales reporting. Callidus Software is the application chosen for this project as a result of an extensive selection process.
Responsibilities:

  • Initial analysis to automate and consolidate all sales compensation and reporting processes across NA into a single system. Analysis was also done across various sources to see if the data can be rolled up and if a master data repository can be build on product, merchant, client and etc.
  • Interact with the Business analyst, business users to understand the requirement and the kind of data that needs to be pulled in for compensation calculation.
  • Recommending file formats and defining pulling logic from various downstream system
  • Defining road map for Informatica mapping and design templates
  • Participating in weekly status call with FD IT and business sponsors
  • New Development and Maintenance of existing ETL code.
  • Performance tuning existing ETL processes, Mappings, Sessions and Database.
  • Worked on fixing PROD and TEST issues.
  • Basic Informatica Administration such as creating users, folders, permissions, optimizing server settings, configuring environment variables, deployment groups, etc.
  • Suggested indexes, views, materialized views, functions, procedures, database partitions, table level partitions, etc.

Contribution:
Performance tuned the ETL batch and reduced the batch processing time significantly.
Suggested best practices of ETL to the organization.
Wrote generic procedures that could be reused across the organization.
Environment:Informatica Power Center 9.1/8.6.1, Oracle 11g/10g, SQL Server 2005/2008, PL/SQL, TOAD, Flat Files, XML, Windows XP, UNIX, Remedy, Apex data loader

Confidential, Plano, TX Jan 11 –Aug 11
Role: ETL/Informatica Developer

Description:The requirement for this project is to provide Informatica Infrastructures support (Admin) as well as Informatica application enhancement. PepsiCo maintains around 39 applications for decision support system
Responsibilities:

  • Performed Upgrading Informatica Power center Version 8.x to Informatica Power center 9.X.
  • Analyzed the Change requests (RFC) and Business Requirement Documents (BRD) as per requests
  • Create, backup, restore for Informatica Repositories
  • Involved in migration of objects in all phases (DEV, INT and PRD) of project
  • Involving Testing, Debugging, Validation and Performance Tuning of data warehouse, help develop optimum solutions for data warehouse deliverables.
  • Designed dynamic SSIS packages to transfer data crossing different platforms, validate data and data clearingduring transferring, and archived data files for different DBMS
  • Created SSIS Packages to migrate slowly changing dimensions.
  • Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the data loading process.
  • Interacted with Business Analyst and user for requirement gathering and created High Level and Low Level design documents.
  • Suggested redesign of ETL processes and also re-architecture of existing ETL processes.
  • Worked as a Informatica/Data Warehouse Developer helping the team with production issues, enhancements and maintenance of existing code, as well as did an Informatica Administrator role.

Environment:Informatica Power Center 8.6.1, Power Exchange, SSIS, Cognos 8, Oracle 10g, Toad 9.5, SQL, XML, Flat Files, UNIX Shell Scripting, Flat files, Erwin 7.1, UNIX, Windows XP

Confidential, Towson, MD May 10 –Dec 10
Role: Sr. ETL Developer/Informatica

Description: Confidential is a leading provider of healthcare data management, analytics, decision support, process automation and related information technology solutions. The Early Retiree Reinsurance Program (ERRP) provides reimbursement to participating employment-based plans for a portion of the costs of health benefits for early retirees and early retirees’ spouses, surviving spouses, and dependents. The program was authorized in the Affordable Care Act.
Responsibilities:

  • To obtain the data about the customers from different systems and aggregate within the data warehouse usingInformatica
  • Worked with data modelers in preparing logical and physical data models and adding/deleting necessary fields using Erwin
  • Implemented populate slowly changing dimension to maintain current information and history information in dimension tables.
  • Worked on different data sources such asTeraData, Oracle, DB2, Flat files, etc.
  • Used UNIX korn shell scripts to load data from flat files intoTeraDataDevelopment and Production environments. Created UNIX scripts to pre-process the flat files before the Mload/FastLoad process
  • Created and scheduled jobs on Windows to extract data from Oracle, DB2, SQL Server and Excel using the utility OLELoad to load into Teradata.
  • Wrote DB2 stored procedures for implementing business rules and transformations.
  • Involved in the preparation of Technical design documents, Source to target (S2T) document, Review checklist and Program Specifications or Technical Specifications.
  • Developed and tested Store procedures, Functions and packages inPL/SQLfor Data ETL.
  • Prepared test cases and involved in unit testing of mappings, system testing and user acceptance testing.
  • Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 9.X/8.6.1,OBIEE, UDB DB2 8.1, Oracle 10g/9i, SQL, PL/SQL, XML, Cognos Series 8.3/7.0, MS Access, Windows 2003, UNIX, Business Objects 6.5,Solaris 10.

Confidential, MD (Health Care)Mar 09 – Apr 10
Role: Sr. ETL Informatica Developer

Description:Confidential is a global strategy and services consulting firm focused onEnterprise Data LifecycleManagement. Maricom helps its clients to give employers and unions a comprehensive set of options to help them continue to provide high-quality prescription drug coverage. One method is through a Retiree Drug Subsidy that is flexible enough to enable employers and unions to obtain the subsidy without disrupting their current coverage
Responsibilities:

  • Written documentation to describe program development, logic, coding, testing, changes and corrections.
  • Documented technical design documents based on the BRD and SRS.
  • Automated transformation of Unstructured (Spreadsheets, documents), semi-structured (HL7, SWIFT) and Complex structured (ACCORD XML) data done using Informatica Power Exchange.
  • Collect and link metadata from diverse sources into a center catalog and automatically connect to different data sources to accelerate the extraction and linkage of metadata usingMetadata Manager
  • Utopia lineage is inData Qualityand Data migration as such in all areas of data cleansing, standardization, consolidation and enrichment.
  • Knowledge in upgrading from Informatica version 7.1.4 to 8.6.0.
  • Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
  • Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
  • Created complex Cognos reports using calculated data items, multiple lists in a single report.
  • Prepared functional and technical documentation of the reports created for future references

Environment:Informatica Power Center 8.6.1/7.1.4, Oracle 10g/9i, SQL, PL/SQL, XML, Cognos Series 8.3/7.0, AS 400,SAP BW,MM, MS Access, Windows 2003, UNIX, UDB DB2 8.1, Business Objects 6.5

Confidential, NY (e-commerce)Jan 08– Feb 09
Role: ETL Developer
Description:Sovereign’s flagship product Transact is an e-commerce system for businesses seeking to power high-volume, high-transaction commerce websites. Transact is built on a scalable & flexible architecture that supports the entire Internet commerce cycle: comprehensive order management, fulfillment, payment, customer service, and reporting. The Data warehouse built for the Products helps to Manage Data, Customer and order Information and is helpful in creating Reports.
Environment:Informatica 8.1.1/8.5, Teradata V2R5/V2R6, Oracle 10g,Mercury Quality Center 9.0, SSIS, Cognos Series 8.3/7.0, Perl Wrapper Script, Star Team, Unix HP-UX.

Confidential, Chicago(Financial)Oct 06 – Dec 07
Role: ETL Developer
Description:Confidential is one of the leading banks in Chicago Area. The objective of the project is to provide timely, accurate and consistent sales information through data consolidation into anenterprise data store known as Operational Data Store (ODS). Data is then extracted from the ODS and transformed into various data marts such as Spending Report (SPR) data mart which is used to track total spending of different groups/departments.
Environment: Informatica PowerCenter 8.1.1/7.x (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Cognos Series 8.3/7.0, Teradata, Flat files, DB2, SQL server 2005, SSIS, SQL, PL/SQL,Win 2000.

Confidential Jan 06 – Sept 06
Role: ETL Developer
Description:Confidential is one of the largest banking sectors in India, and also preferred provider of banking services for target retail and wholesale customer segments. I worked as an ETL developer to put together the Data layer after the reporting requirements were completed.
Environment:Informatica Power Center 7.1,Business Objects 5.1/6.0, Designer, Supervisor, Broadcast Agent 5.1, UNIX shell scripting, Toad, Oracle 8i, MS SQL Server 2000, PL/SQL, Windows NT, Windows 2000

Confidential May 05 – Dec 05
Role: PL/SQL Developer
Description:Confidential has been in business since 1990 in Lebanon. This project was initiated to create a system, which will provide intelligent information reports regarding their existing business and helped analyze their business processes.
Environment:Oracle 9i, Windows NT, PL/SQL, Excel, SQL Server 2000, Erwin. Business Objects 6.5/5.1.

EDUCATION:Bachelor\'s (BTECH) in Information Technology

Hire Now