SUMMARY:

• Over 9+years of experience in designing procedures, structures and developing the artifacts with the available semantics to build automated systems in the field of Information Technology.
• Proficient in business analysis, technical design, implementation, testing and support in data warehousing, business intelligence and data integration projects.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Able to coordinate and direct all phases of project based efforts while managing and leading project team and excellent on onsite offshore model coordination.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Experience in installation and configuration of core Informatica MDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter in Windows.
• Good understanding in entity relationship and Data Models.
• Expertise in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
• Solid understanding of Informatica MDM design principles and good practical knowledge of performing MDM design processes through Informatica MDM.
• Experience in using SQL developer, SQL*Plus, Procedures/Functions and Performance tuning
• Experience in Agile, Waterfall methodology
• Experienced in integration and transforming of various data sources from Databases like MS Access, Oracle, DB2, SQL Server and formats like flat-files, COBOL files, XML, etc.
• Experienced in Data Modeling, Star / Snowflake schema modeling, Fact and Dimension Tables, Physical and Logical data modeling.
• Experience in leading, and onsite/offshore co-ordination.
• Data modelling experience in using Erwin/Power Designer for Dimensional Data modelling and Star/Snowflake Schema modelling
• Knowledge of coding ETL Tasks in UNIX Shell scripts.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
• Experience in using Autosys and Informatica Scheduler for scheduling Workflow sessions.
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experienced with Informatica Data Explorer (IDE) / Informatica Data Quality (IDQ) tools for Data Analysis / Data Profiling.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Experience in installation and configuration of core Informatica MDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter in Windows and Good understanding in entity relationship and Data Models.
• Worked with Informatica Developer and Analyst tool to create/manage DQ rules, scorecard, rule/column profiling and DQ transformations like matching, address validation, parser, standardization etc.
• Strong Experience in Informatica - Design, Work Flow Manager, Repository Manager, Monitor and other tools used in the Transformation and Mapping, Migration, Transaction and Batch processing.
• Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modelling.
• Experience in Agile development environment and participated in Scrum meetings.
• Prepare project estimates, delegation of tasks and duties to team members.
• Excellent time management skills with reputation of meeting deadlines.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• ETL Development / Architecture experience using Informatica Power Center/Power Mart (Source Analyzer, Repository Manager, Server Manager, Mapping Designer, and Workflow Monitor).
• Experience in using Autosys and Informatica Scheduler for scheduling Workflow sessions.
• Extensively worked with Oracle, PL/SQL Stored Procedures, and Functions and involved in Query Optimization.

TECHNICAL SKILLS:

ETL Tools: Informatica 10.x/9.x/8.x/7.x/6.x (Power Center/Developer/Informatica cloud).Database: Oracle 11g /10g/9i/8i/7.x, SQL Server 2005/2000.

BI Tools/Analytics: OBIEE 11.1.1.x, 10.1.3.x.Tableau Desktop, Tableau Server Versions 9.2, 9.0, 8.1, 8.0.

Scheduling Tools: Tidal,DAC, Autosys, Control M.

MDM Tool: Informatica Multi domain Edition 10x, 9.7.1/9.1.0/9.0.1

Methodologies: Data Modelling, Logical/Physical, Star/Snowflake Schema, FACT &Dimension Tables, ETL, OLTP/OLAP, Software Development Life Cycle (SDLC)

Languages: SQL, PL/SQL, HTML, XML

Oracle Tools/Utilities: SQL*Loader, Oracle Designer, SQL Developer, TOAD, SQL Navigator, JDeveloper, Oracle Developer 2000

Scripting Languages: JavaScript, VBScript and UNIX shell script

Operating System: Win 95/98/2000/XP, Win NT 4.0, UNIX/LINUX

Big data: Hadoop

PROFESSIONAL EXPERIENCE:

Confidential, Nashua, NH

Sr. Informatica MDM/ETL Developer

Responsibilities:

