Data Warehouse Resumes
s
SUMMARY;
- 8+ years of experience in developing and maintaining Software applications, of which 7+ years of strong experience in designing and implementing Data Mart / Data Warehouse applications using ETL tools INFORMATICA Power Center 9.1.0,8.6.1,8.5, 8.1.2, 8.1.1,7.1.1/6.2 (Designer / WorkFlow Mgr.) and PowerMart to transfer the data from legacy systems (Mainframes) to common/ different targets and Oracle PL/SQL.
- Experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
- Experience in Debugging and Performance Tuning of targets, sources, mappings and sessions.
- Proficient in using Informatica Workflow manager, Workflow monitor, pmcmd (Informatica command line utility) to create schedule and control Workflows, tasks and sessions.
- Extensively worked on database applications using DB2 UDB, Oracle, SQL*Plus, PL/SQL, SQL*Loader.
- Experience in modeling Transactional Databases and Data Warehouses using tools like Erwin and ER/Studio.
- Experience in developing logical and physical models and implementing them in Oracle.
- Excellent skills in retrieving/manipulating data by writing simple/ complex SQL Queries and optimizing SQL and PL/SQL
- Experience in integrating data from various sources Oracle, DB2 UDB, Sybase, Teradata.
- Experience in creating entity relational & dimensional relational data models with Kimball Methodology (Star schema and Snow flake schema architectures, Fact/dimension tables)
- Documented design procedures, operating instructions test procedures and troubleshooting procedures
- Experience in almost all Teradata tools which includes Teradata Statistics Wizard, TSET, Index Wizard, Visual Explain, PMON, Teradata Administrator and SQL Assistant and strong working experience in Teradata utilities such as TPT, Mload, Bteq, Fastexport, Fastload, Tpump, Winddi, Queryman etc, which includes usage of ERWIN and VISIO2000
- Taking part in planning and carrying out Teradata system upgrade initiatives, Data Warehousing, MPP and Large - Scale Database Management
- Expertise in Teradata, Oracle, ETL tools, Data Access methods, SQL, PL/SQL, UNIX shell scripting
- Expertise in ODBC, OLEDB, Stored Procedures, Triggers.
- Worked with data cleansing and Data mining.
- Experience in working with Business Objects modules Supervisor, Designer, BO Reports,
- Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.
- Solid time management and multitasking skills, which help in conducting project meetings, reviews, walkthroughs, and customer interviews according to the varied needs of the people involved
- Excellent written and oral communication skills and a team-player with a results-oriented attitude
TECHNICAL SKILLS:
ETL Tools: Informatica (Power Center 9.1.0, 8.6.1, 8.5, 8.1.2, 8.1.1, 7.1.1, 6.2 /5.1 and Power Mart 6.2 / 6.0 / 5.1)Power Exchnage8.5/8.6.1/striva5.0
Data Bases: Oracle 10g/9i/8i/8.0/7.0, MS SQL Server 2000, DB2, UDB,MS Access 97/2000, Sybase, Teradata V2R3.
BI Tools: BusinessObjects5.1/5.0,COGNOS. Data Modeling, Erwin 3.5/4.0
Operating System: Windows 98/NT/2000/XP, UNIX (Linux, HP-Unix, Solaris)
Other Software: TOAD 11.0.0.116, MS Office, MATHCAD 2000 professional, MS Visio, Autosys.
PROFESSIONAL EXPERIENCE:
Senior ETLInformatica Developer
Confidential
Responsibilities:
- Developed various Mappings with the collection of all Sources, Targets, and Transformations using Designer.
- Analyzing the need and fitment for MDM Hub in the typical enterprise application ecosystem of company.
- Extensively usedTeradataUtilities (e.g., TPT, Multiload, Fastload, BTEQ and Fastexport) to extract and transform data from the operational sources to load into data warehouse.
- Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle RDBMS in accordance with requirements and specifications
- Designed and developed, mapplets and re-usable transformations, and used them in different mappings.
- Involved in complete life cycle of MDM implementations onInformaticaMDM 9.1.0 from Siperian XU SP2.
- Responsible for GAP Analysis to help identify current and proposed structure of MDM system.
- Helped in ETL process to load data into landing tables of MDM Hub usingInformatica9.1
- Conducted performance tuning, monitoring and index selection using PMON,TeradataDashboard, Statistics wizard and Index wizard. UsedTeradataVisual Explain to see the flow of SQL queries to make the join plans more effective and fast (e.g., single table or multi-table join indexes).
- Used Debugger to test the data flow and fix the mappingsPerformed unit testing and integration testing from source to target.
- Worked with Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter, Sequence Generator, Union, etc
- Defined foreign-key relationships, lookups, query groups and queries.
- Defined the landing tables, staging tables, and configured base objects.
- Developed mapping parameters and variables as per the requirement
- Created Workflows in the Workflow designer and executed tasks such as Sessions, Commands, etc. And Monitored transformation processes using Workflow monitor
- Involved in performance tuning of theInformaticamapping and identifying the bottlenecks.
- Created Sessions/Batches inInformaticaserver manager to execute mappings.
- Involved with data Steward Team for designing, documenting and configuring IDD.
- Closely worked with the reporting team to ensure that correct data is presented in the reports.
ETL Informatica Developer
Confidential
Responsibilities:
- Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
- Proficiently managed and created folders for ETL development using the Repository Manager module of the Informatica Power Center.
- Developed GE (aviation) Service Enterprise Data Warehouse (SEDW) Physical data model and created tables, views and indexes on Teradata Databases to integrate data from business units onto a single platform for decision support and OLTP.
- Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle 9i RDBMS in accordance with requirements and specifications.
- Extensively used various transformations Lookup, Update Strategy, Expression, Aggregator, Filter, Stored Procedures and Joiner etc.
- Performed Unit Testing and tuned the mappings for better performance.
- Created reusable transformations and mapplets.
- Developed and Monitored Tasks and Workflows using Informatica Workflow Manager
- Used various transformations like update strategy, expression, aggregator, joiner, source qualifier, router, lookup, and filter to create complex mappings
- Extensively used Control M for scheduling the Informatica workflows
- Wrote shell scripts to perform pre-session and post-session operations
- Writing PL/SQL procedures days of supply for processing business logic in the Database.
- Worked on SQL tools like TOAD to run SQL queries to validate the data.
- Worked on database connections, SQL Joins in Database level.
- Extensively used SQL*Loader to load Data from flat files to Database tables In Oracle.
Environment: Informatica Power Center 8.6.0, Informatica Workflow Manager, Oracle 10g, DB2, SQL, PL/SQL, TOAD, Flat files, Control M, Windows NT.
Informatica Developer
Confidential
Domain: Pharmacy/Healthcare
Responsibilities:
- Worked with the Business analysts for requirements gathering and project coordination.
- Design and Development of data validation and load processes (using PL/SQL, SQL) and pre-session, post-session routines and batch execution routines using UNIX Shell Scripts.
- Logical and Physical Data Modeling (relational and multi-dimensional) using ERWIN and used Power Plug to forward engineer toInformaticaRepository.
- Implemented slowly changing dimensions.
- Involved in Data Extraction from Oracle and Flat Files using SQL Loader.
- Design and Development of ETL routines usingInformaticaPower Center 8.1. Within theInformaticaMappings, usage of Lookups, Aggregator, Ranking, Mapplets, connected and unconnected stored procedures / functions, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done.
- Performance Monitoring and tuning of SQL using explain Plans and Oracle Hints and tuning ofInformaticamappings using SQL overrides and source filters and managing cache file allocations and sizes.
- Extensively used SQL*Loader to load data from flat files to database tables in Oracle.
- Developed and tested all theInformaticaData mappings, sessions and workflows involving several Tasks.
- Created UNIX scripts for setting up automated workflows and also for scheduling batches.
- Developed PL/SQL Procedures and SQL queries in Oracle Database and Mapping parameters.
Environment:InformaticaPower Center 8.1, Oracle 10g, UNIX, Teradata, UNIX Shell Scripts, PL/SQL, SQL, SQL Loader, TOAD.
Confidential
Sr Informatica Developer
Responsibilities:
- Worked with Business Analysts team in requirements gathering and in preparing Functional specifications and technical specifications.
- Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
- Worked with XSD’s and generated multiple complex XML target file with the Naming conventions.
- Defined and managed data maps, capture registrations and extraction maps for the data sources in Navigator to extract bulk data and capture change data.
- By using Power Exchange created fixed width and varying length VSAM files generated on AS 400 with header and footer.
- Using the COBOL copybook, VSAM files with comp fields data and loaded the data in SQL server
- Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
- Participated in phases design, coding, testing, and documentation.
- Worked on Debugging, Troubleshooting & documentation of the application layer.
- Tuning of SQL queries in SQL overrides for better performance.
- Worked on Debugging, Troubleshooting & documentation of the application layer.
- Responsible for mapping migration, metadata maintenance and Security using repository manager.
- Used PMCMD, PMREP and UNIX shell scripts for workflow automation and repository administration.
- Used PVCS for version control.
Environment: Informatica Power Center 8.6.0,Power Exchange 8.6,Power exchange navigator, UNIX, Oracle 10g, SQL Server 2005, UNIX AIX, Erwin 4.0/3.5.2, TOAD 8.6.1.0.
Confidential
Sr Data warehouse Developer, San Francisco, CA.
Responsibilities:
- Interacting with Facets & Rosetta SME's to understand the business model.
- Understanding the existing R2 & R3 Rosetta data marts, Extracting Facets application data and loading to existing R2 & R3 marts for reporting purpose.
- Reading the data from the FACETS and Rosetta IA data model then written Mapping documents and ETL technical Specification documents for program development, logic, coding, changes and corrections.
- Designed and developed Informatica Mappings, Sessions and Workflows Mapping documents and ETL technical Specification documents and business rules to load data from FACETS to Rosetta IA data model.
- 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, Router Transformation and Normalizer Transformation in Informatica.
- Developed Mappings for loading data from Multiple Sources (VSAM files and oracle table) into Rosetta IA tables.
- Responsible for writing unit test cases and performing the unit test and Involved in tuning the Session and Workflows for better performance.
Environment: Informatica Power Center 8.6, UNIX, Oracle 10g, FACETS 4.5, UNIX AIX, Erwin 4.0/3.5.2, TOAD 8.6.1.0.
Confidential ( Confidential )
Sr Programmer Analyst
Responsibilities:
- Reading the data from the FACETS and HpXr data model then written ETL Functional Design documents and ETL technical Specification documents for program development, logic, coding, changes and corrections.
- Worked with FACETS, Facets are extended enterprise of Confidential 's solution to assist payer organizations in staying ahead of trends in the employer benefits market.
- HpXr uses the accelerator to develop a customized base to do operational reporting, feed downstream databases, or integrate into an existing reporting environment.
- Assisted in installing Power Center on Client for Development, Test and Production Environments.
- Responsible for writing unit test cases and performing the unit test and Involved in tuning the Session and Workflows for better performance.
- Used PMCMD, PMREP and UNIX shell scripts for workflow automation and repository administration.
- Used PVCS for version control and AutoSys for Job scheduling.
- Participated in status review team meetings.
Environment: Informatica Power Center 8.6, UNIX/Windows 2000, SQL Server 2005, Oracle 10g, FACETS 4.5, HpXr.
Confidential (Now acquired by ‘ Confidential ’)
Sr Informatica Developer
Responsibilities:
- Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
- Parsing high-level design specs to simple ETL coding and mapping standards.Designed mapping document, which is a guideline to ETL Coding.
- Created Mappings to move from Various Systems into the Data Warehouse.
- Worked on Informatica tool -Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations.
- Created different Transformations for loading the data into target like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
- Created reusable transformations and Mapplets to use in multiple mappings.
- Performed Reverse Engineering of the legacy application using DDL scripts in ERwin, and developed Logical and Physical data models for Central Model consolidation.
- Worked with DBAs to create a best fit Physical Data Model from the Logical Data Model using ERwin.
- Worked with data cleansing and Data mining using Informatica data quality plug ins.
- Writing Stored Programs (Procedures & Functions) to do data transformations and integrate them with Informatica programs and the existing application.
- Worked on Parameterize of all variables, connections at all levels in UNIX.
- Used PMCMD, PMREP and UNIX shell scripts for workflow automation and repository administration.
- Used PVCS for version control and AutoSys for Job scheduling.
- Used workflow Manager for Creating, Validating, Testing and Running the sequential and concurrent Batches and Sessions, and scheduled them to run at a specified time.
- Used mapping parameters and variables.
- Worked on Parameterize of all variables, connections at all levels in Window NT.
Environment: Informatica Power Center 8.5, Workflow Manager, Workflow Monitor, SQL Server 2005, Power Exchange CDC, UNIX AIX, Erwin 4.0/3.5.2, TOAD 8.6.1.0, PL/SQL, Flat files, XML, Oracle 10g/9i/, Teradata V2R3, UNIX.
Confidential
Programmer Analyst
Responsibilities:
- Parsing high-level design specs to simple ETL coding and mapping standards.Designed Mapping Document, Detail Design Documents, Install and Release documents which is a guideline to ETL Coding.
- Designed and developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
- Used transformations like Connected and Unconnected Lookups, Aggregator, Joiner, Update, Router and Sequence generator.
- Worked with various Informatica Power Center tools - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, Transformations.
- Created reusable transformations and Mapplets and used them in complex mappings.
- Fine tuned Transformations and mappings for better performance.
- Developed and scheduled Workflows using task developer, worklet designer and workflow designer in Workflow manager and monitored the results in Workflow monitor.
- Used workflow Manager for Creating, Validating, Testing and Running the sequential and concurrent Batches and Sessions, and scheduled them to run at a specified time.
- Wrote PL/SQL stored procedures using Toad.
- Did performance tuning at source, transformation, target, and workflow levels.
- Created Shortcuts, reusable transformations and Mapplets to use in multiple mappings.
- Assisted in installing Power Center on Client for Development, Test and Production Environments.
- Migrated mappings from Development to Testing and to Production.
- Performed unit testing and Involved in tuning the Session and Workflows for better performance.
- Participated in status review team meetings.
- Worked with FACETS, Facets are extended enterprise of Confidential 's solution to assist payer organizations in staying ahead of trends in the employer benefits market.
- Facets e2 encompasses sophisticated technology that automates work process, reduce costs and simples the process of navigating through a health care delivery system. Facets eBusiness Suite products (eQuote, eEnroll, eService and eBill) provide real-time direct access to a health plan's back office information, made possible via Internet. Facets e2 is also fully compliant with HIPAA.
- Worked with Harwest to promote Packages.
Environment: Informatica Power Center 7.1.4, Workflow Manager, Workflow Monitor, FACETS 4.5 Erwin 4.0/3.5.2, TOAD 8.6.1.0, PL/SQL, Flat files, Oracle 9i.
Confidential
ETL Developer
Responsibilities:
- Analysis of Source, Requirements, existing OLTP system and Identification of required dimensions and facts from the Database.
- Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
- Parsing high-level design specs to simple ETL coding and mapping standards. Designed Mapping document, which is a guideline to ETL Coding.
- Extensively used Informatica to load data from Flat Files to DB2.
- Created mappings using the transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, and Stored procedure transformations
- Worked with various Informatica Power Center tools - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, Transformations.
- Created reusable transformations and Mapplets and used them in complex mappings.
- Fine tuned Transformations and mappings for better performance.
- Used (striva Power Connect) power Exchange to connect with Mainframes and creating 800 byte files.
- Worked with cobal programs to retrieve the Data from MainFrames.
- Used Informatica Designer to design mappings, extracting data from DB2 instance, flat files, that were delivered to Decision Support System, DSS
- Writing Stored Programs(Procedures & Functions) to do data transformations and integrate them with Informatica programs and the existing application
- Used workflow Manager for Creating, Validating, Testing and Running the sequential and concurrent Batches and Sessions, and scheduled them to run at a specified time.
- Created Shortcuts, reusable transformations and Mapplets to use in multiple mappings.
- Assisted in installing Power Center on Client for Development, Test and Production Environments.
- Migrated mappings from Development to Testing and to Production.
- Performed unit testing and Involved in tuning the Session and Workflows for better performance.
- Participated in status review team meetings.
Environment: Informatica Power Center 7.1.1, Workflow Manager, Workflow Monitor, Erwin 4.0/3.5.2, TOAD, PL/SQL, Flat files, Cobol/400, DB2 UDB, Power Exchange (Striva 5.0 power connect).