SUMMARY

• Over 8 years of IT experiencein Data Warehousing/Integration using ETL Tool Informatica Power Center 9.x/8.x in various Industry verticals like Finance, Retailers, Insurance, Pharmaceuticals, Banking.
• Involved in full life cycle of software development including system analysis, design, development, testing, implementation, support of various applications in Data Warehousing, and OLAP applications and Training.
• Have clear understanding of Data Warehousing and BI concepts with emphasis on ETL and life cycle development using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Data Modeler with strong Conceptual, Logical Data Modeling skills and experience in requirements gathering, source to target mapping, writing functional specifications, queries.
• Extensively worked on Dimensional Modeling, Data Migration, Data Cleansing, and Data staging for operational sources using ETL and data mining features for data warehouses.
• Knowledge of complete software development life cycle including Requirement Gathering, Requirement Analysis, Cost Estimation, Project Management, Design, Development, Implementation and Testing.
• Expertise in OLAP/OLTP System Study, Analysis and ER Modeling, developing database Schemas like Star Schema, Snowflake Schema, Conforming Dimensions and Slowly Changing Dimensions used in relational, dimensional and multidimensional modeling.
• Strong experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected, Static and Dynamic lookups, SQL, Stored Procedure, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Good understanding of relational database management systems like Oracle, Teradata, DB2, SQL Server and worked on Data Integration usingInformatica for the Extraction transformation and loading of data from various database source systems.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts and Decision Support Systems (DSS) using Multidimensional and Dimensional modeling (Star and Snowflake schema) Concepts.
• Good knowledge in Oracle 11g/10g/9i, IBM DB2 9.x/8.x, Teradata, SQL Server 2012/2008/2005 , SQL, PL/SQL Stored procedures, functions, and exception handling using Toad.
• Responsible for interacting with business partners to identify information needs and business requirements for Reports
• Extensive database experience and skilled in SQL Server, Oracle, DB2, Sybase, XML, Files, Flat Files, MS Access.
• Worked in collaborative team environment with other developers, business analysts, and a project management team.

TECHNICAL SKILLS

ETL Tools: InformaticaPower Center 9.x/8.x/7.1, PowerMart, Power ExchangeCrystal Reports

Languages: C/C++, JAVA, HTML, XML, VB, SQL, PL/SQL.

RDBMS: Oracle 11g/10g, DB2 V9.x/8.x, SQL Server 2012/2008, MS Access

Scripts: UNIX Shell Scripting, Java Scripting.

Operating Systems: Windows 7/XP/Vista/, UNIX and Red Hat Linux.

Database related utilities/tools: Mainframes (DB2, VSAM and Sequential Files),TOAD, SQL * PlusTeradata SQL Assistant, SQL, PL/SQL, Stored procedures, Functions, Procedures, Packages, Triggers, Database links, Exception Handling, Import/ExportManager, Oracle Warehouse Builder.

PROFESSIONAL EXPERIENCE

Confidential, NewYork

Informatica Developer

Responsibilities:

• Worked with architect, business managers to understand the requirement and source system in order to prepare design documents specifying the various ETL approaches, pros and cons of the different approaches with suggestion of the best approach.
• Extensively worked on developing InformaticaMapplets, Mappings, Sessions, Worklets andWorkflows for data loading.
• Working on transformations such as Lookup, Aggregator, Expression, Joiner, Filter, Rank, Sorter, Router, Sequence Generator, XML transformation etc
• Created mappings of initial load for all source systems, cleansed data and load it into staging area.
• Expertise in writing Pre & Post Sqls and overrides Sqls as per the requirement.
• Extensively used the capabilities of Power Center such as File List, pmcmd, Target Load Order, Constraint Based Loading etc.
• Responsibilities included designing and developing complex Informaticamappings including Type - II slowly changing dimensions.
• Worked with Pre-Session and Post-Session UNIX scripts for automation of ETL jobs using CONTROL-M schedulers and involved in migration/deployment of ETL codes from development to production environment.
• Created variables and parameters files for the mapping and session so that it can migrate easily in different environment and database.
• Designed various tasks usingInformaticaworkflow manager like session, command, email, event raise, event wait and so on.
• Used FTP protocol to handle FLAT files with Mainframe server
• Performed file archiving using Unix Shell Scripting.
• Involved in resolving the issues related with the migration of designs from Dev Server to Prod Server and also helped in resolving issue related to the production support of the Data Warehouse.
• Perform Unit testing by writing simple test scripts in the database and involved in integration testing and minus SQL script comparing from source to target.
• Interacting with User Groups/ Corporate Testing Groups/Business People.

Environment: InformaticaPower Center 9.5, IBM DB2, Control-M, FileZilla, Windows, UNIX Shell Scripting, etc.

Confidential, Brooklyn, NY

