PROFESSIONAL SUMMARY:

• IT professional with around 7 years of experience in ETL Development and Support, experienced in requirement analysis, data analysis, application design, testing and support life cycle of Data Warehouse applications using Informatica and SQL and also hands on experience in Mainframe development.
• Experience in Informatica Power Center 9.1/9.0.x Worked extensively on Repository Manager, Designer and Workflow Manger, Workflow Monitor Tools in Informatica Power Center.
• Hands on experience with ETL process flow - Gather requirements, Create physical design, Design test plan, Create ETL process, Test process, Move to QA, Test process, Move to PROD, Maintain ETL process.
• Strong experience in developing complex mappings using transformations like Unconnected and Connected Lookups, Router, Aggregator, Sorter, Joiner, Transaction Control, Filter, Union and Update Strategy, Normalizer transformations.
• Worked with different source systems for Informatica - Flat file, DB2 tables, Cobol files etc.
• Worked on parameterization using mapping variables and parameter files.
• Developed Slowly Changing Dimension mappings of Type1, Type2 and Type3 (version, flag and time).
• Created various tasks like sessions, and workflows in the workflow manager to run the mapping during development.
• Knowledge of Database, SQL server, environment like SQL PLUS, TOAD & basics of UNIX concepts. Hands on experience in writing SQL queries. Created Data Structures. I.e. Tables & views and applying the data integrity using SQL.
• Proficiency in data warehousing techniques for Data Cleansing, Data Modelling, Slowly Changing Dimension.
• Having good understanding of a database schema for a data warehouse and participated in designing the logical and physical data model using Star Schema/Snowflake Schema, Fact and Dimensional tables.
• Created tasks like timer, Event Wait, Event Raise and Control tasks in preparing the Workflow for parallel processing or job dependencies.
• Worked on creating and scheduling of sessions, debugging, trouble shooting and performance tuning of jobs by determining bottlenecks at various points like targets, sources, mappings, sessions or system.
• Worked on Change Data Capture.
• Analyzed Session Log files in case the session failed to resolve errors in mapping and worked on error handling.
• Using PMCMD utility UNIX scripts were developed and ETL load was scheduled using utilities like Autosys.
• Experience in maintaining the repository & purging the repository objects & Archiving Periodic repository backup
• Having work experience in all phases of the Software Development Life Cycle (SDLC) including Requirement Analysis, Design, Development, Implementation, Testing and Maintenance.
• Worked predominantly in core banking and very good understanding of core banking concepts and aspects.
• Very good understanding of Functional Requirements and Design documents.
• Creating HLD and other design documents as needed.
• Have experience in Standard Project processes and Quality assurance. Also create and followed various standards and checklists for Informatica developers and helping them with access, folders, definitions and connection objects.
• Suggested and Contribute to handbook for Informatica developers to help them with the environment setup, standards, common issue resolutions etc.
• Having excellent ability to think about various test scenarios for the developed mapping and test it regressively before moving to production.
• Presented good working skills with Client, offshore and onsite teams.
• A thorough professional with a proactive attitude, capable of thinking in and out of the box.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1/9.0.x using designer (Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager, Workflow Monitor), repository manager

Operating Systems: MS Windows 98/2000/07, Linux,Unix

Database: IBM DB2, Sql Server,Oracle

Programming Languages: SQL, Unix, Cobol,CICS

Scheduling Tool: Autosys

Environment: SQL Server, Flat Files, Cobol Files, SQL PLUS, TOAD, Oracle Server, Unix shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo, NY

Informatica Developer

Responsibilities:

• Responsible for Requirement Analysis, Evaluation, Design, Development and Implementation using Informatica.
• Interacted to gather the Requirements and Business logics with Business Users and Business Analyst.
• Worked with data architects to understand the rules and the requirements of the business and helped in improvisation.
• Created High Level Design and Technical Design on the basis of requirement. Based on that impact analysis of existing components also done.
• Worked on Informatica tool Source Analyzer, Mapping Designer, workflow manager.
• Extensively used Transformations like Aggregator, Router, Joiner, Expression, Lookup, Update Strategy, and Sequence Generator. Also worked with various re-usable tasks, workflows, worklets, mapplets, and re-usable transformations.
• Created mapping as functionality to extract data from different source Databases, transform the data using ETL Informatica Transformations then load to database.
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
• Created functional and technical specification document and maintained it throughout from beginning till implementation. Provide Functional Solution whenever required.
• Responsible for development and support of few mainframe based application with COBOL language and used tools like ENDEAVOR, SPUFI used for the same.
• Code walkthrough with Developers, Clients and offshore team.
• Responsible for end to end testing of a developed interface and documentation for the same. Integration testing to ensure the successful execution of data loading process.
• Before deploying the errors were identified and debugged using Debugger.
• Responsible for estimation and execution of Test plans.
• Involved with development team and application team for Plan and coordination for database changes or any respective upgrades. Interacted with DBA for the same.
• Provided support for Code Migration in UAT/SIT Environment and Batch monitoring Support.
• Prepared the documentation for the mapping according to the designed logic used in the mapping.

