PROFESSIONAL EXPERIENCE:

• Over 7+ of experience in Business Requirements Analysis, Designing, coding and testing of Data Warehousing implementations across Financial, Insurance, Pharmaceutical and Educational Industries.
• Experience in building and managing various data warehousing/data marts using Informatica products such as Power Center, Power mart, Power Exchange for data models.
• Strong experience in performing ETL operations like Data Extraction, Data Transformation and Data Loading with Informatica Power Center and Informatica Power Mart (Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor).
• Involved in all aspects of the project and technologies (Informatica, Unix Scripts, and Business Objects Reports) and work with a team of Onsite and offshore build and Test resources.
• Strong knowledge on IDQ Mapping Designer, mapplet Designer, Transformation developer Designer, Workflow Manager and Repository.
• Experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Knowledge in OLTP/OLAP System Study and E - R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Enhanced performance for Informatica sessions by using physical pipeline partitions, DTM Session performance and Parameter Files.
• Have experience with IDQ, MDM with knowledge on Big Data Edition Integration with Hadoop and HDFS.
• Extensive experience in using tools like SQL Plus, TOAD, SQL Developer and SQL Loader.
• Experience in data modeling using designed tool Erwin 4.1/4.0 and worked with Oracle Enterprise Manager and Toad.
• Experience in Extracting data from Facets claims application to pull it into the Staging area.
• Experience in using Facets claim application to open, add generations, enter and save information
• Knowledge in extracting data from various sources like Oracle, DB2, Flat file, SQL SERVER, XML files, Teradata and loaded into Teradata, Oracle database.
• Strong understanding of Performance tuning in Informatica and Databases with Oracle Stored Procedures, Triggers, Index and experienced in loading data into Data Warehouse/Data Marts using Informatica.
• Hands on experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and PL/SQL stored procedures.
• Experience on data profiling & various data quality rules development using Informatica Data Quality (IDQ).
• Experienced in developing applications in Oracle and writing Stored Procedures, Triggers, functions, Views and creating Partitions for better performance.
• Extensive experience in oracle SQL. PL/SQL Programming. Experienced in writing and designing the SQL queries.
• Experience with Facets batches, HIPAA Gateway and EDI processing.
• Worked on IDQ tools for data profiling, data enrichment and standardization.
• Experience in development of mappings in IDQ to load the cleansed data into the target table using various IDQ transformations. Experience in data profiling and analyzing the scorecards to design the data model.
• SQL*Loader, Developed PL/SQL, SQL*Plus, Tuning using explain plan etc.
• Setting up ODBC connections, Batches and sessions to schedule the loads at required frequency using Power
• Center.
• Experience in UNIX Shell Scripting. Autosys, Control-M for scheduling the Workflows.
• Familiar with Agile development and waterfall methodologies.
• Ability to work in teams as well as individually, quick learner and able to meet deadlines Development experience

TECHNICAL SKILLS:

Operating Systems: Windows 7 Professional, Windows NT 4.0, Windows 2000 Server, Windows 2000 Advanced Server, Windows 2003 Server, Windows XP, Windows Vista, 7, UNIX and Mac OS

Software: C, Java, SQL, HTML, XML, Oracle 11g / 10g, MS SQL 2008, Teradata 13, MS Access, MSOffice 2010/2007

RDBMS: Oracle, MS SQL Server 7.0, 2000, 2008, DB2.

ETL Tools: Informatica Power Center

9.5.1/9.0.1/8.6.1/8.0.1/7.5/7.1, Control-M, IDQ, MDM, Autosys, SharePoint, Erwin

Reporting Tools: SQL Server Reporting Services(SSRS), Tableau, Power View, SharePoint 2007

Data Modeling Tools: Erwin, (Star schema/Snow flake)

Markup Languages: XML, HTML, DHTML.

Database Query Tools: SQL Server Execution Plan, MS SQL Server Query Analyzer, SQL Profiler, Red Gate SQL Data Compare, Red Gate SQL Data Generator, Red Gate SQL Search.

Version Control Tools: SVN, Team foundation Server, VSS

Atlassian Tools: JIRA, Confluence

PROFESSIONAL EXPERIENCE:

Confidential, Chattanooga TN

Informatica MDM Developer

Responsibilities:

