SUMMARY:

• 7 Years of Professional experience in different areas of Data warehousing, RDBMS, Data modeling, Data extraction, Data acquisition, Analysis, Application design, Development and Implementation of data warehousing, business Intelligence system using Informatica Power Center, Data Conversion and various business applications in different platforms Informatica PowerCenter 8.6/8.5/8.1/7.1/6.1.1, Oracle 11g/10g/9i(SQL/PL SQL).
• Extensive experience in System Analysis, Design, Development, Implementation, Production Support and Maintenance of Data Warehouse Business Applications in Pharmaceutical, Finance and Insurance industries.
• Experience in Dimension Data Modeling concepts like Star Join Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling
• Worked in Data Conversion of various data sources like Oracle, MS SQL Server, Oracle Apps, MS Access, Fixed Width and Delimited Flat Files, COBOL files and XML Files.
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Skills of understanding of Project Life Cycle and gathering requirements for ETL Development.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflows & Worklet Designer and Managing, Scheduling, and Monitoring of Informatica workflows.
• Worked on all the transformations like Connected and Unconnected - Remote Lookup, Aggregator, Expression, Filter, Router, Update Strategy, Connected and Remote Stored Procedure and Sequence Generator, Sorter.
• Created ETL mappings using Informatica Power center to move Data from multiple sources like Flat files, Oracle, DB2 into a common target area such as Data Marts and Data Warehouse.
• Extensive knowledge with TeradataSQL Assistant. Developed Teradata BTEQ scriptsto Load data from TeradataStaging area to Data Warehouse, Data Warehouse to data marts for specific reporting requirements.
• Experience in PL/SQL Programming (Stored procedures, Triggers, Packages) using Oracle (SQL, PL/SQL), SQL Server and UNIX shell scripting to perform job scheduling.
• Quick learner with Analytical and logical programming skills and possess excellent presentation and interpersonal skills.

TECHNICAL SKILLS:

Operating Systems: Windows 2008/2007/2005/ NT/XP, UNIX, MS-DOS, IBM S/3,MVS/ESA

ETL Tools: Informatica Power Center 8.6/8.5/8.1/7.1 (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager and Informatica server)

Databases: Oracle 11g/10g/9i/8i, DB2 v8.1, MS SQL Server 2008/2005.Netezza

Data Modeling tools: ERWIN 4.x and Concepts like Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Languages: SQL, PL/SQL, UNIX Shell scripts, C, C++

Scheduling Tools: AUTOSYS

Development Tools: SQL *PLUS, TOAD, SQL Navigator.

Packages: MS Word, MS Excel, MS Project, MS Visio, MS PowerPoint

PROFESSIONAL EXPERIENCE:

Confidential, NC

INFORMATICA DEVELOPER/ANALYST

Responsibilities:

