SUMMARY

• 10+ Years of experience in Information Technology SDLC with a strong background in design, architecture and development of Data warehousing that includes experience in Data Integration, Data Migration and ETL process using Informatica Power Center 9.x/8.x/7.x/6.x
• Specialist skills in scoping Business Requirements, Architecture, Visualization, Project Management, Vendor Management, Problem Solving and Mentoring.
• 3+ Years of experience in Dimensional modelling, Data Profiling, Data Cleansing, and Data Auditing.
• Worked upon various production issues, data fixes, and root cause analysis. Provided 24/7 Production Support and Problem Solving Tickets.
• Hands on experience as an Informatica Administrator and production systems.
• Design/Architect experience in building integration of different systems, MDM (Master data management), ETM (Enterprise Territory Management), Enterprise Data Warehouse, salesforce, SAP, GreenPlum, EBS, ILOG/ODM, Web service calls, Fusion middle ware (FMW) OSB, IBM Mainframe COBOL.
• Worked on Healthcare, Marketing, e - commerce and Auto Insurance Projects
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions. Experience in debugging mappings, Identifying bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments.
• Worked on long running SQL queries from production environment to avoid data delays for the Production users. Worked with Stored Procedures, Triggers, Cursors, Indexes and Functions.
• Provided short term and long term fixes for various production support issues while meeting the production SLA.
• My current project tech stack is ERWIN, Informatica 9.x Power center, Informatica Cloud, Informatica Power Exchange, Teradata, Oracle OBIEE, OWB, Informatica IDQ, Informatica MDM, SAP, Oracle EBS, SSIS, SIEBEL, UCM, DNBIM, Trillium, Salesforce on Cloud, ILOG/ODM, Oracle, Green Plum, SQL, PL/SQL, MySQL,SQL Server, UNIX.
• Extensively worked and driven on Agile projects, and worked as a Scrum Master for agile projects
• Setting up and leading offshore captive units and fostering offshore teams.
• The open group architecture framework, TOGAF Enterprise Architect certified. Certified informatica developer.

PROFESSIONAL EXPERIENCE

Confidential, Palo Alto, CA

Informatica Lead

Responsibilities:

• Extensively involved in MDM system architecture and design on account hierarchy and product hierarchy while making them as company master and product master data as a single source of truth.
• Designed and developed Informatica code to extract, convert and load data to various down streams like Salesforce, DRM, EDW, EBS and portals.
• Involved in the full development lifecycle from Requirement gathering through Design, Build, QA, Deployment and Support using Informatica Power Center.
• Resolved Source system data issues by performing Data profiling and providing workaround techniques.
• Developed data quality jobs using Trillium data cleansing tool.
• Worked closely with business analysts to gather functional specifications and turn them into technical specifications.
• Worked upon various production issues, data fixes, and root cause analysis.
• Identified long running jobs and implemented various performance tuning techniques to mitigate the bottlenecks.
• Worked on long running SQL queries from production environment to avoid data delays for the production users.
• Provided short term and long term fixes for various production support issues while meeting the production SLA.
• Created UNIX shell scripts to process the portal uploaded files one by one by using batch engine scripts.
• Used UNIX commands in sessions to handle multiple target files into one, clean unused Target or error files, remove special characters from Flat files.
• Facilitated code reviews as a Lead developer, to ensure code quality.
• UsedVariablesand Parametersin Mappings, Workflows and Sessions.
• Created post-session and pre-session shell scripts and mail-notifications. Used various session tasks like Event wait, Timer, Decision and Control.
• Performed Admin tasks like recycling the services (Repository and Integration services), purging log files, creating users, groups, roles, folders and assigning privileges & permissions.
• Develop and maintain the best practices and guidelines throughout data Warehouse practice in the organization.
• Triaged issues worked on defects and implemented change requests as and when assigned.

Environment: ERWIN, Informatica 9.x Power center, Informatica Cloud, Power Exchange, Teradata, Oracle OBIEE, Oracle Warehouse Builder, Informatica IDQ, Informatica MDM, SAP, Oracle EBS, SSIS, SIEBEL, UCM, DNBIM, Trillium, Salesforce on Cloud, ILOG/ODM, Oracle, Green Plum, SQL, PL/SQL, UNIX, Control M, MySQL,SQL Server.

