SUMMARY:

• Over Eight years of experience in Information Technology including Data warehousing, RDBMS, Client Server applications.
• Eight years of data warehouse experience using Informatica Power Center 9.x/8.x/7.x/6.x/5.x and ETL Concepts.
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Involved in creating Dimensional Data Modeling and creating Fact table and Dimensional tables.
• Experienced in OLTP/OLAP system study, analysis and ER modeling, developing Database schemas like Star schema and Snowflake schema used in relational and multidimensional modeling.
• Extensive experience in extraction, transformation and loading of data directly from various data sources like flat files, Excel, SQL Server, Sybase, Teradata, DB2 and Oracle.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Well versed in OLTP Data Modeling, Data warehousing and Datamart concepts.
• Experienced with complex mappings from varied transformation logics like Unconnected and Connected lookups, Router, Aggregator, Joiner, Update Strategy and re-usable transformations.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Working experience in using Oracle, SQL Server, Teradata, PL/SQL, SQL Loader, TOAD, ERWIN.
• Experience in using different kind of Partitions for the better performance and fast retrieval of data from the Database.
• Extensively used Partition by Range, Partition by Hash Function, Sub Partition, List Partitions.
• Extensive experienced in writing stored procedures (PL/SQL), triggers, Functions and Packages.
• Experience in using the Informatica command line utilities like PMCMD to control workflows in non-windows environments.
• Experienced in creating Jobs, Alerts using SQL Mail Agent. Well versed in various high availability solutions like clustering, mirroring, log shipping.
• Experiences in devising Disaster recovery strategies and effectively testing them. Experience in managing security, creating security policies and rules.
• Moved Data from external source into Oracle Database using SQL Loader.
• Experience of TPT loader utilities.
• Have hands-on experience on Informatica Data Quality (IDQ).
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Experience of designing strategies to maintain audit tables, load balance, exception handling and high data volumes.
• Experience of scheduling the jobs in B2B, CA7 and Autosys.
• Good exposure to Development, Testing, Debugging, Implementation, Documentation, End-user training and Production support.
• Experience with software development life cycle (SDLC) and project management methodologies.
• An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hard working and high level of motivation. A quick learner with an aptitude for taking responsibilities.

TECHNICAL SKILLS:

Languages: Shell Scripting, PL/SQL, PERL, JAVA, .NET

Databases: Oracle11g/10g/9i/8i/7x, MS SQL Server 2008/2005/2003/2000, Teradata, Sybase15/12.0/11.x/10, DB2,UDB 7.2, My SQL 5.0/4.1,MS Access 2003/2000/97/7.0. Editors ( SQL Navigator, Toad)

Operating Systems: UNIX, Windows 7/XP/2000/98,Win NT

ETL: Informatica Power center 9.x/8.x/7.x/6.x/5.x. Power Exchange 8.x/7.x, Metadata Manager, Informatica PowerMart 7x/6x, IDQ, B2B Data Exchange.

Web Technologies/ Tools: XML, XHTML, HTML, VBScript

Data Modeling: ERWIN 4.x/3.x, Star Schema, Snow Flake Schema, Extended Star Schema, Physical And Logical Modeling, Dimension Data Modeling, Fact Tables, Dimension Tables, Normalization, De-normalization

Reporting Tools: MS SQL Server Reporting services 2005, Business Objects XI, Cognos

PROFESSIONAL EXPERIENCE:

Confidential, Roseland, NJ

Senior Informatica Developer

Responsibilities:

• Preparing the TDD docs based on FSD and Data Dictionary documents.
• Involving the design of the project and provide the design solutions if required.
• Extracts data from Flat Files and DB2 database and applies business logic to load them in the STD and RDS.
• Resolve all development issues and responsible to delivery the code in time.
• Review the development work and release docs before hand over to Deployment Team.
• Develops map, reusable objects, transformation, and Mapplets using Mapping Designer, transformation developer and Mapplets Designer in Informatica Powercenter 9.6.
• Created reusable transformations and Mapplets and uses them in mappings.
• Uses Informatica Powercenter 9.6 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Used TPT loader utilities for better performance.
• Works with data modelers to prepare logical and physical data models and adds and deletes necessary fields using Erwin.
• Implemented Informatica recommendations, methodologies and best practices (Value Adds).
• Developed the IDQ components.
• Import the IDQ components to Powercentre mappings as part of data quality profiling.
• Used Informatica B2B and Autosys to create jobs to run the workflows.
• Exported the workflows in B2B and created end points in B2B to trigger the workflows.
• Created complex mappings in Powercenter Designer using aggregate, expression, filter, and sequence generator, update strategy, union, lookup, joiner, XML source qualifier and stored procedure transformations.
• Used transformations such as router, aggregator, normalizer, joiner, expression, lookup, update strategy and sequence generator, and procedure.
• Developed PL/SQL and UNIX Shell Scripts to scheduled sessions in Informatica B2B and Autosys.
• Created e-mail notification tasks using post-session scripts.
• Worked with command line program PMCMD to interact with server to start/stop sessions and batches, stop Informatica server and recover the sessions.
• Wrote SQL, PL/SQL, stored procedures, triggers and cursors to implement business rules and transformations.
• Created procedures to drop and recreate indexes in the target data warehouse before and after sessions.
• Created deployment groups and migrates code into different environments.

Environment: Informatica 9.6.0, AML, Autosys, DB2, Oracle 11g/10g, Teradata, PL/SQL, B2B Data Exchange, IDQ, TOAD, Windows XP ERWIN 4.2 and UNIX.

Senior Informatica Developer

Responsibilities:

• Have worked on POC on Power Exchange CDC, XSLT, and Informatica Data Transformation.
• Have involved in Architecture of the project.
• Have solved all development issues.
• Review the development work and release docs before hand over to Service Team.
• Analyzed the business requirement document and created functional requirement document mapping for all the business requirements.
• Designed and Developed ETL mappings using transformation logic for extracting the data from various sources systems.
• Automated the load process using UNIX shell scripts.
• Used heterogeneous files, flat files, XML files, Teradata and oracle as sources.
• Involved in tuning the SQL statements to optimize the performance.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Created reusable objects in Informatica for easy maintainability and reusability.
• Performed the data validations and control checks to ensure the data integrity and consistency.
• Extensively used debugger to trace errors in the mapping.
• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures.
• Involved in developing test plans and test scripts to test the data based on the business requirements.
• Created source, target, transformations, sessions, batches and defined schedules for the sessions.
• Re-designed ETL mappings to improve data quality.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Modifying the shell/Perl scripts as per the business requirements.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Partitioned sessions for concurrent loading of data into the target tables.
• Used the IDQ reusable components in Mappings.
• Scheduled the jobs in B2B Data Exchange.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Used Shell Scripting to automate the loading process.
• Co-ordinate between different teams across circle and organization to resolve release related issues.

Environment: Informatica 9.1.0, Informatica Power Exchange, Teradata, Oracle, Informatica Data Transformation, B2B Data Exchange, XSLT, UNIX and Windows XP.

Senior Informatica Developer

Responsibilities:

• Interaction with the Client, Data Modelers and Business Users to gather the requirements and assign work to offshore team.
• Involved in Design Phase and prepared Macro and Micro documents.
• Reviewed IDD & Data Mappings documents.
• Designed and developed reusable components.
• Reviewed the development work and prepared release docs.
• Have involved in ST, SIT, UAT and PROD Support.
• Have involved in PROD remediation process and prepared remediation documents.
• Analyzed Business and Systems Requirements documents and other documents as a preparation for the creation of required System Design Documents.
• Involved in Dimensional Data Modeling design and populating the Business rules into integrated data warehouse.
• Created logical and physical data models for Business users to determine data definitions and establish referential integrity of the system.
• Experience of working on Fact Tables and Dimensional tables.
• Extensively used and created Complex Mappings using Source Qualifier, Aggregator, Expression, Joiner, Lookup, Router, Filter and Stored Procedure transformations.
• Used Star schema for the data warehouse.
• Created and Monitored Sessions using Informatica Powercenter. Designed Sequential and concurrent workflows for whole process.
• Migrated the objects between various repositories and maintained the repository.
• Involved in working with heterogeneous data sources like flat files, Teradata, DB2 and Oracle.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the activities.
• Tuned the SQL queries used in the SQL overrides of the Source Qualifiers.
• Wrote SQL, PL/SQL, Stored procedures, triggers and packages.
• Used TPT load utilities for better performance.
• Reused IDQ components.
• Constantly assisted Business Users in data validations for any data issues observed and mismatches.
• Involved in Unit testing, system testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Worked with CA7 Scheduling team to schedule jobs daily and weekly based on Feedback from Business Analysts.

Environment: Informatica 9.1.0, UNIX, CA7, Teradata, Oracle and Windows XP.

Informatica Developer

Responsibilities:

• Monitoring and Supporting to QA, PPE and Production.
• Importing & exporting mapping folders into Clearcase.
• Creating & fixing the Defects and updating the status in Mercury Quality Center or Test Director.
• Creating and executing the regression test cases for insert, update & Delete for every mapping and export into Clearcase.
• Creating the Test Fixtures for Regression Test cases and export into Clearcase.
• Exporting the xml files, source files and Parameter files into Clearcase for Regression Testing.
• Installing the build and refreshing the database for every week.
• Participating the Team meetings and weekly status meetings.
• Preparing the weekly status report.
• Extracting data from flat and relational sources and Transform the data into Oracle target data warehouse.
• Designing & Developing the Mappings and reusable Transformations.
• Created Sessions and Workflows to schedule ETL mappings.
• Most of the transformations were used like the Expression, Source qualifier, Aggregators, Connected & unconnected lookups, Filters & Sequence.
• Involved in ETL Unit Testing & Integrating Testing.

Environment: Windows XP, Unix, Informatica, Oracle 9i and Mercury Quality Center 9.0.

Informatica Developer

Responsibilities:

• Interaction with the Client and Business Users to meet the requirements.
• Performed major role in Sybase Upgrade from 12.5.4 to 15.0.1. Completely responsible for testing the complete batch.
• Performed major role in under standing the business requirements and designing the feeds for loading the data into target database.
• Used Informatica Power Centre to load data from different sources (external files and databases) to the Target tables.
• Extensively used transformations like the Source Qualifier, Expression, Filter, Aggregator, Look Up, Joiner, Sequence Generator, Sorter, Rank and Router.
• Created various Sessions and Workflows depends on the flow of the feeds (data).
• Tuning mappings and sessions for better performance.
• Created numerous stored procedures & packages based on the requirement.
• Have made changes to the existing Perl/Shell scripts.
• Used Subversion for version control for the scripts.
• Used Autosys as a scheduler for executing various tasks (Informatica workflows, Perl/Shell scripts, database procedures) and Created JIL's (Job Information Language) for passing the commands to Autosys jobs.
• Preparation of technical document based on the functional requirements.
• Actively participated in pre & post release activities.
• Played a major role in Informatica migration team from 8.1.1 to 8.6.1(version 8.1.1 is not certified for RHEL 5). Completely responsible for testing the complete batch.
• Have extended the role to L3 support and resolved many business critical production issues.
• Leading/Mentoring junior & new resources in the project.

Environment: Informatica 8.6.1, Sybase 15.0.1, Oracle 10g, Autosys, UNIX and Perl/Shell, Subversion, Toad, DBArtisan, Test Director, ITG (IT Governance Center) and Windows XP/W7.