SUMMARY

• Over 12 years of experience in Informatica cloud, IICS, ICRT,Informatica Power Center10.2.1/9.x/8.x/7.x/6.x/5.x, Work flow Designer, Workflow Manager, Workflow Monitor and Mapping Designer, Confidential .
• Proficient in all phases of the Software Development Life Cycle (SDLC) In Data Warehousing
• Requirements Gathering, Data Scrubbing, Design, Development, Performance Tuning and Unit Testing.
• Experience in Informatica Cloud services and Informatica cloud real time (ICS/ICRT)
• Having good knowledge on web services like SOAP and REST based API’s
• Excellent in coding SQL, PL/SQL Procedures, Functions, Triggers and Packages.
• Experience in ETL Design, Entity - Relationship Modeling and Dimensional Modeling.
• Developed Slowly Changing Dimension Mappings of Type I, and II .
• Extensively involved in creating Complex Mappings and reusable components like Reusable Transformations, Mapplets, Worklets and control tasks to implement reusable business logic.
• Profile source data and determine all source data and metadata characteristics; Design and execute a Data Quality Audit/Assessment; Design and execute the data quality mappings that will cleanse, de-duplicate, and otherwise prepare the project data
• Implement data quality processes including transliteration, parsing, analysis, standardization and enrichment at point of entry and batch modes; Deploy mappings that will run in a scheduled, batch, or real-time environment.
• Document all mappings, mapplets, and rules in detail and hand over documentation to the customer
• Collaborate with various business and technical teams to gather requirements around data quality rules and propose the optimization of these rules if applicable, then design and develop these rules with IDQ
• Designed mappings using Source qualifier, Joiner, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy transformations and Mapplets to load data into the target involving slowly changing dimensions.
• Worked with the Salesforce source system application (Veeva Data)
• Proficient in SQL Tuning to ensure best query performance.
• 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
• Expertise in using ERwin, MS Visio, Oracle Designer to design process flow diagrams.
• Extensive experience in Administration/maintenance of Informatica Power Center including Installation, upgrading and patching.
• Experience in Master Data Managementconcepts, methodologies and ability to apply this knowledge in building MDM solutions.
• Assisted in Data modelling by creating Star schemas using MS Visio and Erwin tools.
• Developed business rules for cleansing/validating/standardization of data.
• Defined System Trust and Validation rules for the base object columns.
• Excellent experience in creating UNIX scripts.
• Extensively worked with Confidential utilities like BTEQ, Fast Export, Fast Load, Multi, TPump, TPT to Export and Load data to/from different source systems including flat files.
• Worked with different dataset like XML, JSON
• Written several Confidential BTEQ scripts to implement the business logic.
• Worked on TSQL queries.
• Involved in the admin activities of informatica
• Worked with informatica Power exchange and Informatica cloud to integrate salesforce and load the data from salesforce to oracle Db
• Inter operability of integration, efficient provisioning and monitoring using Informatica Cloud.

TECHNICAL SKILLS

ETL: Informatica Power Center 9.5/9.1/8.6/8.5/8.1/7.1

Data quality Tools: Informatica Data Quality 9.5.1/9.6.1/ Informatica MDM

Operating System: Unix, Windows NT/2000/XP

Reporting tools: Qlilkview 11

DBMS: Oracle11g/10g/9i, Sql Server 2005/2008, Confidential 11/12/13

Data modelingtool: Erwin,Oracle Designer 10g, MS Visio 2010

Data Base Tools: SQL* Loader, TOAD, PL/SQL Developer, SQL Developer

Languages: PL/SQL, UNIX Shell Scripting

ITIL TOOLS: Service now

Languages: PERL 5.8, Unix Shell script

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

Sr. ETL Informatica Developer

Responsibilities:

• Designs, develops and maintain Enterprise Data warehouse (EDW), ODS and MDM systems. Enhance processes by applying Informatica performance improvement techniques to maximize utilization and performance.
• Design, develop and prototyping new system requirements utilizing Informatica, Oracle, EDQ, UNIX, Shell Scripts and other tools.
• Develop review UNIX shell scripts, automate ETL processes; perform database modeling, design &implement data warehousing, data marts, Star, SnowflakeSchemaModeling, dimensional modeling on OLTP and OLAP concepts.
• Write post SQL, pre-SQL scripts/commands at session level; write queries, stored procedures and functions.
• Perform daily project functions with a focus on meeting the business objectives on time in rapidly changing work environment.
• Enhance/re-architect existing components to satisfy new performance and scalability requirements.
• Design & Develop Informatica mappings, sessions, workflows and ETL loads, build PLSQL code, UNIX Shell scripts for the requirements received as part of value adds. Automate/ Tune existing code base of ETL objects for performance improvement.
• Performance tune SQL queries and information code base to improve overall application performance.
• Formulate, define scope & objectives through fact-finding by interfacing between the business and the development team; store, retrieve as well as manipulate data for analysis of system capabilities and requirements
• Review prototypes develop iterative revisions, make recommendations & design ETL architecture.
• Interact with multiple teams combined with translate reported problems/issues into JIRA items to implement to meet enterprise standards.
• Maintain highest levels of software quality along withstability through continuous improvement of the SDLC.
• Build maintain design standards along with best practices to ensure the team adhere to these standards