• Integrated ActiveVOS into hub and made sure that default workflows are integrated. Deployed the default workflows manually if required.
• Created RESTful Web Services on IDD using provisioning tool which is used by third party applications for accessing the MDM Hub.
• Used 7+ address validators using different scopes by crossing the default limit of 3 address validators in one mapping. Changed the default behavior of address doctor.
• Used ETL process for cleansing, delta detection for minimizing the processing load on MDM before bringing in the data into landing tables.
• Worked on profiling the data using Developer/Analyst Tool for identifying the data integrity from different sources.
• Creating JAVA User Exits using SIF APIs to customize MDM Hub functionality.
• Used validation rules extensively(50+) above and beyond Informatica advised limited of around 27 for picking up right column by MDM.
• Developed mappings for loading the data from landing to the stage tables.
• Created the custom cleanse functions and configured custom as well as default cleanse functions into mappings.
• Defined Match rules in Match and Merge settings of the base tables by creating Match Path Components, Match Columns and Rule sets.
• Used SIF API's (GET, SearchMatch, PUT, CleansePut, ExecuteBatchDelete etc.) to test search, update, cleanse, insert and delete of data from SoapUI.
• Configured match rule set filters for meeting the different data scenarios using SQL filter, segment matching/Segment all matching and non-equal matching.
• Performed match/merge, ran match rules to check the effectiveness of MDM on data, and fine-tuned the match rules.
• Involved in analyzing different modules of facets system and EDI interfaces to understand the source system and source data.
• Accepted inbound transactions from multiple sources using FACETS.
• Supported integrated EDI batch processing and real-time EDI using FACETS.
• Created custom indexes using Register Custom Index SIF API for improving the performance of the load, match, and merge process.
• Installing and Configuring of Informatica MDM Hub Console, Hub Store Cleanse and Match Server Address of Informatica PowerCenter applications
• Implemented the pre-land and land process of loading the dataset into Informatica MDM Hub
• Configured and documented the Informatica MDM Hub to perform loading, cleansing, matching, merging and publication of MDM data
• Worked on Real Time Integration between MDM Hub and External Applications using SIF API for JMS
• Closely worked with Data Steward Team for designing, documenting and configuring Informatica Data Director and worked on IDD user exits.
• Worked independently on different claims systems - FACETS, NASCO, WGS.
• Worked on scheduling the load, stage, match, merge jobs in appropriate sequence.
• Used ActiveVOS for configuring workflows like one step approval, merge and unmerge tasks.
• Configured static lookups, dynamic lookups, bulk uploads and Smart search in IDD.
• Worked provision tool for custom configuring various views as part of entity 360 view for different roles.
• Configured JMS Message Queues and appropriate triggers for passing the data to the contributing systems/receiving downstream systems.

Environment: Multi-Domain MDM 10.1, IDD, Oracle 11g, Oracle PL/SQL, Windows Application Server, JBoss Application Server, ActiveVOS, SIF API, Informatica Power Center 10.1, Provisioning tool, Address Doctor 5.1, PowerShell/Bat scripts.

Confidential, Norwood MA

Informatica MDM Developer

Responsibilities:

• Involved in leading and monitoring the team, assigning the task, reviewing the development activity and status calls.
• Produced detailed MDM design specifications consistent with the high-level MDM design specifications.
• Coordinated with ETL team for performing batch process to populate data from external source systems to landing tables in hub.
• Analyzed the source systems data for identifying integrity issues using Analyst Tool for profiling the Data.
• Provided the feedback to the stakeholders based on profiling results that helped determining the trust scores and validation rules.
• Configured Landing, staging tables and Base Object tables.
• Trust scores and validation rules are configured in the hub.
• Worked on integration of external application with MDM Hub using SIF APIs.
• Design, document and configure the Informatica MDM Hub to support initial data loads and incremental loads, cleansing.
• Worked on Address Doctor for cleansing addresses using Developer tool before feeding into landing tables.
• Analysis and implementation of existing claim adjudication process in FACETS.
• Used SOAP UI to perform SIF API calls like clean tables etc.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Defined Match rules in Match and Merge settings of the base tables by creating Match Path Components, Match Columns and Rule sets.
• Used filters, segment/segment all matching and non-equal matching.
• Performed match /merge and ran match rules to check the effectiveness of MDM on data and fine-tuned the match rules.
• Customized User Exists for deferent scenarios.
• Used Hierarchy tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles.
• Data integration with claim processing engine (Facets).
• Closely worked with Data Steward Team for designing, documenting and configuring Informatica Data Director.
• Used Native BPM for configuring workflows like One-step approval, merge and unmerge.
• Used Repository Manager/Change List for migrating incremental as well as bulk meta-data.

