SUMMARY

• Over 13 years of experience in Information Technology including Enterprise Data Warehousing and Business Intelligence environments.
• Lead and guide development of an Informatica, Streamsets and Data stage based ETL architecture.
• Develop solution in highly demanding environment and provide hands on guidance to other team members.
• Implement an Informatica based ETL solution fulfilling complex performance requirements.
• Collaborate with Business Users, Product development teams, DBA, QA Team and other senior designers to develop architectural requirements to ensure client satisfaction with product.
• Determine if requirements are actionable for ETL team.
• Conduct impact assessment and determine size of effort based on requirements.
• Develop full SDLC project plans to implement ETL solution and identify resource requirements.
• Perform as active, leading role in shaping and enhancing overall ETL Informatica architecture.
• Identify, recommend and implement ETL process and architecture improvements.
• Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM .
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules,
• Merge properties and Batch Group creation.
• Experience in creation and maintenance of entity objects, hierarchies, entity types, relationship objects
• Relationship types using Hierarchy tool to enable Hierarchy Manager (HM) in MDM HUB implementation.
• Hands on experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages.
• Designed, Installed, Configured core Informatica/Siperian MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, Data Modeling.
• Worked with Sif API to interact with real time applications.
• Good knowledge of OBIEE / Tableau / Cognos / Business Objects as a Business Intelligence tool and Data Extraction using Informatica/Data stage as ETL tool.
• Extensive working experience in ETL tools such as Informatica BDM 10.2/ Data stage 11.5 / Stream sets / Oracle Warehouse Builder.
• Experience in SQL, PL/SQL, Performance tuning, Database Administration on Database backup/recovery and optimization of Data loads.
• Experience in Relational Databases on ORACLE 11g /Exadata, MS SQL Server 2008 R2.
• Experience in working with very large databases (2-4 Terabytes) and very large data transactions.
• Extensive experience in UNIX Shell Scripting, XML and Perl Scripting.
• Experience in Data Modeling Schemas (RDBMS, Multi-Dimensional Modeling (Star Schema, Snowflake) using Erwin Data Modeler r7. x.
• Experience Analyzing/designing/operating the High-level design and Low-Level design.
• Functional experience includes HR, Financial, Insurance, Retail and pharmaceutical Product domain.
• Specialized in production support, which required strong troubleshooting, problem solving skills and extensive interaction with Business users.

TECHNICAL SKILLS

Database(s): ORACLE 11g/Exadata, Teradata 7.2, SQL Server 20008 R2.

ETL Tools: Informatica BDM 10.2, Stream Sets and Talend and Data stage 11.5

MDM Packages: Informatica MDM Multi Domain Edition 10.0Automation Tools: Autosys, Gentran SI, MQFTE, Control-M and other related tools.

Reporting Tools: Cognos 8.0, Tableau 10 and Business Objects 5.1.

Database Modeling Tool: Erwin Data Modeler r7

Language(s): C/C++, J2EE, PL/SQL, UNIX Shell/Perl Scripts.

Operating System: MS DOS, MS Windows, Windows NT, SUN and Red hat Enterprise Linux 3.0

Other Tools: PL/SQL Developer, Toad 9.0 and Express

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

• Requirements gathering, understanding business needs from high level requirements.
• Preparing and documenting of technical design specs based on the data model and business requirements.
• Developing complex inbound/outbound data pipelines and reject strategies based on the business rules to load the IDL (initial data loads) and incremental loads using Informatica BDM and Stream Sets.
• Designing and developing the mappings, re-usable components (Address Validation, Parsing, Standardization, etc.) based on the business requirements using Informatica BDM and Stream Sets.
• Working closely with IT and business team members in the design and implementation of the data migration.
• Working in loading MDM Databases from legacy systems using ETL process by applying business logics.
• Designing streaming ETL Data pipelines using Kafka as Staging area using Stream Sets.
• Developing data pipelines for loading data in to MongoDB, Elastic Search and Influx database through the change data capture using Stream Sets
• Preparing rejection strategies and creating error files for streaming ETL data pipelines.
• Designing streaming data pipelines for extracting change data capture data into Hadoop Data Lake using Kafka messaging system.

Environment: /Tools: Informatica BDM 10.2, MDM 10, PostgreSQL, SQL Server tables, DB2 databases.

Confidential

ETL Developer

Responsibilities:

• Responsible for reviewing all the deliverables to ensure the quality of the work.
• Extensively involved in redesigning the HR integration and creating system design for additional interfaces.
• Creating master run book for implementation and consolidating every component for HR integration changes.
• Creating required ITIL Change requests and working with release management and corresponding admin teams for migration activities.
• Worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Conducting requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way.
• Involved in implementing the Land Process of loading the customer Data Set into Informatica MDM from various source systems.
• Collaborated with the data modelers to perform mappings and organize the data using the Erwin tool for data modeling.
• Experienced in creating and maintaining the entity objects, hierarchies, entity types, relationship objects and relationship types using Hierarchy tool to enable Hierarchy Manager (HM) in MDM HUB implementation and Informatica Data Director (IDD).
• Participated in the development and implementation of the MDM decommissioning project using Informatica Power Center that reduced the cost and time of implementation and development.
• Worked on data cleansing using the cleanse functions in Informatica MDM.
• Used Informatica ETL Power Center 9.6 for migrating data from various OLTP databases to the data mart.
• Reviewing TDD, Mapping, BRD and other project related documentations.

Environment: Informatica MDM, IDD, IDQ 9.7, Informatica 9.7, 9.6.0 & 9.5.1, (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Flat files, SQL, UNIX Scripting, Putty, Visio, Tidal, Autosys.

Confidential, Thousand Oaks, California

ETL Developer

Responsibilities:

• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Successfully migrated database from SQL Server to Oracle by replacing with Informatica 9.5.3 mappings.
• Customized out of box ETL mappings and developed new mappings to load the data from non EBS source in to OBAW.
• Used Hints, Indexes and other tuning techniques to increase the performance of the slowly running reports.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query performance
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Scheduled Informatica Workflows by creating JIL commands using Autosys.
• Creating run book for implementation and consolidating every component for financial integration changes.
• Creating required Change requests and working with release management and corresponding admin teams for migration activities.
• Design and development of the Informatica ETL mappings, Gentran SI jobs and Autosys schedules.
• Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture.
• Able to plan and execute all phases of life cycle in Data warehousing, Data Integration and Data Migration.

Environment: Informatica Power Center 9.5.3, Cognos 8.0 Reports, Erwin Data Modeler r7, Oracle 10g, Windows NT and PL/SQL developer.

Confidential

ETL Developer

Responsibilities:

• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Successfully migrated database from various Heterogeneous systems to Oracle by replacing through with Informatica 9.5.3 mappings.
• Analyzed the requirements and business rules for development/enhancement.
• Analyzed the Database and Data modeling (Star Schema, Snowflake) as per requirements and business rules.
• Prepared the various documents for Job Scheduling Process Design, Job Procedures and End-to-End Process document for the mappings, Batch Job script and Production Deployment document.

Environment: Informatica Power Center 9.1, Cognos 8.0 Reports, Erwin Data Modeler r7, Oracle 10g, Windows NT, SUN and Red hat Enterprise Linux 3.0, TOAD SQL Tool.