• Involved in Requirement gathering from business users and translated them into technical specifications.
• Performed Extraction, Transformation and loading of data using Informatica Power Center and Transformation Developer
• Worked on Informatica tools Source Analyzer, Warehouse designer, Mapping Designer and Workflow Manager, workflow monitor,Created Reusable Transformations and Mapplets to use in Multiple Mappings
• Worked on Autosys Tool scheduling jobs, ETL Framework Using SSM Tool and Informatica Data Director.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Used Debugger to fix the defects/ errors and data issues.
• Expertise in using both connected and unconnected Lookup Transformations.
• Converted procedures into mappings using various transformations like Source Qualifier, Expression, sorter, Update Strategy, Filter, Lookup, Aggregator, etc.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Conversions.
• Participated in a group responsible of coming up with different technical Ideas, developing a proof of concept for the use of the MDM Implementation team
• Providing Logical/Physical data model for Informatica MDM implementation.
• Configured Informatica MDM hub.
• Interacted with the SME to implement requirements without affecting performance of the process.
• Currently adapting agile methodologies for our project.
• Presented hub solutions for a Multi-Domain Party model MDM for Insurance customers and distributors and presented the results of the POC to Business and IT Sponsors.
• Configuration of IDQ tool for source data profiling and data quality Audit
• Written Shell Scripts for validating FTP Flat files. Developed Unix Shell scripts to automate the data load processes to target data warehouse.
• Experience in cratering Autosys job,monitoring and scheduling jobs.
• Assisted in configuration, development and testing of Autosys JIL and other scripts.
• Scheduled and monitored the daily Informatica incremental loads through the Autosys Scheduler.
• Involved in performance tuning by setting Cache, limiting the number of initialization blocks, limiting select table types, pushing the calculation to the database.
• Provided end-user training and documentation and second-line support to power users to develop dashboards, reporting metrics and reports.

Environment: Informatica 9.1.6 Hotfix, OBIEE 11.1.1.5, ODI 12c/11g, DAC 10.1.3.4.1, Oracle 11g, Windows XP, SQL Developer, Informatica MDM, Autosys, ETL Framework.

Confidential, New jersey

Sr. ETL/ Informatica MDM Developer

Responsibilities:

• Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making.
• Worked in complete agile methodology.
• Worked with Data Modeller to understand the Business Requirements and Business Rules.
• Prepared ETL Specifications to help develop mapping.
• Designed and developed Informatica Mappings using Informatica cloud, power center and sessions based on business user requirements and business rules.
• Worked extensively on Source Analyzer, Mapping Designer, and Warehouse Designer and Informatica cloud.
• Configured and installed Informatica MDM Hub server, cleanse Server, resource kit in Development, QA, Pre-Prod and Prod Environments.
• Involved in gathering business requirements for the data-warehouse as well as business-intelligence reports to be used by the management.
• Analyzed the source system for integrity issues to the data resided in various source systems and defined thesame in Systems and Trust.
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDMfrom various source systems.
• Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• Configured Address Doctor which can cleanse whole world address Data and enhanced by making some modifications during installation
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Developed several Mappings using corresponding Sources, Targets and Transformations.
• Developed ETL Mappings in Informatica for data migration/conversion.
• Creating source and target table definitions using Informatica Designer. Source data was extracted from Flat files, SQL Server and DB2, Teradata Databases
• Analyzing the source data and deciding on appropriate extraction, transformation and loading strategy.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Created mappings to read from Flat files, DB2, Teradata and Oracle to load into RDBMS tables.
• Based on business Rules Debugged code, tested and validated data after processes are run in development.
• Used Tidal Job Scheduling software for batch Scheduling.
• Modified the existing mappings for the updated logic and better performance
• Developed Logical Data Flow Diagrams in Visio for every mapping that is developed.
• Assisted QA Team to fix and find solutions for the production issues.
• Used UNIX Shell scripts in coding ETL Tasks.
• Worked in Prod deployment using stash and Jenkins.
• Documented the workflow dependencies and ordering for Tidal job scheduling process.

Environment: Informatica 10.1/9x and Informatica cloud, Informatica MDM 10.x,Tableau 9.3.1. UNIX, Windows, Oracle 11g, PL/SQL, Flat Files and CSV, Shell Scripting, Putty, PL/SQL Developer, Tidal.

Confidential, NY

Informatica/Oracle Developer

Responsibilities:

• Worked with Data Modeller to understand the Business Requirements and Business Rules.
• Prepared ETL Specifications to help develop mapping.
• Extracted data from various sources (Flat files, SQLServer, Teradata, and DB2 Databases).
• Designed and developed Informatica Mappings and sessions based on business user requirements and business rules.
• Worked extensively on Source Analyzer, Mapping Designer, and Warehouse Designer
• Developed several Mappings using corresponding Sources, Targets and Transformations.
• Developed ETL Mappings in Informatica for data migration/conversion.
• Creating source and target table definitions using Informatica Designer. Source data was extracted from Flat files, SQLServer and DB2, Teradata Databases
• Analyzing the source data and deciding on appropriate extraction, transformation and loading strategy.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Created mappings to read from Flat files, DB2, Teradata and Oracle to load into RDBMS tables.
• Involved in writing BTEQ scripts for creating staging tables & inserting test data as per requirement in Teradata.
• Based on business Rules Debugged code, tested and validated data after processes are run in development.
• Used Autosys Job Scheduling software for batch Scheduling.
• Modified the existing mappings for the updated logic and better performance
• Developed Logical Data Flow Diagrams in Visio for every mapping that is developed.
• Assisted QA Team to fix and find solutions for the production issues.
• Used UNIX Shell scripts in coding ETL Tasks.
• Documented the workflow dependencies and ordering for Autosys job scheduling process.
• Used Autosys Job Scheduling software for batch Scheduling.