Technologies: Informatica Power Centre 9.1, SQL, IBM DB2, COBOL, DB2, ENDEVOR

Confidential, Monterey Park, CA

Informatica Developer

Responsibilities:

• Responsible for requirement analysis, development of mapping and implementation using Informatica power center tool.
• Worked on Source Analyzer, Mapping Designer, and workflow manager along with extensive use of transformations like Aggregator, Router, Joiner, Expression, Lookup, Update Strategy, and Sequence Generator.
• Extracted data from various sources (Flat files, SQL Server, DB2 Databases, Cobol files).
• Date verification with system date, process date validation, data file and control file date validation after Unix script run.
• Developed slowly changed dimensions (SCD) Type 2 for loading data into Dimensions and Facts.
• Responsible for unit testing of created mapping and Involved in all the testing phases of the project to check whether the data is being processed accurately according to the user requirements.
• Created Autosys jobs to schedule the data load.
• Responsible for code migration in SIT Environment, System Integrated Testing and support.
• Prepared documentation of mapping with technical specification regular update and documentation of test results with numerous scenarios also maintained.

Technologies: Informatica, RDBMS such as Oracle, Unix, Mainframe Technologies with COBOL, CICS.

Confidential, Bloomington, MN

Informatica Developer

Responsibilities:

• Responsible for data Extraction, transformations and loading from flat files into Mainframe target according to client requirements using Informatica Power center.
• As a developer I was involved in enhancement of existing transformations, mappings, worklets, tasks and workflows.
• The load files from clients were received at daily, weekly and monthly basis and accordingly processed through the mappings.
• Extensively used Source Qualifier Transformation, and used most of its features like filter, sorter, and SQL Override.
• Involved in Unit and integration testing of the mappings.
• Created and scheduled workflows and scripts to run on various predefined intervals.
• Performed Debugging and Performance Tuning of Mappings and sessions.

Technologies: Informatica power center, RDBMS such as Oracle, Unix, SQL.

Confidential

Informatica Developer

Responsibilities:

• As this project was interface between two systems, need to coordinate with the various teams involved in the different stages of the data load process. Interacted with onsite coordinator for the same.
• Developed interface as per the requirement of the client to populate data fields to load in database. Used SQL*Loader to load flat files data to various tables.
• Identify the source systems to get the data then analyze the source as per business rules, prepare source analysis reports and data issues will be reported to other teams.
• Implemented slowly changing dimensions Type 2 using date method.
• Performed data validation of the data is done as per the datatype of the fields in the screen and database.
• Extensively used Source Qualifier Transformation, filter, sorter features of Informatica for developing mappings.
• As the process was basically to load the data most of the various Passive transformations were used like sequence generator, expression and look up.
• Responsible for Unit and System Integrated Testing and documentation for the end results and error logged in session runs.
• Scheduled the Jobs to run at particular time/interval thru the Scheduler using Workflow Manager.
• Responsible for analyzing Session Log files in case the session failed to resolve errors in mapping.
• Involved in Performance tuning at various levels including Target, Source, Mapping, and Session for large data files.

Technologies: Informatica 9.0.x, SQL server, SQL PLUS, COBOL

Confidential

Data Analyst (Support)

Responsibilities:

• Responsible for daily monitoring and analysis of CDF file. Interacted with onsite coordinator for the same.
• Analysis of data which was loaded in file, report generation of impacted data and send it to development team.
• Involved in initial study, design of Data Warehouse for better Reporting for Inventory and external Systems.
• Worked on SQL queries to extract data from Citi Direct Flat Files and send reports to Client.
• On the basis of the requests for the change, SQL codes were maintained.
• Documentation of various UAT results of major implementations as well as User Manuals, Training Guide.
• Responsible for analysis and documentation of error log files of the sessions run during batch.

Technologies: SQL, File Management System, Flat Files, DB2 Tables, MS-Excel