SUMMARY:

• 7 years of IT experience in analysis, design, modelling, development, implementation and testing of Data Warehousing and Client/Server applications.
• Around 6+ years’ Experience in ETL tools like DataStage and Informatica with different versions.
• IBM Certified Solution Developer in Info Sphere DataStage V9.1.
• Efficient in all the phases of System development life Cycle (SDLC) using different methodologies like Agile and Waterfall.
• Ability to participate in Low Level Design documents and Control Plans/Run books.
• Extensive experience in dealing with High Volume Data, Performance Tuning, Maintaining, Multiple Job. Developed efficient mappings for data extraction/transformation/loading (ETL) from different sources to a target data warehouse.
• Developed number of DataStage ETL jobs based on business requirements using various DataStage Stages as Copy, Modify, Aggregator, Filter, Funnel, Join, Lookup, Merge, Datasets, Sequential files and Transformer etc.
• Designed Datastage jobs using MQ stage by reading the service and creating the XPATH and used XSLT stage in reading the XPATH and using the same for data transformation.
• Designed using Informatica Power Centre /Power Mart 9x/8x/7x, Power Exchange 9.x/8.x in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, configuring the Informatica Server and scheduling the Workflows and sessions.
• Extensive experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Normalizer, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Skilled in Database programming for Data Warehouses (Schemas), data modelling, Star Schema modelling, and Snowflake modelling.
• Proficiency in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon and surrogate key assignment and CDC (Change Data Capture) using both DataStage and informatica.
• Strong skills in creating reusable components like shared containers and local containers for multiple project use.
• Experience with relational databases like Oracle 11g/10g/9i, DB2, Teradata v2r12and bulk load utilities like Oracle SQL*Loader, M load, Fast load, T Pump, Fast export that are in ETL process for extraction or loading of data.
• Experienced in scheduling Sequence using Autosys for automatic run of jobs.
• Have extensive experience with multiple client location and also working in onsite - offshore model.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• The ability to adapt and learn new technologies and proficient in learning them quickly.
• Strong oral and written communication skills to maintain productive work relationships with management, clients, team members and other groups.
• Collaborated and worked closely within several teams as a highly motivated team leader; coordinated work, lead and trained individuals which resulted in creating a more productive work environment.

TECHNICAL SKILLS:

Languages: PL/SQL, SQL, UNIX shell and XML, HTML

Operating Systems: Windows 7/vista/2000/2003, MS: DOS, UNIX, Sun Solaris and Linux.

Databases: Oracle 11g/10g/9i/8.x/7x, SQL Server 2000/2005, Teradata V12, V14

ETL Tools: IBM Infosphere DataStage / 8.0.1/8.1/9.1 (Parallel Extender), Informatica 9.1/9.0, InformaticaPowerCenter, Informatica Data Quality, Informatica Power Exchange, DVO, Informatica MDM

Data Modelling Tools & Scheduling Tools: Toad and Autosys.

Reporting Tool: Business Objects, Cognos

PROFESSIONAL EXPERIENCE:

Sr.Informatica Developer

Confidential, Los Angeles, CA

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Centre tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modelling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Performed Performance testing with different sets of node configuration, different queue and different volumes.
• Prepared the DML's for maintenance tables, review, and test and execute them.
• Used Tortoise SVN version control tool for version controlling and movement of code to upper environments like SIT, UAT, Preproduction and Production.

Environment: Informatica Power Centre 9.1/9.0, Microsoft Visio, IBM AIX 4.2/4.1, SQL Server, Oracle11G, Autosys Scheduler, Unix, Windows, HP ALM.

Sr. Informatica Developer /Data Analyst

Confidential, Parkesburg, PA

Responsibilities:

• Involved in Business meetings to understand the business requirement specifications and implemented the ETL jobs using Informatica.
• Involved in developing the source to target process and mapping documentation.
• Participated in the review and approval of the technical transformation requirements document used to design and build the ETL modules in Informatica Designer.
• Participated in daily status meeting.
• Prepared a best practice document to use when designing jobs to gain optimum performance by using appropriate partitioning techniques.
• Implemented slowly changing dimensions on customers table using SCD stage in Informatica.
• Created shared container to in corporate business logic and used in multi job.
• Created and used job parameter set during developing jobs.
• Developed parallel jobs using various stages transformer, join, look up and merge
• Created job sequencer to automate the job.
• Knowledge of director client for troubleshooting.
• Knowledge and worked with administrator client for creating new user and assigning role.
• Involved in performance tuning of Data stage jobs and creating templates for future use.
• Worked on programs for scheduling data loading and transformations using Data stage.
• On Informatica extensively used the Filter, Copy, Funnel, Join, Merge, Aggregator, Column Generator, Sort, SCD and Remove Duplicate stages for providing transformation logic for the field as per the requirement.
• Involved in the development of dimensional data models using Erwin as per the specified business requirements
• Used the Data Stage designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse.
• Developed and implemented strategies for slowly changing dimensions, surrogate key generation and for incremental data loading
• Performed performance tuning of jobs to improve the extraction, transformation and loading time of data.
• Used Pl/SQL programming to develop store procedures and functions.
• Performed Performance testing with different sets of node configuration, different queue and different volumes.

Environment: Informatica Power Centre 9.1/9.0, Visio, Windows 7, UNIX AIX, Teradata V12R5.

Sr. Informatica and DataStage Developer

Confidential

Responsibilities:

• Identified source systems, their connectivity, related tables and fields and ensured data suitability for mapping.
• Prepared FastTrack Mapping Specifications created metadata layouts in Metadata Workbench and update Business Glossary.
• Prepared Data Mapping Document and Design the ETL jobs based on the DMD with required tables in the Dev Environment.
• Active participation in decision making and QA meetings and regularly interacted with the Business Analysts &development team to gain a better understanding of the Business Process, Requirements& Design.
• Extensively used ETL to load data from different source systems like Flat files into the Staging table and load the data into the target database.
• Worked on Informatica Power Centre tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor as well as worked on DataStage designer and director.
• Developed DataStage and Informatica mappings, re-usable transformations, re-usable mappings and mapplets for data load to data warehouse and database.
• Multi source Extraction Transformation and Loading into the target structures using Informatica.
• Worked closely with multiple business units and a data solution engineer to identify key information that will enhance business decision-making.
• Performance tuned mapping, sessions and database.
• Wrote stored procedures to accomplish tasks.
• Created sessions to move the data at specific intervals and on demand.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed.
• Debugged the mapping for failed session to fix data and code issues.
• As a part of daily loading into the warehouse, used UNIX shell scripting to triggers the workflows in a particular order.
• Involved in coding UNIX shell scripting to execute pre/post session commands.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Analysed and Created Facts and Dimension Tables for extraction and loading so that insert and updates of data are maintained in properly.
• Used different Data Warehouse techniques like Star-Schema, Snow-Flake Schema.

Environment: DataStage 8.5, Informatica Power Centre 9.1/9.0, Oracle 11g/10g, Autosys Scheduler, Web Services, PL/SQL, UNIX, AutoSys.