Environment: Informatica8.6, UNIX, Windows, Oracle 10g, PL/SQL, MSSQL 2008R2, SQL, Flat Files and CSV, Shell Scripting, Putty, PL/SQL Developer, Autosys.

Confidential

Informatica Developer

Responsibilities:

• Interacting with the end users to get the business requirements, reporting needs and created ETL Architecture diagrams.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL tool.
• Code reviews of Informatica Mapplets, Mappings, and Workflows Test with negative data, Unit testing
• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Created and Scheduled sessions & Worklets using workflow Manager to load the data into the Target Database
• Extract data from Flat files and Oracle Database using Informatica.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations to facilitate Daily, Monthly and yearly Loading of Data.
• Automated the jobs through Scheduling using built in Informatica Scheduler.
• Extensively used Source qualifier, Aggregator, Filter, Joiner, Expression, lookup, Router, Sequence Generator, Update Strategy, Union and SQL transformations to create mappings
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database.
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Extensively worked on tuning and improving the load time as well query processing time.
• Improved the Informatica Mappings and Session performance by eliminating extensive cache usage transformations, modifying session properties and partitioning the mapping.
• Used Error Handling Mapplet to capture error data into PMERR tables for handling nulls, analysis and error remediation Process.
• Documented the workflow dependencies and ordering for Autosys job scheduling process.
• Used Autosys Job Scheduling software for batch Scheduling.
• Interacted with the SME to implement requirements without affecting performance of the process.
• Coordinate the resolution of any issues with delivered customizations with other teams and onsite/offshore team.
• Reviews and ensures the work products are delivered within agreed schedule/quality
• Worked with the Testers in writing test cases and validated test Cases prepared by them.

Environment: Informatica Power Center 8.6, Windows 2003, SQL Server 2000, Mainframes, XML, Informatica Power Exchange 8.5.1, TOAD, SQL Developer, Flat Files, MS Visio,Unix,Autosys.

Confidential

ETL/ Database Developer

Responsibilities:

• Responsible for design and development of Sales Data Warehouse.
• Worked with Business Analyst and application users to finalize Data Model, functional and detailed technical requirements.
• Extracted data from heterogeneous sources like Oracle, SQL Server, SAP, Sales Force and Legacy systems.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Conducted a series of discussions with team members to convert Business rules into Informatica mappings.
• Used Transformations like Look up, Router, Filter, Joiner, Stored Procedure, Source Qualifier, Aggregator and Update Strategy extensively.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created Mapplets and used them in different Mappings.
• Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
• Monitoring the Data Quality, Generating weekly/monthly/yearly statistics reports on production processes - success / failure rates for causal analysis as maintenance part and Enhancing exiting production ETL scripts.
• Worked with SAP and Oracle sources to process the data.
• Worked on SAP for data migration Human Resources and Finance and converted various objects on Organizational Structure, Addresses, Time, Basic Pay, Bank Details, Recurring Payments, Tax assignment, Insurance Plans, Payroll etc, to generate report from SAP BI system.
• Worked with Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation of Informatica Power center.
• Created Unix Shell Scripts to automate sessions and cleansing the source data.
• Implemented pipeline partitioning concepts like Round-Robin, Key-Range and Pass Through techniques in mapping transformations.
• Involved in Debugging and Performance tuning of targets, sources, mappings and sessions.
• Worked on the data masking activities for cloning the GDW for several buyers.

Environment: Informatica Power Center 8.6, Oracle10g, SAP, SAP BI 7.0, SQL Server, Sun Solaris

Confidential

Jr. ETL Developer

Responsibilities:

• Reviewed the Business Requirement Documents and the Technical Specification.
• Developed ETL mappings, transformations using Informatica Power Center 8.6
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Worked on various transformations including Source qualifier, Expression, Filter, Aggregator, Router, Update strategy, Lookup, Normalizer, Rank and Sequence generator
• Developed reusable Mapplets and Transformations.
• Enhancements and support.
• Supported migration of ETL code from development to QA and QA to production environments.
• Worked with ETL tool Informatica to create mappings and workflows and Transformations.
• Configured Repository Manager, created folders and managed objects in repository Manager for Informatica.
• Used Filter, Router, Aggregator, Lookup, Expression and Update Strategy transformations whenever required in the mapping.
• Worked on Source Analyzer, Mapping Designer &Mapplets and Transformations.

Environment: Informatica Power Center 8.6, Oracle 9i/10g, Shell Scripting, TOAD for MySQL, TOAD, UNIX, Windows, SQL Navigator