Data Manager
Resume:
[pic]
Vick S
Email: ****.******@*****.***
Certification:
Informatica Certified Consultant
Professional Summary:
> Data Warehousing Developer having over 10 years of experience in
Analysis, Design, Development and Implementation of major software
Applications and Business Intelligence projects under different
environments.
> Nine years of strong experience in using ETL (Extraction, Transformation,
Loading) utilizing Informatica 9.1, 8. 6 /7.1/6.2 (Power Mart/Power
Center), OLAP Tools such as Business Objects 5.1.4 (Designer, BO), Web
Intelligence 2.6/2.7 and Hyperion.
> Strong Knowledge on Bill Inmon and Ralph Kimball methodologies.
> Knowledge in designing and developing Data marts, Data warehouse using
multi-dimensional Models such as Snow Flake and Star Schema.
> Working Knowledge in using data modeling tools like Erwin, for major
databases.
> Expertise in Installing, Configuring and Administration of Informatica
products.
> Responsible for all activities related to the development,
implementation, administration and support of ETL processes for large-
scale data warehouses using PowerCenter and PowerMart.
> Configured and Administered the Repository Manager, Workflow Manager and
granted user privileges to access the Informatica Objects.
> Working knowledge on Informatica B2B.
> Working knowledge of PowerExchange.
> Database experience in Salesforce.com, Sybase, DB2, Oracle7.3/8x/9i/10g,
SQL Server7.0, and PL/SQL (Stored Procedures, Functions, Triggers).
> Good understanding and knowledge of Database Administration activities
like Installation and Creation of database, database objects, backup &
recovery.
> Extensive experience with ETL performance evaluation and tuning.
> Good exposure with UNIX, Linux, Sun Solaris, Windows NT/2000/XP and .NET
Server operating systems.
> Excellent communication and interpersonal skills.
> Able to manage changing responsibilities and deliver time critical
projects on schedule.
Skills:
RDBMS Salesforce.com, Sybase,Oracle 11i/10g/9.x/8i, SQL Server
2008, MS Access 7.0, DB2 8.0, DB2 Mainframe
ETL Tools Informatica Power Center 9.5,8.6/7. 1/6.2, Pentaho 3.2,
Data Junction 7.0
OLAP Business Objects Developer Suite 5.1/6.0(Designer,
Reporter, Supervisor) WEBI 2.5/2.6/6.0, Hyperion EAS 7.1.3,
Hyperion Excel Add-in, Inetsoft.
Operating MS-DOS, Linux, UNIX, Windows XP/ NT/2000/ME, Sun Solaris
Systems
Data Modeling Erwin4.0
Data Exchange B2B- Data Transformation Studio 8.6.1
Tools
Languages/Utilit VB 6.0, C, C++, XML, XSL, PL-SQL, FORTRAN, Robo FTP
ies
GUI Tools Visual Studio 5.0/6.0 and Developer 2000
Protocols TCP/IP, FTP, HTTP
Web Technologies HTML, DHTML, JavaScript
Software Tools TOAD, SQL Navigator, AQT, WSQL
Version Control Informatica Versioning, PVCS
Appreciation Received:
1. Received Bravo award for implementing Zycus project in CARLSON.
2. Received Bravo,' Work Smarter, Not Harder' for helping MDM (Master
Data Management) to resolve data issues in CARLSON.
3. Received Q1 2008 Partner award for 'Build the Team' from ESS
(Enterprise Strategic Sourcing) in CARLSON.
Work Experience:
SENTRY INSURANCE, WI
SEP12- PRESENT
SR Informatica Developer/ Data Analyst:
Sentry Insurance is one of the largest and strongest mutual insurance
companies in the US with assets of $11 billion and a policyholder surplus
of more than $3.3 billion.
The Purpose of the project is to move Billing ODS (Operational Data Store)
into the BP Policy ODS to allow integration of data into a single database,
which decreases the number of data asset and decrease maintenance cost.
Responsibilities:
> Create mapping design/technical documents.
> Work with Architect in analysing tables and data.
> 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.
> Logged defects, fixed and closing defects in HPQC.
> Provided development support for analysis, functional testing, load
testing, and user acceptance testing.
> Completed the implementation of requirements to meets the SLA's.
> Implemented Slowly Changing Dimensions - Type I, II & IV in different
mappings as per the requirements.
> Work with the business analysts and customers in gathering requirements.
> Documented detailed test cases and also reviewed test cases from other
team members.
Environment: Informatica PowerCenter 9.5, HPQC 9.2, Oracle 10g, SQL Server
2008, SQL Server Management Studio, SQL, Shell Scripts,Flatfile, MS Visio /
Office 2008
CARDIAC SCIENCE, WI (Server move support )
JULY12- AUG12
Data warehouse Developer:
Cardiac Science is global medical device company and a subsidiary of Opto
Cardiac Care Ltd. Cardiac Science serves customers in more than 100
countries, providing healthcare professionals, emergency responders, and
the general public with some of the most dependable products and services
in the industry.
This project is to support and maintain the server move from Washington to
Wisconsin.
Responsibilities:
> Actively updated and maintained Standard ETL Operating Procedures.
> Maintain and make any changes to the tables based on the requiments.
> Worked as Admin for the Inetsoft in creating users, giving permissions
and moving reports for the users.
> Worked with the testers closely to debug and fix any issues found.
> Worked on stored procedures and update the stored procedures based on the
requirements.
> Support the loads after go live and fixing errors with the data.
> Worked on moving the ETL code on to new enviroments and implemented the
code to run on new database.
> Assist in developing technical assessments of current and proposed work
units.
> Tuning of SQL queries for better performance.
> Completed the implementation of requirements to meets the SLA's.
> Document software designs and code changes.
Environment: Pentaho 3.2, Inetsoft,SQL server,Shell Scripts,
Unix,Flatfile, MS Visio / Office.
AON HEWITT, IL
MARCH 12- JUNE12
Sr Informatica Developer
Aon plc is leading global provider of risk management services, insurance
and reinsurance brokerage, and human resource consulting and outsourcing.
I worked in IT Benefits group and involved in developing process to gather
data from external clients and load into the internal system.
Responsibilities:
> Created new mappings and updating 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 & IV 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 and Source Qualifier.
> Supporting the loads after go live and fixing errors with the data.
> Loaded data to Salesforce.com using Informatica.
> 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.
> Developed schedules to automate the update processes and Informatica
sessions and batches.
Environment: Informatica PowerCenter 9,Oracle 10g, DB2,AQT,
Salesforce.com,SQL, Shell Scripts, Control M, Business Objects,
Unix,Flatfile, MS Visio / Office.
DEAN HEALTH PLAN, WI
SEP 11-FEB12
Sr Informatica Developer
Dean is one of the largest integrated healthcare delivery systems in the
country. Dean provides medical and health services through a network of
Dean or St.Mary's/Dean-owned clinics throughout southern Wisconsin. I
worked on the Medical Claims Interfaces where I load data from EDW to flat
files and send data to the vendors.
Responsibilites:
> Worked with Business Analysts to translate business requirements into
technical specifications.
> Developed Informatica technical design documents to load data from
legacy systems into staging and Data warehouse tables.
> Used various mapping, session and workflow configuration variables for
better management of the processes.
> Created Data Validation scripts for validating the data loaded.
> Worked on batch scheduling to schedule the jobs.
> Used look up, router, joiner, filter, source qualifier, aggregator,
normalizer, sequence generator, sorter and update strategy
transformations extensively.
> Used debugger and other strategies to handle errors in the mappings.
> Handled the performance tuning of Informatica mappings.
> Provided development support for analysis, functional testing, load
testing, and user acceptance testing.
> Made changes to the existing codes based on the new requirements.
> Involved in Unit and integration testing of Informatica sessions, batches
and fixed invalid Mappings.
> Used Informatica Versioning.
> Tuning of SQL queries for better performance
> Assist in providing root cause analysis on technical service problems and
failures.
> Assist in developing technical assessments of current and proposed work
units. Used ITSM for tracking and opening defects.
Environment: Informatica PowerCenter 8.6, HPQC, Oracle 10g,, SQL Server
Management Studio, Robo FTP, SQL, Shell Scripts,Flatfile, MS Visio / Office, ITSM.
SENTRY INSURANCE, WI
DEC10-SEP 11
Sr Informatica Developer/ QA
Sentry Insurance is one of the largest and strongest mutual insurance
companies in the US with assets of $11 billion and a policyholder surplus
of more than $3.3 billion. I worked on different projects with TDM
(Transportation Data Mart) and PCR (Premium Calculation and Reporting)
coming from Policy Center.
Responsibilities:
> Assisted in developing technical assessments of current and proposed work
units.
> Worked with Business Analysts to translate business requirements into
technical specifications.
> Interact with User Group (Finance) to understand their testing
criteria and priorities.
> Requested policies from Policy Center to support the testing criteria
of Finance.
> Collected necessary fields and conditions from the requested policies
made available on Policy Center and developed UAT test scripts and
provided users with test data.
> Used Policy center as source for validating PCR data.
> Loaded data from ODS to Transportation Data Marts (TDM).
> Used look up, router, joiner, filter, source qualifier, aggregator,
normalizer, sequence generator, sorter, XML Parser, update strategy
transformations extensively.
> Defined and built job schedules which include Refresh, Load and Daily
Updates (CDC).
> Created reusable transformations and mapplets to use in multiple mappings
> Performed Unit testing of Stored Procedures and Functions and different
Informatica jobs and lead System, Regression and User acceptance testing
of the processes and the data.
> Worked on changes to Stored Procedures.
> Involved in Unit and integration Testing of Informatica Sessions, batches
and fixed invalid Mapping
> Used Informatica Versioning.
> Extensively worked on Views, Stored Procedures, Triggers and SQL queries
and Defined DDL's for loading the data (staging).
> Logged defects, fixed and closing defects in HPQC.
Environment: Informatica PowerCenter 8.6, Policy Center, HPQC 9.2, Oracle
10g, SQL Server 2008, SQL Server Management Studio, SQL, Shell Scripts,
XML,Flatfile, MS Visio / Office 2007.
HEWITT ASSOCIATES, IL
MAR 10-NOV10
Lead/Sr ETL Developer/ QA
Hewitt is one of the world's leadiing HR consulting and outsourcing
companies. I worked on multiple projects on Finance, HR, Sales, and
Security domains. Work close with business users and offshore teams.
Responsibilities:
> Work with business user's direclty in gathering requirement and
implementing them and working close with offshore developers.
> Creating High level diagrams (HLD), LLD and creating mapping documents.
> Creating and updating data dictionaries.
> Used HP Quality center to create and for tracking of defects.
> Involved in coordinating with offshore team in resolving issues related
to daily job schedules.
> Used various mapping, session and workflow configuration variables for
better management of the processes.
> Created Data Validation scripts for validating the data loaded.
> Calculate cache sizes whenever needed for better performance.
> Loaded data into Salesforce.com
> Used Dynamic Lookup caches, Incremental Aggregation whenever needed.
> Used look up, router, joiner, filter, source qualifier, aggregator,
normalizer, sequence generator, sorter and update strategy
transformations extensively.
> Use debugger and other strategies to handle errors in the mappings.
> Handled the performance tuning of Informatica mappings.
> Provided development support for analysis, functional testing, load
testing, and user acceptance testing.
> Completed the implementation of requirements to meets the SLA's.
> Assist in providing root cause analysis on technical service problems and
failures.
> Tuned the Informatica Mappings for optimum performance.
> Replaced filters with Routers and SQL overrides in place of homogeneous
sources.
> Created and executed DDL scripts and created physical ODS and Reporting
structures.
> Creared optimized sql queries whenever needed to reduce the complexity of
Informatica processes
Environment: Informatica PowerCenter 8.6, Oracle 10g, DB2, PeopleSoft,
Salesforce.com, Cognos, AQT, PL-SQL, SQL, HP Quality Center 9.2, Shell
Scripts, Control M, Cognos, Unix,Flatfile, MS Visio / Office 2007.
THOMSON REUTERS, MN
JUN09-FEB10
Sr ETL Developer:
Thomson Reuters combine industry expertise with innovative technology to
deliver critical information to leading decision makers in the financial,
legal, tax and accounting, scientific, healthcare and media markets,
powered by the world's most trusted news organization.
Project is to Replace CS&S Front-end order capture system and the back
office order fulfillment systems for fourteen Trust, Sales & Use, Transfer
Pricing & Provision, and Income companies with SAP Order to Cash and
Salesforce.com front end.
I work with business analyst and with SFDC (salesforce.com)
functional/technical teams to gather requirements and implement the
requirements.
Responsibilities:
> Responsible to gather requirements from business and work close with SFDC
teams.
> Conduct design reviews and code changes.
> Worked with Salesforce as source/targets.
> Worked with Salesforce Lookup's and worked with Salesforce externalid's
and Upserts.
> Worked on SFDC performance tuning.
> Involved in coordinating with offshore team in resolving issues related
to daily job schedules.
> Handled the performance tuning of Informatica mappings.
> Provided development support for analysis, functional testing, load
testing, and user acceptance testing.
> Used various mapping, session and workflow configuration variables for
better management of the processes.
> Completed the implementation of requirements to meets the SLA's.
> Assist in providing root cause analysis on technical service problems and
failures.
> Assist in developing technical assessments of current and proposed work
units.
> Build Informatica mappings, workflows to process data into the different
dimension and fact tables.
> Worked with Informatica Versioning.
> Used look up, router, joiner, filter, source qualifier, aggregator,
normalizer, sequence generator, sorter and update strategy
transformations, XML parser and XML generator extensively.
> Developed UNIX shell scripts to schedule the Informatica processes using
UNIX command and Informatica pmcmd commands.
> Document software designs and code changes.
> Used Mappings Parameters/Variables and Workflow Variables to implement
Object Orientation techniques and facilitate the reusability of code.
> Created Pre-sql and Post-sql in both Transformation and Sessions
Properties.
> Used Debugger to test the mappings and to fix bugs.
> Assist other Informatica developers in building mappings and handling
performance issues.
> Work with customers, analysts, and vendors to prototype features to
determine their viability in improving and/or providing strategic
benefits to the company's recruiting toolsets.
> Identified and tracked the slowly changing dimensions, heterogeneous
Sources and determined the hierarchies in dimensions.
> Documented processing times for each module, developed test cases and
used them to run through each process.
> Involved in Unit and integration Testing of Informatica Sessions, batches
and fixed invalid Mappings.
Environment: Informatica PowerCenter 8.6, SalesForce.com, Sybase, Oracle
11i, DB2, Data Transformation Studio (B2B) 8.6.1, PL-SQL, SQL,XML,
WINSQL,Shell Scripts, Business Objects, Informatica Versioning,Unix,
Flatfile, MS Visio / Office .
UNICARE, TX
JUL 08-JUN09
Sr Informatica Developer / Data Analyst
UniCare is a national organization dedicated to the delivery of quality
healthcare plans and products providing managed care and specialty health
care services throughout United States. As part of the Data warehouse team,
I have been assigned detailed tasks supporting the Reporting and Planning.
Responsibilities:
> Responsible for batch scheduling..
> Worked with Business Analysts to translate business requirements into
technical specifications.
> Develop Informatica technical design documents to load data from
legacy systems into staging and Data warehouse tables.
> Build Informatica mappings, workflows to process data into the
different dimension and fact tables.
> Worked with Salesforce as Source/Targets/Lookup .
> Worked with Salesforce performance tuning.
> Worked with Salesforce insert/update/delete/upserts/external id's.
> Used look up, router, joiner, filter, source qualifier, aggregator,
normalizer, sequence generator, sorter, update strategy, XML parser and
XML generator transformations extensively.
> Extensively used Informatica source Analyzer, Warehouse Developer,
Mapping Designer, Mapplet Designer, Transformation developer, Workflow
Manager, and Workflow Monitor.
> Worked with source team in resolving issues relating to Data Quality.
> Done changes to the existing codes based on the new requirements and meet
the SLA'
> Developed error handling strategies processes to handle error in the
nightly jobs.
> Used HP quality center to track defect and tickets.
> Responsible for System Analysis, design, testing and documentation.
> Main contact for ETL job scheduling
> On call support for ETL.
Environment: Informatica PowerCenter 8.5, Salesforce.com, HP Quality
Center,Oracle 10g, DB2,TOAD 9.2, PL-SQL, SQL, Shell Scripts, Control M,
Business Objects 6.0, Unix, XML,Flatfile, MS Visio / Office
CARLSON COMPANIES, MN
OCT 06 - JUN08
Sr Informatica Developer / Data Analyst
Carlson is a hospitality industry company providing travel, hotel,
restaurant, cruise and marketing services. Carlson Companies also owns real
estate and provides leasing/ owning services. As part of the Operational
Data Store team, I have been assigned detailed tasks supporting the
Hyperion Reporting and Planning teams. Development wise, I have been
actively involved in Data Analysis, Developing code and testing and loading
to ODS (Operational Data Store).
Responsibilities:
> Individually supporting the Enterprise Strategic Sourcing team in
gathering requirements and implementing invoice data.
> Working with Hyperion Reporting Teams during Month End and Weekly
Schedules for Actuals Update.
> Actively working for the Planning Team to gather Forecasts and Budget
data to update the Operational Data Store.
> Gather requirements from business analysts in order to develop logical
code matching business requirements of separate operating groups within
the company.
> Schedule Control M jobs in order to facilitate Hyperion Reporting
Applications build.
> Actively involved in supporting the Zycus Application by coordinating all
the team activities.
> Documented ETL Specifications for all Phase's Entities including Loads
and Data Capture.
> Worked closely with the reporting team in reviewing the reporting layer
models.
> Worked closely with Data Conversion Team in providing additional inputs /
clarifications required from RiceW team for Data Conversion.
> Extensively used Informatica Source Analyzer, Warehouse Developer,
Mapping Designer, Mapplet Designer, Transformation Developer, Workflow
Manager, and Workflow Monitor.
> Worked with source team in resolving issues relating to Data Quality.
> Involved in Informatica Upgrade and Phase Testing
> Created a detailed move to production checklist containing Actions to be
taken, Steps to be performed, Scripts / Mappings / Workflows / Job
Scripts to be moved.
> Developed ETL detailed specifications based on High-level functional
specifications.
> Implemented Slowly Changing Dimensions to update the dimensional schema.
> Documented detailed test cases and also reviewed test cases from other
team members.
> Involved in the tuning and testing of MV's (materialized views).
> Created Informatica users groups, users and assigned appropriate
privileges and folder permissions.
> Involved in coordinating with offshore team in resolving issues related
to daily job schedules.
> Used various mapping, session and workflow configuration variables for
better management of the processes.
> Calculate cache sizes whenever needed for better performance.
> Used Dynamic Lookup caches, Incremental Aggregation whenever needed.
> Used look up, router, joiner, filter, source qualifier, aggregator,
normalizer, sequence generator, sorter and update strategy
transformations extensively.
> Use debugger and other strategies to handle errors in the mappings.
> Performed Unit testing of Stored Procedures and Functions and different
Informatica jobs and lead System, Regression and User acceptance testing
of the processes and the data.
> Developed UNIX shell scripts to schedule the Informatica processes using
UNIX command and Informatica pmcmd commands.
> Developed and maintained mapping and session parameter files as a part of
our schedule processes.
> Cross train new employees and consultants in the tools, technologies and
business standards the company uses.
> Able to deliver the assigned work on time.
> Done changes to the existing codes based on the new requirements and meet
the SLA's.
> Worked with Control M scheduling team on setting on new jobs as per
requests and made sure everything works correctly..
> Created PL-SQL scripts to read source data in to ODS layer tables.
> Implemented procedures/functions in PL/SQL for Stored Procedure
Transformations.
> Created SQL scripts for building the Data Warehouse Schema for various
subject areas including tables, indexes, transaction tables, sequences,
synonyms, grants etc.
> Extensively worked on Views, Stored Procedures, Triggers and SQL queries
and Defined DDL's for loading the data (staging).
> Tuned the Informatica Mappings for optimum performance.
> Replaced filters with Routers and SQL overrides in place of homogeneous
sources.
> Created and executed DDL scripts and created physical ODS and Reporting
structures.
> Creared optimized sql queries whenever needed to reduce the complexity of
Informatica processes.
> Worked with ODS and Reporting Data Architects in reviewing the Data
Models.
> Actively updated and maintained Standard Informatica Operating
Procedures.
Environment: Informatica PowerCenter 7.1/8.1, Oracle 10g, Zycus,TOAD 9.2,
PL-SQL, SQL, Shell Scripts, Control M, Hyperion Essbase 7x, Unix,
XML,Flatfile, MS Visio / Office 2003
THOMSON,NY
OCT 05 - OCT 06
Informatica Developer
Thomson, the most complete source for integrated information and technology
applications in the global financial services
Industry is dedicated to driving profitable and measurable performance
improvement for its clients. As a part of the development team, I was
involved in building Informatica processes to load data into business
applications databases and into data warehouse.
Responsibilities:
> Work with the business analysts and customers in gathering requirements.
> Develop technical design documents, high-level interface flow diagrams,
data models, data mappings, unit test case scenarios and identification
of Informatica process flows and transformation rules
> Developed Mappings between source systems and Warehouse components
> Used Informatica designer to create complex mappings using different
transformations to move data to business applications as well as to the
Data Warehouse
> Developed mapplets, mappings and configured sessions
> Participate in the stage table designs and work with DBA's for their
implementation in various environments
> Used aggregator, router, joiner, stored procedures, look up, filter,
source qualifier and update strategy transformations extensively
> Handle maintenance issues with batch jobs which run daily, weekly,
monthly and yearly
> Created reusable transformations and mapplets to use in multiple mappings
> Created and monitored workflows and tasks using Informatica PowerCenter
Work flow Manager
> Handled the performance tuning of Informatica mappings
> Managed Informatica Workflow Manager and Workflow Monitor
> Performed Informatica Administrator functions like creating users,
folders and assigning permissions on the folders
> Developed mappings/transformation/mapplets by using mapping designer,
transformation developer and mapplet designer in Informatica
PowerCenter 7.1
> Created and Monitored Sessions and Batches using Informatica Workflow
Manager. Managed the Metadata with in the repository
> Data Extraction and cleansing data using Data Junction
> Developed various reports for marketing departments for better analysis
using Business Objects
> Built the Universes Designer based on Data Marts and also created joins
> Used the Broad Cast Agent server to Schedule and monitoring the Reports
Environment: ETL-Informatica - PowerCenter 7.1 (Meta Data Repository,
Designer, Workflow Manager), Business Objects 5.1.4, Web Intelligence 2.6,
DB2 Mainframe, Oracle 9i, SQL, PL/SQL, Erwin 4.0, UNIX, Windows 2000/NT.
PROVIDIAN,CA
AUG 04 - SEP 05
ETL Specialist
Providian is a leading provider of credit cards and deposit products to
consumers throughout the United States. The projects main objective was to
create a central database for data and to provide a set of standard reports
to give better analysis to the marketing and financial group. The data used
to come in as DB2 mainframe and loaded into the Oracle which is the target
database using Informatica.
Responsibilities:
> Developed mappings using Informatica PowerCenter Designer to load data
from various source systems to target database
> Responsible to design, develop and testing the software (Informatica, PL
SQL) to maintain the data marts (Extract data, Transform data, Load data)
> Designed and developed complex Look up, Sequence Generator, Aggregator,
Joiner, Router, Rank, External Procedures and Update transformation rules
(business rules)
> Writing PL/SQL procedures for processing business logic in the database
> Tuning of SQL queries for better performance
> Created reusable worklets and workflows & used task developer in the
Workflow Manager to define reusable sessions
> Responsible for monitoring all the sessions that are running, scheduled,
completed and failed. If the session fails I have to debug the Mapping
> Involved in testing of Stored Procedures and Functions, Unit and
integration Testing of Informatica Sessions, Batches, fixing invalid
Mappings
> Defined the program specifications for the data migration programs, as
well as the necessary test plans used to ensure the successful execution
of the data loading processes
> Involved in writing UNIX shell scripts for Informatica ETL tool to run
the Sessions
> Used FTP to transfer the files between the UNIX and Windows
> Documented processing times for each module, developed test cases and
used them to run through each process.
Environment: Informatica PowerCenter 7.1, Oracle 9i, DB2 8.0, SQL, PL/SQL,
Shell Scripts, Erwin 4.0, FTP, HP-UNIX, Windows XP.
NETSILICA,NJ
JAN 03 - JUL 04
Informatica Consultant
This project is the central source of information on all modules like
Account Receivables, Accounts Payments, Assets, Inventory, Production, and
Purchases & Sales at Netsilica. We created Enterprise Data warehouse with
Oracle, SQL Server as source databases and Oracle was used as target
database. ETL Informatica was used to Extract, Transform data by applying
required business logic from source databases and loading data into data
warehouse star schema tables.
Responsibilities:
> Gathered and documented user requirements to build the ETL processes
> Designed and developed complex Look up, Sequence Generator, Aggregator,
Joiner, Router, Rank, External Procedures and Update transformation rules
(business rules)
> Tuned ETL mappings for better
Contact this candidate