Confidential, Sandiego, CA

Sr. ETL Informatica Developer

Responsibilities:

• Extensive experience in Informatica cloud,IICS,ICRT, Informatica (9.x) applications. Designed and developed the Workflows, Worklets, Mappings, Mapplets, Sessions, Tasks, Transformations and schedule the Workflows and Sessions.
• Designed and created complex source to target mapping using various transformations inclusive of but not limited to Lookup, Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
• Expertise in using different tasks (Session, Assignment, Command, Decision, Email, Event-Raise, Event- Wait, Control).
• Attended Business meetings and suggested MDM solutions for various Business scenarios.
• Developed business rules for cleansing/validating/standardization of data
• Performed Data cleansing using external tools like Name Parser and Dataflow.
• Implemented real-time integration with MDM HUB using real-time batch processing for business data coming from four source systems.
• Optimized Query Performance, Mapping Performance, Session Performance and Reliability.
• Used Informatica PowerCenter 9.5.1 to Extract, Transform and Load data into Netezza Data Warehouse from various sources like Oracle and flat files
• Extracting the Data from the sales force source systems and loading In to respective targets as per the business rules.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation (Slowly Changing Dimensions SCD Type-2).
• Handled Mater Data Management (MDM) Hub Console configurations like Stage Process configuration, Load Process Configuration, Hierarchy Manager Configuration.
• Implemented Source Pre-Load, Source Post-Load, Target Pre-Load and Target Post-Load functionalities.
• Extensive Performance Tuning of Sources, Targets, Mappings and Sessions.
• Used Debugger and breakpoints to view transformations output and debug mappings.
• Used UNIX commands (Vi Editor) to perform the IBM Netezza load operations
• Strong experience with Informatica tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations Developer, Informatica Repository.
• Created queries and packages in the MDM (Master Data Management) HUB Console.
• Designed and developed complex mappings to move data from multiple sources into a common target area such as Data Marts and Data Warehouse using lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Sequence Generator, Update Strategy from varied transformation logics in Informatica.
• Worked with Netezza/ Confidential Database to implement data cleanup, performance-tuning techniques
• Having strong hands on experience in extraction of the data from various source systems ranging from Mainframes like DB2, Flat Files, JSON/XML files, VSAM files, etc. to RDBMS like Oracle, SQL Server, Confidential etc.
• Creating SWAGGER files to invoke the web services

Confidential, Dearbon, MI

Sr. ETL Informatica Developer

Responsibilities:

• Extensive experience in Informatica cloud, Informatica (9.x) applications. Designed and developed the Workflows, Worklets, Mappings, Mapplets, Sessions, Tasks, Transformations and schedule the Workflows and Sessions.
• Interacted with end-users and functional analysts to identify and develop Business Specification Documents (BSD) and transform it into technical requirements.
• Strong experience with Informatica tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations Developer, Informatica Repository.
• Designed and developed complex mappings to move data from multiple sources into a common target area such as Data Marts and Data Warehouse using lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Sequence Generator, Update Strategy from varied transformation logics in Informatica.
• Having strong hands on experience in extraction of the data from various source systems ranging from Mainframes like DB2, Flat Files, JSON/XML files, VSAM files, etc. to RDBMS like Oracle, SQL Server, Confidential etc.
• Creating SWAGGER files to invoke the web services
• Creating Business Services to connect the REST V2, WSConsumer connectors
• Creating REST and SOAP based API’s using Informatica services, process objects to expose DB data
• Implemented Stored Procedures, Functions, views, Triggers, Packages in PL/SQL.
• Extensively used Slowly Changing Dimension (SCD) technique in insurance application. Expertise in OLTP/OLAP System Study, Analysis, E-R modeling, developing Dimensional Models using Star schema and Snowflake schema techniques used in relational, dimensional and multidimensional modeling.
• Worked on optimizing the mappings by creating re-usable transformations and Mapplets. Created debugging and performance tuning of sources, targets, mappings, transformations and sessions.
• Inter operability of integration, efficient provisioning and monitoring using Informatica Cloud.

Environment: Informatica Power Center 9.6,, Qlik view XI,Salesforce, Informatica Cloud Confidential 13.0, PL/SQL, SQL*Loader, UNIX, IDQ,Servicenow