Confidential, Palo Alto, CA

Informatica & Production Support Lead

Responsibilities:

• Interacting with business users for requirement analysis and to define business and functional specifications.
• Documenting user requirements, translated requirements into system solutions and developed implementation plan and schedule.
• Preparing software requirement specifications, business rules interacting with business units and designed ETL process.
• Developed data quality jobs using Trillium data cleansing tool.
• Involved in performance tuning by re architecting the existing applications like ILOG/ODM, DRM.
• Developing Informatica ETL mappings using complex transformations, Mapplets to Extract, Transform and load data into Operational database from legacy mainframe systems.
• Extensively used transformations like router, aggregator, lookup, source qualifier, joiner, expression, aggregator, normalizer and sequence generator transformations in extracting data in compliance with the business logic developed.
• Extensively used all utilities in Informatica like Designer utilities (Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer and Mapping Designer), Workflow Manager Utilities (Task Developer, Worklet Designer and Workflow designer) and Workflow Manager.
• Involved in massive data cleansing prior to data staging.
• Involved in performance and tuning of the existing ETL mappings.
• Migration of mappings and sessions from development repository to production repository.
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.
• Creating new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environments of ODS and DWH.
• Used the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
• Using Repository Manager to maintain the metadata, Security, Reporting and tuning the Informatica Repository and Mappings for optimum performance.
• Creating sessions, sequential and concurrent batches for proper execution of mappings using repository manager.
• Generating various Error handling and failure recovery strategies.

Environment: ERWIN, Informatica 9.0, Informatica IDQ, Teradata, Salesforce on Cloud, ILOG/ODM, Oracle 11g/10g/9i, Green Plum, SQL, PL/SQL, UNIX, Shell Scripts, OBIEE, Oracle EBS, SSIS, Informatica MDM.

Confidential

Sr .Informatica Developer & Support Engineer

Responsibilities:

• Responsible for setting up jobs in EDW/DIH/ETL Integration environment complete on a daily basis.
• Responsible for communicating with customers about any delay that may occur in data processing.
• Responsible to address the SRs created by customers.
• Developed data Mappings, Transformations between source systems and warehouse.
• Performed slowly changing dimension (SCD) Type1, Type2 and Type3 mappings.
• Developing Complex transformations, Mapplets using Informatica to Extract, Transform and load data into Data marts, Enterprise Data warehouse (EDW) and Operational data store (ODS).
• Involved in Production Support and all phases of SDLC from requirement gathering, design, development, testing, Production and user training environments.
• Coordinating with Design and support team as well as communicating with customers on a case by case basis.
• Interacting with business representatives for requirement analysis and to define business and functional specifications.
• Preparing software requirement specifications, business rules interacting with business units and designed Star schema, logical and physical database design for Domains.
• Migration of mappings and sessions from development repository to production repository.
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.
• Using Repository Manager to maintain the metadata, Security, Reporting and tuning the Informatica Repository and Mappings for optimum performance.
• Creating sessions, sequential and concurrent batches for proper execution of mappings using Repository manager.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data).
• Generating various Error handling and failure recovery strategies.

Environment: Informatica 9, TERADATA, TABLEAU, SALESFORCE, Oracle 11g/10g/9i, SQL, Trillium, PL/SQL, UNIX, Shell Scripts.

Confidential

Source system Analyst/Project Lead

Responsibilities:

• Analyzed source system application data and architecture and data transactions.
• Interacted with business representatives for requirement analysis and to define business and functional specifications.
• Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
• Prepared software requirement specifications, business rules interacting with business units and designed out of box Star schema solution from IBM Rational insight relational model. Logical and physical database design for Domains.
• Developed Complex transformations, Mapplets using Informatica to Extract, Transform and load data into Datamarts, Enterprise Data warehouse (EDW) and Operational data store (ODS) using DATA Manager ETL Tool.
• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) as per business requirements.
• Transformed the data via standardization, cleaning, data repair, matching, and deduping.
• Removed duplicate rows from fact tables through the process of deduping.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views Development and Production environments of ODS and DWH.
• Developed data Mappings, Transformations between source systems and warehouse.
• Implemented mappings using Aggregate, Filter, Join, Expression, Lookup and Update Strategy transformations.
• Used debugger to test the mapping and fixed the bugs.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Generated various Error handling and failure recovery strategies.

