SUMMARY

• Having 10 years of experience in Business Application Software Development Life Cycle (SDLC).
• Experience in providing information management consulting services on Master Data Management, Data Integration and Business Intelligence Applications.
• Over 2 years of Experience working in Informatica/Talend Master Data Management (MDM) Developer
• Highly Skilled in MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica/Business Data Director.
• Creating Landing, Staging and Base Tables and defining Foreign Key relationships, Lookups in the Hub.
• Developing the Mappings to load the Data from Landing to Staging by using various cleanse functions.
• Working with Hierarchy Manager to develop to Hierarchies as per the business needs.
• Creating IDD application as per the business needs by creating the subject area and subject area groups.
• Developing Put and Display packages for both Hierarchy Manager and IDD Application.
• Defining the Match and Merge Rules in the MDM Hub by creating Path components, Columns and rules.
• Involved in analysis, design, development, testing and maintenance.
• Experience in Data warehousing projects for analysis, data conversion/transform in Data warehouse/Data mart design development.
• Good knowledge on Banking and Retail domains.
• Extensively worked on Talend MDM, Informatica Designer, Workflow Manager, Monitor and Repository Manager.
• Worked in Reporting tools like Cognos, Business Objects.
• Good knowledge on Oracle 10g, PL/SQL, SQL Server and Teradata databases. Good Knowledge on UNIX.
• Good Experience in using SVN and CVS version controlling tools.

TECHNICAL SKILLS

ETL Tools: Informatica MDM 9.x, Talend DI/MDM 4.x, 5.x, Informatica 7.x/8.x/9.x, SSIS, DTS, DataStage

Reporting Tools: Cognos 8, Business Objects

Databases: Oracle 9i, 10g, PL/SQL, Teradata VR2, SQL Server 2007

Platform: Windows, UNIX.

Programming Languages: C, C++, Visual Basic.

Modeling tools: ERWIN

Scheduling tools: AutoSys, Control-M

PROFESSIONAL EXPERIENCE

Confidential, Weston MA

Senior ETL/MDM Developer

Responsibilities:

• Created ETL mappings as per business requirements and code changes.
• End to end testing the code in QA environment.
• Designed and developed a new ETL process to extract and load Vendors from Legacy System to MDM by using the Talend Jobs.
• Designed and developed the Business Rules and workflow system.
• Developed Talend ETL jobs to push the data into Informatica MDM and develop the jobs to extract the data from MDM.
• Interacted with theBusiness Users & Enterprise Data Architects in the analysis & design of Conceptual and logical datamodel that isrequired for solid MDM implementation & ensuringthat it meets the business requirements and also supports the products capabilities
• Analyzed the source system for integrity issues to the data resided in various source systems
• PerformedData profilingof reference data for large data setsusing Informatica Data Analyst tool.
• Defined the HUB Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• PerformedETL mappings & ran sessions and workflowsto execute the Land Process of loading the customer/product Data Set into Informatica MDM Hub using ETL tool that was coming from various source systems.
• Create MDM mappings using best practices to capture the errors and have a clean load.
• Worked on data cleansing and standardization using cleanse functions, cleanse lists and creating custom cleansefunctions(Attribute functions and Object functions) in Informatica MDM
• Created Match rule sets in for the base objects by defining the Match Path components, Match columns and rules.
• Configured match rules and rule sets property by enabling search by rules in MDM according to Business Rules
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production.
• Involved with ETL team in getting the data loaded into the landing tables.
• As a senior MDM developer, I have mentored junior developers to understand the requirements, technical documents and further on testing.
• Defined the HUB Base objects, Staging tables, foreign key relationships, static lookups, and dynamic lookups, queries, packages and query groups.
• Developed data matching/linking rules to standarize the record in Informatica MDM.
• Interacting with business users to understand and accomplish their business requirements.
• Confidential - ordinate with offshore team and guide them to understand the business requirements.
• Maintained availability of Dev, Test and Production database which helped the reporting team and business analysts to access database.
• Performance tuning of the Informatica mappings and database objects.
• Created Unix scripts and Stored procedures wherever required for the business deliverables.
• Developed Talend ETL jobs to push the data into Stage, DataMart and Datawarehosue.
• Worked on Informatica 8.6.1 repository database upgradation from Oracle 10g to Oracle 11g.

Environment: Talend BigData 5.1, Oracle 10g, Informatica 9.6, Informatica MDM, UNIX, Business Objects, Seibel CRM, Jira, Share point.

Confidential, New Jersey

ETL/MDM Developer

Responsibilities:

• Worked with business users to get the requirement and to involve in complete SDLC life cycle of CEFS.
• Analyzed source data and gathered business requirements from the business users.
• Developed Talend ETL jobs to push the data into Talend MDM and develop the jobs to extract the data from MDM.
• Involved in Designing ETL Specification.
• Developing the ETL mappings for XML, .csv, .txt sources and also loading the data from these sources into relational tables with Talend ETL
• ETL design and development, Creation of the Talend & Informatica mappings, sessions and workflows to implement the Business Logic.
• Implementing Data Integration process with Talend Integration Suite 3.2/4.2./5.1.2/5.2.2
• Designing, developing and deploying end-to-end Data Integration solution.
• Developed Talend ETL jobs to push the data into Talend MDM and develop the jobs to extract the data from MDM.
• Used different components in talend like tmap, tmssqlinput, tmssqloutput, tfiledelimitede, tfileoutputdelimited, tmssqloutputbulkexec, tunique, tFlowToIterate, tintervalmatch, tlogcatcher, tflowmetercatcher, tfilelist, taggregate, tsort, tMDMInput, tMDMOutput, tFilterRow.
• Designed and developed Informatica Mappings, and Sessions for data loads and data cleansing.
• Developed complex mappings and SCD type-I, Type-II mappings in Informatica to load the data from sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank, Router and XML transformations.
• Used Workflow Manager to create session task and other tasks.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.