• Worked with different Informatica client Tools like Source Designer, warehouse designer, Mapping designer, Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Servers.
• Created design documents, technical specifications for Mappings and Sessions based on user requirements.
• Worked with Business requirements analyst to identify and understand source data systems and Developed Mappings between source systems and warehouse components.
• Involved in data conversion using Teradata Utilities and loaded into Teradata tables
• Expertise in system analysis with the help of data collection and proposing solutions.
• Assisted Senior Technical Analyst in defining the strategies of systems and developing system requirements.
• Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters and Dashboard prompts, Siebel Security Setup (groups, access privileges), Metadata objects and Web Catalog objects (Dashboard, Pages, Folders, Reports)
• Worked closelywithTesting team and helped in testing theInformaticamappings, workflows andTeradata scripts
• Involved in analysis and requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Extensively Created different complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed in Data Warehouse and used Update strategy transformation to transfer data from source to data effectively.
• Responsible for creating Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Extensively used Multi-Load and Fast-Load utility to populate the flat file data into the Teradata database Worked on performance tuning and optimization of the Sessions, Mappings, Sources and Target Worked with the Business Analysts for requirements gathering, business analysis and testing.
• Used debugger to validate mappings and gain troubleshooting information about data and error conditions. Developed shell scripts to automate pre-session and post- session tasks.
• Experience developing software for SQL databases including MySQL, Oracle, MSQL and Netezza.
• Involved in creating scripts for various database objects related to the data model, which involve in creation of schema, tables, sequences, views, Materialized views, constraints, and indexes.
• Extraction Involved in the development of Informatica mappings and also tuned them for better Performance.
• Involved in designing of star schema based data model with dimensions and facts.
• Responsible for Performance tuning of Informatica code for better performance.
• Maintaining the Informatica servers and services for smooth development and production efforts.
• Contact Informatica tech support for resolving the issues we are not familiar with.
• Created standard documents for developers expecting similar Informatica code from different consultants.
• Migrated Informatica folders, mappings, workflow, reusable objects from one environment to another and in the process of change control.
• Worked with pre and post sessions and extracted data from Transaction System into Staging Area. Repository Backup, Clear Cache and log files.
• Developed and maintained technical documentation for Informatica servers and repositories. Analyzed performance measures to fit the reporting needs of the company. Sound knowledge in migrating mappings from development to production.
• Experience developing software for SQL databases including MySQL, Oracle, MSQL.
• Extensively usedTeradataSQL Assistant to extract data from Datawarehouse.
• Monitoring the existing ETL jobs and takes necessary actions as per the errors.
• Responsible for the development of system test plans, test case creation, monitoring Progress of specific testing activities against plan.
• Hands on experience on writingTeradataETL scripts using BTEQ
• Extensively used ETL to load data from Flat files. Used SQL, PL/SQL, and TOAD validating Data going in the Data Ware House.
• Tidal Enterprise Scheduler automates workloads on and across Autosys.
• Experienced working with Automation Tools like Autosys and Tidal for scheduling Informatica Jobs
• Proficient in using Informatica workflow manager, workflow monitor, server manager, PMCMD (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.

Environment: Informatica Power Center 8.6, Oracle 10g/9i, TOAD, and Teradata, DB2 v8.1, PL/SQL, UNIX, Windows XP, Erwin 4x, UNIX Shell Scripts and DB2 Connect.

Confidential, NY

ETL/INFORMATICA DEVELOPER

Responsibilities:

• Analyzed source data and gathered requirements from the business users.
• Informatica Power Center 8.5 is used to extract, transform and load data from different Operational data sources like Oracle as an ODS, DB2 and flat file.
• Coordinating with source systems owners, day-to-day ETL progress monitoring, Data warehouse Target schema design (star schema) and maintenance.
• DB2, SQL Server and worked with business users and developers to develop the
• Scalability and performance tune existing batch to handle large volumes.
• Worked on delimited flat file sources.
• Created reusable transformations and Mapplets and used them in complex mappings.
• Created different transformations for loading the data into target database using e.g. Source Qualifier, Joiner transformations, Update Strategy, Lookup transformation, Rank transformation, Expressions, Aggregator, and Sequence Generator.
• Scheduling of the jobs through Tidal and Crontab
• Experience working on performance tuning and optimizationof Teradata queries Involved inDataMigrationbetween Teradata,MS SQL server,DB2 and OracleExperience in Database Programming,SQL,PL/SQL(Stored Procedures, Functions and Triggers) for faster transformations and Development using TeradataandOracle
• Used mapping Parameters and Variables to pass the values between sessions.
• Developed mappings with Transformations Mapplets confirming to the business rules.
• Testing and Data Validation - each extract process will be validated, and data elements within each file will be reviewed to ensure data quality prior to passing the file to Risk Management. Implemented Type I and II Slowly Changing Dimensions.
• Routines using Informatica Power Center and Oracle/Netezzaas the backend databases
• Worked onTeradatainsert, Update and Upset SQL to transform and Load Summary tables built on Core Data Warehouse using BTEQ.
• Created tasks like Timer Event Raise, Event Wait, Decisions, and Email.
• Document all the DTS packages implemented to move the data from source to target tables. Defined roles and responsibilities within the team and reviewing deliverables
• Data Enhancements and deliverables done to QA Environment Successfully.
• Automated Informatica flow of loading data by using Autosys scheduler with Followed Software Development Life Cycle process.
• Performance tuning of sources, targets, mappings and SQL queries in the transformations. Delegating work to team members
• Designed reusable transformations and Mapplets to be re used with various mappings.
• Worked on Database Triggers, Stored Procedures, Functions and Database Constraints.
• Performing Unit, Integration and Regression testing and preparing Test Cases for the same. Coordinating work offshore team.

Environment: Informatica Power Center8.5 (Repository Manager, Designer Tools like Source Designer, Warehouse Designer, Mapping and Mapplet Designer, Workflow Manager, Workflow Monitor) DB2 8.0, Oracle 10g, UNIX Shell Scripting, Autosys.

Confidential, BOSTON

DW ETL INFORMATICA DEVELOPER

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering and project coordination.
• Design and Development of ETL routines using Informatica Power Center 8.1. Within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, Maplets, 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.
• 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. Implemented slowly changing dimensions.
• Used DB2 Connect to extract multiple database source systems to single analytical system for large databases and also 24*7 Production support for data warehousing.
• Logical and Physical Data Modeling (relational and multi-dimensional) using ERWIN and used Power Plug to forward engineer to Informatica Repository
• Performance Monitoring and tuning of SQL using Explain Plans and Oracle Hints and tuning of Informatica mappings using SQL overrides and source filters and managing cache file allocations and sizes. Used TOAD to run SQL queries.
• Extensively used SQL*Loader to load data from flat files to database tables in Oracle.
• Involved in Data Extraction from Oracle and Flat Files using SQL Loader.
• Developed and tested all the informatica Data mappings, sessions and workflows - involving several Tasks. Generated Adhoc reports using Query studio in Cogon’s.
• Strong Experience writing SQL Queries, PL/SQL Procedures in Oracle Database, DB2 UDB.
• Implementation of stored procedures and packages utilizing PL/SQL for the enhancements of the existing application level data warehouse.

Environment: Informatica Power Center 8.1, Oracle 10g, Cognos, Unix (HP-UX 11.x), Sun Solaris (2.6), Windows 2K,UNIX Shell Scripts, PL/SQL, DB2 Connect, TOAD.

Confidential

ETL DEVELOPER

Responsibilities:

• As a part of 3-member team, was involved in design, development and implementation of the module.
• Worked with ETL tool Informatica create mappings and workflows and transformations.
• Configured Repository Manager, created folders and managed objects in repository manager for Informatica.
• Worked on Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet and Transformations.
• Used Filter, Router, Aggregator, Lookup, Expression, and Update the Mapping Strategy transformations whenever required in the mapping.
• Involved in creation of sessions and scheduling of sessions.
• Creation of different kinds of reports about Tables, Views, Synonyms etc from the Oracle Database. Improved the performance of long running jobs by updating the SQL statements and creating indexes.

Environment: Oracle8i, Informatica 6.1(Source Designer, Warehouse Designer, Mapping And Mapplet Designer, Workflow designer, workflow Monitor) windows 2003, Oracle 8i, SQL/PL SQL.