Environment: ERWIN,MH Web,Teradata,Java Messaging System (JMS), IBM Rational Insight, Data Manager ETL, Cognos,Oracle.

Confidential

Sr. Informatica/DWH Developer

Responsibilities:

• Worked closely with the end users in writing the functional specifications based on the business needs.
• Developed standards and procedures for transformation of data as it moves from source systems to the data warehouse.
• Created Technical design specification documents based on the functional design documents and the physical data model.
• Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files
• Extract and Load data using different tools in Teradata like Multiload, FastExport, Fastload, OLE Load, BTEQ
• Extensively used transformations like router, aggregator, lookup, source qualifier, joiner, expression, aggregator and sequence generator transformations in extracting data in compliance with the business logic developed.
• Involved in massive data cleansing prior to data staging.
• Involved in performance and tuning the ETL processes.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views and Production environments of ODS and DWH.
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data.
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.

Environment: ERWIN, Informatica 8x, TERADATA, Oracle, Cognos, KINTANA, UNIX

Confidential

Sr. Informatica/DWH Developer

Responsibilities:

• Involved in full life cycle design and development of Data warehouse.
• Interacted with business analysts, data architects and application developer to develop a data model.
• Implemented Informatica 8 new SQL transformation for executing SQL statements.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document, and ETL specifications.
• Used Informatica Designer to create complex mappings, transformations, and source and target tables.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
• Used Exception handling logic in all mappings to handle the null values or rejected rows
• Query Optimization for improving the performance of the data warehouse.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Involved in performance tuning of the mappings, sessions and workflows.
• Used session parameters and parameter files to reuse sessions for different relational sources or targets.
• Maintain Development, Test and Production mapping migration Using Repository Manager.
• Developed shell scripts for Informatica pre-session, post session procedures
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.

Environment: Informatica 8.6, UNIX, DB2, Mainframes, SAS, JCL, COBOL

Confidential

Sr. Informatica/DWH Developer

Responsibilities:

• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
• Prepared the required application design documents based on functionality required
• Designed the ETL processes using Informatica to load data from COBOL Files to staging area DB2 data base.
• Created mappings using transformations like Normalizer, Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
• Designed and developed the logic for handling slowly changing dimension table loads by flagging the record using update strategy for populating the desired
• Developed shell scripts for validating source files and invoking informatica jobs in a sequence using pmcmd utilities.
• Modified Mainframe component JCLs for Initial load, FTP of the daily files and load / unload of the data to the DB2 tables
• Involved in cleansing and extraction of data and defined quality process for the warehouse.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Involved in migration of mappings and sessions from development repository to production repository
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.

Environment: Informatica 8.6, UNIX, DB2, Mainframes, SAS, JCL, COBOL

Confidential

ETL Developer & Production Support Engineer

Responsibilities:

• Monitoring Informatica Production Jobs, Responsible for Data discrepancy between the systems, root cause analysis and Data fixing.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
• Interacting with third party vendor support for the product issues and devdrops like Informatica corporation to install the devdrops/patches for product issues.
• Worked on new enhancements and development artifacts using Informatica Power Center 6.2 tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Dealt with Epiphany Error handling, Root cause analysis, Installed Devdrops & patches for the errors provided by third party vendors.
• Participated in installing the web sphere application server with upgrade version 5.1.1.14 in the application.
• Optimized Query Performance, Session Performance and Reliability.
• Used SQL tools like TOAD to run SQL queries and validate the data.
• Responsible for Interacting with client management on a weekly basis to discuss the issues/escalations.
• Participated in client Team weekly & Monthly presentations & Created daily reports MOM with SLA metrics.
• Involved in Informatica 6.2 to 8.6 upgrade

Environment: Informatica 6.2/8.6, Trillium Data Quality, Salesforce, Epiphany 6.5.4, Oracle 9i, Windows 2000, UNIX.