Informatica Developer

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Involved in requirement gathering from Business to understand the Data inputs.
• Worked closely to develop logical and physical data models that capture current state/future state data elements and data flow using ER-WIN.
• Analyzed the data model to fit in the ETL to load data into its input tables with proper link of surrogate keys. Actively involved in the Design and development of the STAR schema data model.
• Derived the dimensions and facts for the given data and loaded them on a regular interval as per the business requirement. Developed entity diagrams and data dictionaries to accomplish tasks.
• Designed and Development of ETL routines usingInformatica Designer within theInformatica Mappings, usage of Lookups, Aggregator, Ranking, Normalizer, Mapplets, 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 were extensively done.
• Extensively used Global Source/Targets, User Defined Function, Reusable Mapping and transformation. Used Incremental Aggregation technique to load data into Aggregation tables for improved performance.
• Extensively used Parameter file to override mapping parameter, mapping Variables, Workflow Variables, Session Parameters, Ftp Session Parameters and Source-Target Application Connection parameters.
• Performed Risk and Gap Analysis Used InformaticaBest Practice to handle Error handling - Logging the record level errors in the metadata tables and Auditing - Capture the source/target record counts in every phase of the process flow.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse Oracle tables usingInformatica Workflow Manager.
• Written SQL commands (Pre-Session & Post-Session commands) and executed them in the target database to drop the index & create the index for the target table before and after loading data into it.
• Experience in creating Dynamic deployment groups and ETL Query for promoting up to higher environments.
• Involved in identifying bottlenecks in source, target, mappings and sessions and resolved the bottlenecks by doing Performance tuning techniques like increasing block size, data cache size, buffer length.
• Developed the UNIX shell scripts to send out an E-mail on success of the process indicating the destination folder where the files are available. Used Autosys for scheduling the jobs.

Environment: Informatica8.x/9.x, Oracle 10g/11g, PL/SQL, SQL Toad, DB2, UNIX Shell scripting, Autosys.

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Extensively used Informatica client tools-Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Informatica Repository Manager. The objective is to extract data stored in different databases such as Oracle and to load finally into a single Data Warehouse i.e. Oracle.
• Played an extensive role in business requirement gathering, requirement analysis, database design, ETL design, development and implementation of the end to end solution, using SDLC techniques.
• Involved in conceptual, logical and physical database design using Dimensional Data Modelling.
• Used Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer to create ETL mappings.
• Created mappings, reusable transformations using transformations like Lookup, Filter, Expression, Stored Procedure, Aggregator, Update Strategy etc.
• Created Sessions and Workflows.
• Worked with Flat files, Relational and XML sources.
• Extensively worked in the performance tuning of the ETL mappings and database queries to reduce the run time of the sessions and workflows.
• Was involved in Coding of Complex Stored Procedures, Functions, Triggers using SQL and PL/SQL.
• Provided Pre & Post production assistance.

Environment: InformaticaPower Center 8.x, Integration Manager, Oracle 10g, SQL, PL/SQL, Unix Shell Scripts(Korn), Windows XP, MQ series and Flat Files.

Confidential, Boston, MA

Informatica Developer

Responsibilities:

• Gathered business requirements from business users and prepared functional specifications for various interfaces and Data Migrations.
• Developed ETL jobs to load data into XML files from Oracle database.
• Developed various mapping to migrate the data from Darwin to Smartlab.
• Developed various interfaces like Darwin to Smart lab bi-directional interface, MDI interface etc.
• Used Integration Manager to load data from XML files into Darwin system.
• Extensively worked on developing and modification of ETL Mappings using various Transformations like Source Qualifier, Expression, Lookup, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Router transformations inInformatica Designer.
• Extensively worked on creating Workflows for various Interfaces and Data Migration mappings.
• Scheduled and unscheduled workflows and used UNIX command tasks to automate the entire process of fetching the source file from a different path and ftp it onto the server.
• Involved in creation of target tables in Oracle andInformaticamappings and workflows and executing them through UNIX Shell Scripts.
• Involved in Testing of Interfaces and Data Migrations.

Environment: InformaticaPower Center 8.x, Integration Manager, Oracle 10g, SQL, PL/SQL, Unix Shell Scripts(Korn), Windows XP, MQ series and Flat Files.

Confidential, NY

Informatica Developer

Responsibilities:

• Prepared technical specifications for ETL Informaticato convert existing data process to the new application
• Analyzed and gathered the Product/Performance attributes available in EDW for PST application team to build their interface for the source.
• Used InformaticaPower Center Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Repository Manager and Workflow Manager
• Designed and developed complex Informaticamappings using different transformations
• Created workflows to support daily and weekly loading
• Extensively worked on the transformations like Source Qualifier, Filter, Joiner, Aggregator, Expression and Lookup.
• Debugged maps using Debugger and Transformation’s verbose data
• Used session and workflow logs to debug the session and analyze the problem associated with the mappings and generic scripts
• Extensively created reusable transformations and mapplets to implement the business logic for loading to the target database
• Performance tuning of mappings, transformations and sessions to optimize session performance
• Implemented error handling mechanisms in mappings
• Implemented autosys job for weekly/monthly load of data.

Environment: Informatica Power Center 7.1, Power Mart 6.1, Power Exchange, Power Connect, Oracle 10g, db2, SQL, MS SQL Server 2005 and flat files.