Environment: Talend 5.0, Talend DQ, Talend MDM, Informatica Power Center 9.5.1, Oracle 10g, BO XI 3.1, Toad, UNIX, Mainframe, PowerCenter Mapping Architect for Visio (MAV)

Confidential

L3 Database Support

Responsibilities:

• Developed Talend ETL jobs to push the data into Informatica MDM and develop the jobs to extract the data from MDM.
• Interacted with theBusiness Users & Enterprise Data Architects in the analysis & design of Conceptual and logical datamodel that isrequired for solid MDM implementation & ensuringthat it meets the business requirements and also supports the products capabilities
• Analyzed the source system for integrity issues to the data resided in various source systems
• PerformedData profilingof reference data for large data setsusing Informatica Data Analyst tool.
• Defined the HUB Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• PerformedETL mappings & ran sessions and workflowsto execute the Land Process of loading the customer/product Data Set into Informatica MDM Hub using ETL tool that was coming from various source systems.
• Create MDM mappings using best practices to capture the errors and have a clean load.
• Worked on data cleansing and standardization using cleanse functions, cleanse lists and creating custom cleansefunctions(Attribute functions and Object functions) in Informatica MDM
• Created Match rule sets in for the base objects by defining the Match Path components, Match columns and rules.
• Configured match rules and rule sets property by enabling search by rules in MDM according to Business Rules
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production.
• Involved with ETL team in getting the data loaded into the landing tables.
• As a senior MDM developer, I have mentored junior developers to understand the requirements, technical documents and further on testing.
• Defined the HUB Base objects, Staging tables, foreign key relationships, static lookups, and dynamic lookups, queries, packages and query groups.
• Developed data matching/linking rules to standarize the record in Informatica MDM.
• Interacting with business users to understand and accomplish their business requirements.
• Enhancements and Change requests related design and coding.
• Involved in interaction with client to perform requirement analysis and prepare the design of new requirements.
• ETL design and development, Creation of the Talend & Informatica mappings, sessions and workflows to implement the Business Logic.
• Developing the ETL mappings for XML, .csv, .txt sources and also loading the data from these sources into relational tables with Talend ETL
• Involved in datamasking project and developed Informatica mappings to mask production data using datamasking transformation and other transformations.
• Automated the process writing unix shell scripts to minimize manual activities.
• Developed the batch scripts, required to validate the data from files load to tables using dtsx packages for audit compliance.
• Involved in performance tuning of Informatica sessions.
• Release and Deployment of Changed code
• End-to-end testing activities include: analysis of specifications, reviewing documentation, internal / client liaison, regression testing, UAT and maintaining error logs.
• Creating KeDB documents to improve the support activities.
• Supported the PCS Sungard Surveillance, PB MIS, PBDW, PCS MIS applications.
• Mentoring L2 Production support team during outages and helping to resolve the issues meeting SLA’s.
• Involved in Informatica migraton to Talend project.

Environment: WINDOWS 2003, UNIX, Informatica MDM, Informatica 8.6, Talend Integration Suite 4.0, Hyperion, Sql Server 2007, Sybase, AutoSys, Control-M, SVN.

Confidential, Cincinnati

Team Leader

Responsibilities:

• Leading the team of size 6 from offshore for all the GAMS BI applications maintenance and support.
• Resolving mission critical application issues and coordinating offshore team to resolve production support issues like aborts, user query resolution and Infrastructure upgrade.
• Maintained wing-to-wing performance above 90% and SLA performance above 95% in production support activities throughout the year.
• Giving suggestion to Development team for complete automation of Loads and reducing the maintenance activity like manual load monitoring and reducing manual work involved in each application.
• Implemented Incremental refresh for OFA during Month end close to reduce the closing time that reduced the GL finance Closing time from 7 days to 3 days.
• Maintained offshore 80% of the work to meet the client requirement.
• Refreshing the Dev/QA Data Warehouse environment from Production for Development Team.
• Resolving issues using email and Phone that requires Oracle Technical Support teams, Congnos support team, Unix Admin team and Functional Finance team.

Environment: Informatica 8.1, Oracle 10g, Cognos, Unix, Appworx Schedulder, CVS.

Confidential, Cincinnati

Team Leader

Responsibilities:

• Requirements and Analysis: Understanding the requirements of the Legacy system and ERP system and act as an Informatica Designer.
• Interacting with the client through our Onsite Confidential -ordinators on various telecons to discuss the status of the project, clarify any queries regarding the functionality etc.
• Developed data Mappings between source systems and warehouse components.
• Understanding the business logic which sent by the Legacy system and ERP system onsite Confidential -ordinators.
• Coordinating the Informatica team and Created Unix shell script for SFTP process.
• Creating design (MD 200) documents and reviewing the UTC’s Coding
• Testing & debugging the code.

Environment: Informatica 8.1, Oracle 10g, Unix, Appworx Schedulder