PROFESSIONAL SUMMARY:

• Having a 9 years of experience in Full life cycle of Software Development (SDLC) including Business Requirement Gathering & Analysis, System study, Application Design, Development, testing, Implementation, System Maintenance, Support and Documentation.
• Enterprise Data Warehousing: Experience and Expertise in ETL process Using Informatica Power Center 9.6.1/9.5.1/9.1.0/8.6/7.1.1/6. x, Informatica Data Quality 9.6.1/9.1.0 , Informatica Analyst 9.6.1/9.1.0 and Informatica Power Exchange 9.5.1.
• Expertise in implementing the XML and Web Service consumer Transformations.
• Experience and Expertise in ETL process (Informatica Power Center) Mappings, Mapplets, Transformations, Workflow Manager and Workflow Monitor. Also, Experience in Extraction / Transformation / Loading of legacy data to Data Warehouse using Informatica Developer9.1.0
• Experience CA Erwin Data Modeler and Erwin Model Manager to create Conceptual, Logical and Physical data models and maintain the model versions in Model Manager for further enhancements.
• Experience and Expertise in Operational Data Store (ODS) design, Data warehouse and mart design methodologies such as Star - schema, Snowflake, designing slowly changing dimensions and fact tables. Also, expertise in extracting data from different source systems like Oracle, TERADATA, XML, Flat files, SAP, SALESFORCE, Sybase and SQL Servers and loading into Data warehouse, DataMart’s & ODS systems.
• Implemented Various Performance Tuning techniques on Mappings.
• Implemented Slowly Changing dimensions Type 1, Type 2, and Type 3 methodology for accessing the full history of accounts and transaction information.
• Experience on Informatica Administration tasks like Informatica installation, upgradation, set up new users and collects informatica stats, logs.
• Good experience is maintaining the versioning and deployment instruction documents while moving the code to various environments.
• Good understanding of Data warehousing, ER Modeling and Dimensional Modeling concepts.
• Experience in providing On Call (24*7) Support for Production Problem Resolution (Resolve Production issues and problems in an expedited manner).
• Work experience on Perl, Shell scripts on AIX/Linux platform.
• Good working knowledge on RDBMS (Oracle, MS-SQL Server, Teradata, Greenplum).
• Good knowledge on writing the PL/SQL Scripts like Procedures, Triggers and Functions.
• Proficient in creating, configuring and managing Dashboards, Reports and Answers and troubleshoot various technical issues and bugs in OBIEE.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector, global and local Filters) using OBIEE Answers.
• Involved in Unit Testing and Data Validation for Developed Informatica Mappings.
• Proven ability to quickly learn and apply new technologies and have creativity, innovation, and ability to work in a paced environment.
• Team player with excellent communication and problem solving skills and exposed to various design and presentation tools like Visio and MS-Office utilities.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.6.1/9.1.0/9.5/9.6 , Informatica Data Quality 9.1, Informatica Power Exchange 9.1.0, Informatica Analyst 9.5.1

Data Modeling: CA Erwin, Dimensional Data Modeling, Star Schema, Snow-Flake schema, Fact & Dimensions Tables

Databases: Oracle 8.0/9i/10g/11g, SQL Server 2008 R2, My SQL, DB2, Teradata, Netezza, Greenplum.

OLAP Tools: OBIEE 10g, 11g, Business Objects.

Programming Language: Java, SQL, PL/SQ, C++, SharePoint.

Environments: UNIX and Windows

Tools and Utilities: Toad, SFG(Sterling File Gateway),CTRL-M,UC4, Autosys, TWS, Salesforce application (SFDC)

Scripting Language: Perl, Bash Shell Script and Batch Script.

ASSIGNMENTS EXPERIENCE:

Sr Data Integration Developer

Confidential, Bartlesville

Responsibilities:

• Participated into business requirements and gatherings for each module of the system from functional teams.
• Prepared functional spec and ETL high level/Low level design documents.
• Prepared the data analysis reports, score cards, profiles and Human tasks using informatica developer.
• Created a LDM and logical data objects in informatica developer.
• Develop a SFG Router jobs in B2B console for fetch/deliver files from FTP and SFT sites to informatica server.
• Develop an ETL mappings using informatica power center and informatica data quality with different transformations.
• Extracted data from various heterogeneous sources like Oracle, SQL SERVER, Flat files, SAP ECC, SAP HANA, SAP BW, Sybase IQ and Salesforce and loaded the data to different DB systems.
• Created a web services provider jobs and provide the web services to third party applications.
• Created a web services consumer mapping for write to /read from web services.
• Created an informatica workflow jobs to run the informatica mappings to load data to DB systems.
• Develop a Perl/Shell scripts in UNIX to create a files and move files from one location to another location and email notification.
• Collaborated with different teams and do the unit test for informatica jobs with test data.
• Prepare change management request for migrate the informatica jobs to production.
• Build or update documentation to ensure standard procedures and knowledge transfer.
• On call production support activities for SFG and informatica production jobs and resolve Production issues in an expedited manner.
• Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation (Connected and Unconnected), Joiner Transformation, and Router Transformation, Web services Transformation, XML transformation, Normalizer Transformation and Java Transformation in Informatica
• Created a Batch script to pass database connections, parameter entries for source and target.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Coordinated with DBA for create sources, targets and views.
• Developed Batch scripts for doing automated file transfer to customer FTP.
• Created CTRL-M jobs in Batch IR to schedule the jobs.

Environment: Oracle 11i, Informatica Power Center 9.6, Informatica Data Quality, Informatica Analyst, SQL SERVER, SAP, Oracle, CTRL-M, Sterling File Integrator (SFG).

Sr ETL Informatica Lead/Developer

Confidential, New Jersey

• Understanding the Business requirements and prepared a functional spec.
• Extracted data from various heterogeneous sources like Oracle, SQL SERVER, Flat files.
• Worked with PMCMD command to start workflows, Start workflow from a specific task, Stop.
• Set up TWS jobs to run informatica workflows and Perl Scripts.
• Converted the logical data model into physical data model and communicated with DBA to implement the Physical Database.
• Responsible for data mapping, metadata maintenance and enhancing Conceptual, Logical and Physical data models.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings & implement data warehouse.
• Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation (Connected and Unconnected), Joiner Transformation, and Router Transformation, Web services Transformation, XML transformation, Normalizer Transformation and Java Transformation in Informatica
• Created a Batch script to pass database connections, parameter entries for source and target.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Coordinated with DBA for create sources, targets and views.
• Involved in create a data base tables and views in SQL SERVER using Erwin.
• Developed Batch scripts for doing automated file transfer to customer FTP.
• Migrated the code from DEV repository to QA and then to PROD Repositories while in our monthly releases.

Environment: Oracle 11i, Informatica Power Center 9.6, Informatica MDM, Informatica Analyst 9.1.0,SQL SERVER, ER Win, Quick view, TWS

Sr ETL Informatica Lead/Developer

Confidential, New York

• Understanding the Technical Spec and Develop an ETL process to load data from source to target.
• Involved in requirement gathering, user meetings, discussing the issues to be resolved and translated the user inputs into ETL design documents. 
• Extracted data from various heterogeneous sources like Oracle, SQL SERVER, Flat files.
• Worked with PMREP command to get list of object details(Workflow,Source,Target,Mapplet, Transformation, Work let, Stored Procedures, Reusable Sessions, All Folders, List of users conn-Listing Tables by Session, Listing Dependencies), Export Object, find checkouts, connections, Validate, Modify Folder Owner and Permission. Object Import.
• Worked with PMCMD command to Start workflows, Start workflow from a specific task, Stop.
• Designed the conceptual data model and worked with the Business analysts and technical teams to design and update the logical data model in various iterations.
• Converted the logical data model into physical data model and communicated with DBA to implement the Physical Database.
• Responsible for data mapping, metadata maintenance and enhancing Conceptual, Logical and Physical data models.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings & implement data warehouse.
• Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation (Connected and Unconnected), Joiner Transformation, and Router Transformation, Web services Transformation, XML transformation, DT, Normalizer Transformation and Java Transaformation in Informatica
• Working on Informatica Developer(Informatica Data Quality)9.5.1 and Informatica Analyst9.5.1 to cleanse and profile the data
• Created a Batch script to pass database connections, parameter entries for source and target.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Coordinated with DBA for create sources, targets and views.
• Involved in create a data base tables and views in SQL SERVER using Erwin.
• Developed Batch scripts for doing automated file transfer to customer FTP.
• Migrated the code from DEV repository to QA and then to PROD Repositories while in our monthly releases.
• Involved in ETL loads (Enable/disabled) through Informatica Admin Console during all the monthly releases.
• Worked on XML generated files as targets.
• Created test cases and completed unit, integration and system tests for Data Warehouse and Data mart.