Environment: Multi-Domain MDM 9.7, IDD, Address Doctor, Oracle 11g, Oracle PL/SQL, SIF API, Windows Application Server, Native BPM.

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Worked closely with Development managers to evaluate the overall project timeline.
• Interacted with the users and making changes to Informatica mappings according to the Business requirements.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers and data flow management into multiple targets using Router.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Lookup, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level.
• Involved in standardization of Data like of changing a reference data set to a new standard.
• Data if validated from third party before providing to the internal transformations should be checked for its accuracy (DQ).
• Used Address validator transformation in IDQ.
• Involved in massive data profiling using IDQ (Analyst tool) prior to data staging.
• Created partitioned tables, partitioned indexes for manageability and scalability of the application. Made use of Post-Session success and Post-Session failure commands in the session task to execute scripts needed for cleanup and update purposes.
• Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS, Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
• Extensively used the Business Objects functionality such as Master-Detail, Slice and Dice, Drill Down and Hierarchies for creating reports.
• Implemented slowly changing dimensions Type 2 using ETL Informatica tool.
• Designed best practices on Process Sequence, Dictionaries, Data Quality Lifecycles, Naming Convention, and Version Control.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Use-Case Documents to explain and outline data behavior.
• Working with Informatica Developer (IDQ) tool to ensure data quality to the consumers.
• Used Address validator transformation for validating various customers address from various countries by using SOAP interface.
• Created PL/SQL programs like procedures, function, packages, and cursors to extract data from Target System.
• Involved in deployment of IDQ mappings to application and to different environments.
• Defects are logged and change requests are submitted using defects module of Test Director.
• Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance.

Environment: Informatica Power Center 9.5/9.1, IDQ, SAS, Business Objects 3.1, Oracle 11g, UNIX, PLSQL, SQL* PLUS, SQL SERVER 2008 R2, TOAD, MS Excel 2007.

Confidential, IN

Informatica Developer

Responsibilities:

• Involved in requirements gathering from the Client/Onshore Counterparts.
• Involved in preparing LLDs (Low Level Design documents).
• Created Informatica Mappings to build business rules to load data.
• Involved in Development, Performance Tuning and Testing.
• Developed workflow, worklet and tasks like reusable Tasks (Sessions, Command, and Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control) to schedule the loads at required frequency using workflow manager.
• Created Parameter File to pass database connections for source and target.
• Extensively involved in writing and manipulating Teradata Macros.
• Worked with the Fast Load and Multi Load through the Informatica Connections.
• Worked on to generate the Ad-hoc reports for the business.
• Designed and developed IDQ solutions for data profiling and cleansing.
• Implemented Address Doctor as Address Validator transformation for data profiling in IDQ.
• Implemented Labeler and Standardizer transformation in IDQ for cleansing data.
• Implemented and modify the existing UNIX shell script as per the requirement
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Involved in the Unit testing.
• Tuning the Teradata SQL queries to improve the performance of the queries.
• Implemented Informatica Pushdown Optimization to Improve the Performance.
• Scheduled the Monthly, Weekly, Daily and Request Jobs in the Control-M Scheduler.
• Prepared Run books providing guidelines to troubleshoot the errors occurred during the run time and instructions on how to restart the loads.
• Involved in peer reviews for all the code for the Deployments.
• Taken care of the Production Deployments Efficiently.

Environment: Linux, Windows, Informatica 8.1.1, IDQ, AbInitio, Oracle 10g, Teradata, Control-M

Confidential

Associate Software Engineer

Responsibilities:

• Used update strategy to effectively migrate data from source to target.
• Moved the mappings from development environment to test environment.
• Designed ETL Process using Informatica to load data from Oracle, Flat Files to target Oracle Data Warehouse.
• Interacted with the business community and database administrators to identify the Business requirements and data realties.
• Created various transformations as per the business logic like Source Qualifier, Normalizer, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression and Update Strategy.
• Created design document Informatica mappings based on business requirement.
• Created Informatica mappings using various Transformations like Joiner, Aggregate, Expression, Filter and Update Strategy.
• Wrote stored procedures, functions, Packages and used in many Forms and Reports.
• Wrote database triggers for automatic updating the tables and views.
• Involved in the performance improvement project.
• Involved in designing of testing plan (Unit Testing and System Testing).
• Tested scripts by running workflows and assisted in debugging the failed sessions.
• Improving workflow performance by shifting filters as close as possible to the source and selecting tables with fewer rows as the master during joins.
• Used persistent caches whenever data from workflows were to be retained.

Environment: Informatica Power Center 7.1/8.1.1, Oracle 9i, Flat Files, OBIEE, PL/SQL, UNIX, Autosys, ERWIN, TOAD, UNIX Shell Scripting.