SUMMARY:

• 7.5 years of total IT experience and Technical proficiency in the Data Warehousing teamed with Business Requirements Analysis, Application Design, Development, Implementation, Data Modeling and Testing of Data Warehouse systems for Insurance,
• 7+ years of extensive experience in Informatica Power Center 8.x/9.x, Informatica Power Exchange 8.6 to implement data warehouses/data marts which involve creating, debugging and executing mappings, sessions, tasks, and workflows.
• Experience in integration of various data sources like Oracle, SQL Server, DB2, Teradata and Flat Files into Warehouse.
• Well versed in Data modeling concepts incorporating dimensional modeling (star and snowflake schema), logical and physical data modeling.
• Experience on Informatica designer tools - transformations, reusable transformations, mappings, and mapplets.
• Strong Experience in Developing Mappings using Informatica Transformations like Source Qualifier, Expression, Connected & Unconnected Lookup, Aggregarator, Expression, Sorter, Joiner, Sequence Generator, Normalizer, Update strategy, Router,Union and Filter etc
• Proficient in performance tuning of Informatica Mappings, Transformations, and Sessions
• Worked extensively with Informatica Workflow Manager (using tools such as Task Developer, Worklet and Workflow Designer, and Workflow Monitor) to build and run workflows.
• Extensively worked with Slowly Changing Dimensions (Type I, Type II and Type III).
• Technical hands-on expertise using OLAP tool Business Objects (Reports, Designer, Web Intelligence, Info view, and Supervisor).
• SQL/Database developer experience in writing efficient SQL queries, PL/SQL Scripts, fine tuning queries and wrote several SQL queries for adhoc reporting.
• Extensive Experience in Developing Oracle Database objects like Stored Procedures, Functions, Triggers, Tables, Views and a Experience in Tuning the SQL code.
• Experience in maintenance and enhancement of existing data extraction, cleansing, transformation, and loading processes to improve efficiency.
• Extesnsively used ESP Scheduler, Autosys, and Informatica Scheduler for Scheduling workflows.
• Experience in writing Unix Shell Scripts and SQL scripts for data validation scripts.
• Excellent exposure on Software Development Life Cycle (SDLC).
• Strong ability to quickly adapt to new applications, platforms and languages.
• Strong commitment towards quality, experience in ensuring compliance to coding standards and review processwith excellent analytical/communication skills and good team spirit.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x, Informatica Power Exchange 8.6.

Database & Related Tools: Oracle 11g/10g/9i/8i, MS SQL Server 2012/2008/2005, DB2 8.1/8.0/7.0, Teradata, SQL*Plus, SQL Loader, SQL Navigator, Toad, DB2 Command Center.

Data Modeling Tools: Embarcadero ER Studio 8.6, Visio.

Reporting & Scheduling Tools: ESP Scheduler, Autosys, Business Objects XIR2.

Languages: SQL, PL/SQL, T-SQL, C, Unix Shell Scripting.

Operating Systems: Window NT/95/98/2000/2003/XP/7, Unix z/OS.

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

Sr Informatica/ETL Developer

Responsibilities:

• Worked closely with the Business Analysts to understand the Data requirements and business rules to be implemented.
• Prepared required Technical design document and mapping design document based on the functionality required.
• Created and maintained Mappings using Mapping Designer to load the data from various sources using different transformations like Aggregator, Expression, Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier, and Update Strategy transformations.
• Worked extensively with almost all the tools in Informatica like Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Extensively used Informatica Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Used designer Debugger and Breakpoints to test the data flow and fix the mappings. Tuned Informatica Mappings and Sessions for optimum performance.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
• Extensively used SQL tools Oracle SQL Developer and SQL Server Management Studio 2012 to execute SQL queries.
• Performance Tuning of theInformaticaMappings and database by adopting Explain plans, cutting down query costs using Oracle hints, changing the mapping designsCreated Unix shell scripts for flat file handling, creating list of file which is input forinformaticaread, pre post session operations on source and target databases ( i.e dropped and re-created indexes, collect stats),executed these shell scripts through pre post session command tasks in workflow.
• Extensively used ServiceNow to migrate code to higher environments(INT, UAT, PROD).
• Extensively used Autosys Scheduler to schedule and execute the workflows.
• Experience in writing UNIX scripts to merge files, check the size of the file etc.
• Responsible for Unit testing ETL code both for Quality and Quantity and verify data loaded in target by writing SQL queries and document the unit test results.
• Involved in User Acceptance Testing (UAT) and System Integration Testing (SIT) to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Responsible for creating Technical design document(TDD) as part of code handoff to production support team.

Environment: Informatica Power Center 9.5, Oracle 11g, Microsoft SQL Server 2012, Oracle SQL Developer, SQL Server Management Studio 2012, Winscp, ServiceNow, Flat Files, Autosys and Unix.

Confidential, Glendale, CA

Sr Informatica/ETL Developer

Responsibilities:

• Analysed the Functional Specs provided by the Architect and created Technical Specs documents for all the mappings.
• Worked as part of the development team, along with the Systems Analysts/Business Analysts.
• Designed ETL Specification documents to load data from source to target using various transformations according to the business logic.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, and Union to develop robust mappings using the Informatica Designer.
• Extracted data from sources like Oracle, XML, DB2, SQL Server and Fixed width Flat files Transformed the data according the business requirement and then Loaded into the SQL Server Database.
• Developed reusable transformations, mapplets to implement the common business logic.
• Created sessions, configured workflows to extract data from various sources to loading into data warehouse.
• Extensively used Informatica Power Exchange to create data maps.
• Implemented Change Data Capture (CDC) to extract information and Partitioned sessions for concurrent loading of data into the target tables.
• Extensively worked with copy book, VSAM File, Sequential files and Flat Files.
• Extensively used SQL tools TOAD and DB2 command center to execute SQL queries.
• Used Informatica Scheduler to schedule the workflows and developed UNIX scripts to check for the existence of files, to create file list, to move files to archive folder etc.,
• Responsible for delivering Application Operations Guide (AOG), Interface Detailed Design Specification document and Unit test document.
• Extensively used HP Quality Center to log the Incidents and tracking, Fix the Incident
• Monitor; troubleshoot workflows and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.
• Provided the Production support for the production issues by troubleshooting the session logs, bad files, error log tables and debugging the mappings.