Environment: Oracle 11i, Informatica Power Center 9.5.2, Informatica data quality 9.1.0, Informatica Analyst 9.1.0,SQL SERVER, Erwin 9.x,Sales Force.

ETL Informatica Lead/Developer

Confidential, New York

• Leading as an onsite/offshore coordinator and lead team by providing ETL Technical/Functional documents and acted as a Point of Contact (POC) for the offshore team
• Responsible for requirement gathering, user meetings, discussing the issues to be resolved and translated the user inputs into ETL design documents. 
• Involved in monitoring the CPU servers and RAM of Informatica Nodes.
• Collected informatica stats, logs during the crash/ unexpected shutdown for nodes.
• Involved to Set up new users and set up the roles for the new users in Informatica Administration console.
• Extracted data from various heterogeneous sources like MySQL, Oracle, TEREDATA BTEQ, Flat files and used target as a Greenplum.
• Designed the conceptual data model and worked with the Business analysts and technical teams to design and update the logical data model in various iterations.
• Converted the logical data model into physical data model and communicated with DBA to implement the Physical Database.
• Responsible for data mapping, metadata maintenance and enhancing Conceptual, Logical and Physical data models.
• Enhanced existing Logical and Physical Data Models as per the requirements
• Identified the fact tables, dimensions and the key measures.
• Responsible for data modeling and building a star schema model in Erwin.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings & implement data warehouse.
• Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation (Connected and Unconnected), Joiner Transformation, and Router Transformation, Web services Transformation, XML transformation, DT and Normalizer Transformation in Informatica
• Working on Informatica Developer(Informatica Data Quality)9.0.1 and Informatica Analyst9.0.1 to cleanse and profile the data
• Created shell script to pass database connections, parameter entries for source and target.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Coordinated with DBA for tuning sources and targets and calculating table space and growth of database.
• Developed shell scripts for doing automated file transfer to customer FTP.
• Migrated the code from DEV repository to QA and then to PROD Repositories while in our monthly releases.
• Worked on Oracle BI Answers to build Interactive Dashboards with drill-down capabilities in OBIEE.
• Prepared a technical documentation and SOP’s for the existing system.
• Involved in ETL loads (Enable/disabled) through Informatica Admin Console during all the monthly releases.
• Worked on XML generated files as targets.
• Created test cases and completed unit, integration and system tests for Data Warehouse.
• Involved in Production support and ON-Call support.

Environment: Oracle 11i, Informatica Power Center 8.6, 9.1.0, 9.5.1, Informatica data quality 9.1.0, Informatica Analyst 9.1.0, UNIX and OBIEE 10.1.X, My SQL, TeraLoad BTEQ.

Sr. Informatica Developer

Confidential, New York

• Understanding the Technical Spec and Develop an ETL process to load data from source to target.
• Involved in designing the mappings between sources and targets and also tuned them for better performance.
• Worked with PMREP command to get list of object details, Workflow,Source,Target,Mapplet, Transformation, Export Object, find checkouts, connections, Validate, Modify Folder Owner and Permission. Object Import.
• Worked with PMCMD command to Start workflows, Start task, Stop, Abort workflows and Sessions, Schedule the workflows
• Created Migration Documentation and Process Flow for mappings and sessions.
• Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Aggregator Expression, Joiner, lookup, Filters, Router and update strategy.
• Scheduled and executed sessions, sequential and concurrent batches for proper execution of mappings; sent notification e-mails using Server Manager.
• Performed various update strategies using Lookup and Update Strategy transformations
• Created templates for presenting results and Analytics and modified the OBIEE Dashboards
• Implemented security object level to restrict users from accessing unauthorized object.
• Worked extensively on Answers to create the reports as per the Client Requirements.
• Done Unit Testing and prepared the parameter file for creating the connection’s in UNIX.
• Involved in Production deployments, Data purging etc.

Environment: Oracle 10g, Informatica Power Center 8.6, 9.1.0, 9.5.1, Informatica data quality 9.1.0, Informatica Analyst 9.1.0, UNIX and OBIEE 10.1.X, My SQL, SQL SERVER 2008