Environment: Informatica Power Center 8.6.1/9.1, Informatica Power Exchange 8.6, Oracle 11g, DB2 10.1, SQL Server 2008, Toad 10.1, PL SQL Developer, DB2 Command Center 9.5, Mainframes (DB2, VSAM Files, Sequential Files), File Aid 9.2, HP Quality Center 10.

Confidential, Westport, CT

InformaticaDeveloper

Responsibilities:

• Analysed business requirements and coordinated with the business analyst to develop ETL procedures that confirm to the enterprise standards while maintaining consistency across all applications and systems.
• Parsed high-level design specs to simple ETL coding and mapping standards.
• Analysis, Design and Development, test and implementation of Informatica transformations and workflows for extracting the data from the multiple legacy systems.
• Extensively used Teradata SQL with in BTEQ and worked extensively with utilities of Teradata like Multi-Load, T-Pump and BTEQ to populate the target data.
• Expertise in Performance Tuning by identifying the bottlenecks at sources, targets, transformations and session level.
• Developed processes for automation of loading data using parameter driven sessions for various workflows, verification and re-conciliation of data stored in several different source systems.
• Configured and scheduled Pre and Post Session commands with Shell Scripts and invoked them using command task.
• Designed and Created Universe, Classes and Objects using Designer and Created User Objects including Dimensions, Details and Measures.
• Created Aliases and Contexts for resolving Loops and checked the Integrity of the Universe.
• Created reports on Web Intelligence using Info View Portal and distributed the reports to different users.
• Participated in the development and maintenance of a Data Warehouse Routine Load Schedule.
• Created UNIX shell script to FTP flat files from different ordering systems to the ETL server.
• Developed Test Cases according to Business and Technical Requirements and prepared SQL scripts to test data.

Environment:InformaticaPowerCenter 8.6.1, Oracle 10g, DB2 9.7, Teradata, Toad, Flat Files, Erwin, SQL, PL/SQL, Windows XP, SQL Loader, Business Objects XIR2.

Confidential, New Brunswick, New Jersey

InformaticaDeveloper

Responsibilities:

• Involved in all phases of SDLC from gathering requirements, design, development, testing, support for UAT and production deployment. Involved in design of logical physical Dimensional data models and implementing Star Schema with Fact and Dimension tables
• Study the existing source databases and interact with decision makers for analyzing their business plans.
• Worked with heterogeneous sources including relational sources and flat files.
• Worked on creating staging Tables, Constraints, Indexes, and Views.
• Developed ETL sessions for initial, full loading and incremental loading.
• Used various Transformations like Joiner, Aggregator, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router while developing the ETL mappings.
• Created Sources, Targets in shared folder and developed re-usable transformations, mapplets and user defined function (UDF) to re-use these objects in mappings to save the development time.
• Designed and Developed complex mapping with multiple target load plans with mapplets reusable transformations and mapping parameters variables to process initial incremental data.
• Decreased load time by implementing Performance Tuning techniques by using lookup caches, providing sql override in lookups, using tables with fewer rows as the master table in joiner transformations, passing the sorted data into aggregate transformation, dropped indexes and re-created them after loading data to targets.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, and scheduling of the workflow.
• UsedInformaticadebugger to identify the data issues and fix the mappings.
• Performed Adhoc queries using PL/SQL developer to check for consistency of the data in the tables and to update the tables as per the requirements.
• Created detailed Unit Test Document with all possible Test cases/Scripts
• Responsible for retrofitting the code to QA environment, and extending the support for the QA and UAT for fixing the bugs.
• Proactively identifying the changes required within the production environment and working on the enhancements/Change requests.

Environment:Informatica Power Center 8.1, Oracle 9i, Windows XP, Flat Files, DB2 8.1, TOAD.

Confidential

ETL Developer/Analyst

Responsibilities:

• Analysed the Specifications and involved in identifying the source that data needs to be moved to data mart.
• Involved in analysing scope of application, defining relationship within & between groups of data, star schema, etc.
• Identified and created different source definitions to extract data from input sources like Flat files, SQL Server and load into relational tables like Oracle.
• Enhanced and created various database objects in Data Mart as per changing technical requirements.
• Extensively involved in requirement analysis and created ETL mapping design document
• Extensively Designed, Developed, Tested complexInformaticamappings and mapplets to load data from external flat files and other databases.
• Extensively Worked onInformaticatools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer.
• Extensively used all the transformations like source qualifier, aggregator, filter, joiner, Sorter, Lookup, Update Strategy, Router, Sequence Generator etc. and used transformation language likes transformation expression, constants, system variables, data format strings etc.
• Extensively designed and developed reusable transformations & aggregations and created target mappings that contain business rules.
• Created and configured workflows, worklets, and sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Extensively worked on ETL performance tuning for tune the data load, worked with DBAs for SQL query tuning etc.
• Configured sessions in a batch and scheduled them through Informatica job scheduler.
• Involved in all phases of Data quality assurance.
• Developed shell scripts to automate the data loading process and to cleanse the flat file inputs

Environment: Informatica Power Center 8.1, Oracle 9i, Unix, Flat Files, SQL Server 2005.