SUMMARY:

• About 10+ years of work experience in various phases of IT projects such as system analysis, design, coding, testing and migration..
• Excellent knowledge and hands on working experience with Power center Informatica tools and Architect.
• Expertise in building Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional Model (Kimball and Inmon), Star and Snowflake schema design. Analysis, design, development, and implementation of data warehouse, ETL processes.
• Excellent knowledge of operating systems Windows, UNIX, and databases including Oracle, Teradata and SQL Server.
• Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing.
• Involved myself in POC to implement Cloudera hadoop framework.
• Efficient in implementation of EDI system for X12 process.
• Worked extensively for batch EDI transactions such as 270/271, 276/277, 278, 834, 837 I/P/D, 835, 820.
• Experienced in legacy data profiling and data quality analysis using Informatica Data Quality (IDQ) 9.6.0 and production/converted data masking using Informatica Test Data Manager(TDM) 9.6.0
• Worked with unstructured and semi structured data sources, translated and processed such sources using Informatica B2B Data Transformation.
• Excellent working knowledge of Informatica admin activities.
• Excellent working knowledge of UNIX shell scripting, job scheduling on multiple platforms, experience with UNIX command line and LINUX.
• Worked as Agile Scrum call facilitator and track status and discussion using Version one.
• Extensive experience on effort estimation, distribution of work, track & update status report, team coordination and update client.
• Have experience with Business Analysis, requirement gathering, Business Process reengineering. Interfaced extensively with Management, Users and technical teams, liaison with other project teams and system owners to help define companywide reporting requirements.
• Knowledge of Data Modeling concepts, including Multi - Dimensional modeling.
• Proven track record in addressing Production Support, Resolution & Closure of Trouble issues tickets.
• Experience in gathering of end-user business requirements and responsible to provide specific direction, training and mentoring to customers.
• Self-motivated and possess excellent critical thinking ability, good interpersonal and communication skills.

TECHNICAL SKILLS:

ETL Technology: Informatica Power Center 9.6/9.1/8.x/7.1/6.1, Power Exchange 9.1/8.6/8.1 Informatica TDM, Informatica IDQ, Informatica B2B, Informatica Cloud

Data Modeling: Star Schema Modelling, Snow Flake Modelling, MS Visio, Erwin

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/2000, Teradata 14/13/12/V2R6, Sybase

Reporting Tools: Business Objects XIR2, OBIEE 11g/10g,Qlikview

Languages: SQL, PL/SQL, HTML, UNIX Scripting

Scheduling Tools: Autosys, TwsMaestro, Control M, Dacrep

Other Tools: Toad, HP, HP Quality Center, JIRA, Verson One, Clarify, Putty and Fair knowledge on Big Data, Talend, Hadoop

Operating Systems: LINUX, SUN Solaris, Windows7/XP/2000/98

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Team Lead

Responsibilities:

• Involved in all phases of Data Warehousing like Analysis, requirement gathering and Design and Development of code.
• Understanding the Legacy Source System.
• Involved in estimation and Sprint planning as per agile process.
• Track progress of stories, ensuring projects meets timelines and quality expectations.
• Convert data from Legacy Source System to HE.
• Designing end to end ETL solution to mask production converted data for application testing
• Design and developed the mappings, sessions and Workflows as per requirement of business to implement the logic.
• Design and developed the mapping to implement validation rules as per business rules.
• Used various transformations like Address validator, parser, joiner, filter, matching to develop the maps.
• Used IDQ to complete initial data profiling and removing duplicate data.
• Involved in migration of the maps from IDQ to Power centre.
• Involved in migration of the data maps from power exchange to Power centre.
• Developing Teradata Utility scripts like Fastload, Multiload to load data from various source systems to Teradata.
• Implemented the Error handling and Audit framework for designed module.
• Developed UNIX shell script for automation and enhancing/streamlining existing manual procedure used at client location.
• Involved in the development of Informatica mappings and preparation of design document (DD), technical design document (TDD) and unit acceptation testing (UAT) documents.
• Testing Business functionalities based on the Test scenarios.
• Responsible for solving the testing issues.
• Coordinating with Client on discussing profile reports and ensuring there are no gaps in the Business Rules.
• Take up complete ownership of the work assigned in terms of quality and timelines.
• Involved in CRM process.

Environment: ETL Informatica (9.1), Informatica TDM (9.6.0), Informatica Power Exchange, Oracle, Teradata, Unix, Informatica IDQ, Control M, Version one

Confidential

Sr. Informatica Developer/Team Lead

Responsibilities:

• Captured Business Process Flows and Reengineered Process to achieve maximum outputs.
• Provided support for Application and impact analysis for new changes.
• Used IDQ to complete initial data profiling and removing duplicate data.
• Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ in Informatica Data quality 9.1 environments.
• Maintain B2B Data Exchange in terms of Trading Partner creations, endpoints, profiles, etc. required during the various stages of testing and demos.
• Worked with unstructured and semi structured data sources, translated and processed such sources using Informatica B2B Data Transformation.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica power center 9.6.1.
• Understand the ETL specifications and build the ETL applications like Mappings on daily basis
• Need to fetch the daily data from various sources like relational and flat file sources.
• Create the mappings, sessions and Workflows as per requirement of business to implement the logic
• We need to participate in all phases of Data Warehousing like Analysis, requirement gathering and Design and Development of code
• Create a mapping document based on High level design document 
• Assist development team to maintain all data sources and data storage options
• Coordinate with development team to create all ETL processes
• Provide an efficient interface with brand for all processes across various platforms

Environment: ETL (Informatica (9.1), Informatica B2B Data transformation, Informatica IDQ, Oracle, Teradata, QlikView, Service Now.

Confidential

Sr. Informatica Developer

Responsibilities:

• Interact with client and team for requirement analysis and design.
• Performed business analysis, requirement gathering and designed functional and technical specifications.
• Identified subject-matter experts and drove the requirements gathering process through approval of the documents that convey their needs to management, developers, and quality assurance team.
• Developing ETL mapping and extracting all the source .csv file data to ODS tables.
• Developed a separate framework for extracting files from remote system to till ODS table load.
• Developing complex Informatica Mappings, Mapplets and reusable transformations.
• Fixing invalid Mappings, Unit testing and Integration Testing of Informatica Sessions, Batches and Target Data.
• Using most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator, Update Strategy, Expression and lookups while transforming the Sales Force Data according to the business logic.
• Worked with shell script for ftp file transfer from remote machine (Augeo source system) to local AHM directory.
• Created UNIX scripts for automate workflow triggers from one folder to another folder and also created archive and delete scripts.
• Creating Sessions, Worklets and Batches in Workflow Manager and Scheduled the batches and sessions at specified frequency.
• Worked with ETL deployment from development to production server.

Environment: ETL (Informatica (9.x/8.x/7.X)), Oracle, Teradata, SQL Developer, Unix, Jira

Confidential

Sr. Informatica Developer/Team Lead

Responsibilities:

• Interacting with client and onsite team for requirement analysis and design.
• Performed business analysis, requirement gathering and designed functional and technical specifications.
• Identified subject-matter experts and drove the requirements gathering process through approval of the documents that convey their needs to management, developers, and quality assurance team.
• Developing ODS mapping and extracting all the source xml file data to staging tables.
• Designing dimension and fact tables for EDW load.
• Developing the transformation logic, Identifying and tracking the slowly changing dimensions and determining the hierarchies in dimensions.
• Using Workflow Manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.
• Developing complex Informatica Mappings, Mapplets and reusable transformations.
• Fixing invalid Mappings, Unit testing and Integration Testing of Informatica Sessions, Batches and Target Data.
• Using most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator, Update Strategy, Rank, Expression and lookups while transforming the Data according to the business logic.
• Creating Sessions, Worklets and Batches in Workflow Manager and Scheduled the batches and sessions at specified frequency.
• Working with Offshore team and coordinating with developers to understand the captured requirements in order to complete the development activities successfully with in the specific timeframe.

Environment: ETL (Informatica (9.x/8.x/7.X)). Oracle, Toad, Jira, Autosy, Unix,

Confidential

Sr. Informatica Developer

Responsibilities:

• Understanding existing System and new requirements accordingly to design the technical documents.
• Preparing test cases for the changes that identified during impact analysis.
• Interacting with client and onsite team for requirement analysis and design.
• Creation of System Design document capturing the architecture and Design changes.
• Analysis of the impact of architecture and design on other sub-systems.
• Determining which reports are impacted and ensure regression testing continues on non-impacted reports.
• Analysis and determination of technological products to be used.
• Interacting with performance testing team for devising the performance
• Independently and as a member of a development group, performs system analysis, design, programming, testing, documentation, installation, user training and system maintenance and support.

Environment: ETL (Informatica (9.x/8.x/7.X))., Toad, DACREP, Siebel Analytics, putty, oracle, Unix

Confidential

Informatica Developer

Responsibilities:

• Interacting with client and team for requirement analysis and design.
• Analysis of the impact of architecture and design on other sub-systems.
• Performing code review and ensuring the coding standards.
• Interacting with performance testing team for devising the performance
• Independently and as a member of a development group, performs system analysis, design, programming, testing, documentation, installation, user training and system maintenance and support.
• Consults with user management and staff throughout all stages of the development cycle to ensure that systems achieve the user’s business objectives.
• Working with users and coordinating with application developers to understand and capture data/reporting requirements
• Performed technical project consultation, initiation, collection and documentation of client business and functional requirements, solution alternatives, functional design, testing and implementation support.
• Developing ODS mapping and extracting all the source system data to staging tables.
• Designing dimension and fact tables for sdwh load.
• Developing the transformation logic, Identifying and tracking the slowly changing dimensions, heterogeneous sources and determining the hierarchies in dimensions.
• Using Workflow Manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.
• Developing complex Informatica Mappings, Mapplets and reusable transformations.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Using most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator, Update Strategy, Rank, Expression and lookups while transforming the Data according to the business logic.
• Creating Sessions, Worklets and Batches in Workflow Manager and Scheduled the batches and sessions at specified frequency.
• Involving in performance tuning by removing bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.

Environment: ETL (Informatica (9.x/8.x/7.X)). Oracle, Toad, Dacrep, Siebel Analytics, putty, Unix

Confidential

Informatica Developer

Responsibilities:

• Independently and as a member of a development group, performs system analysis, design, programming, testing, documentation, installation, user training and system maintenance and support.
• Working with users and coordinating with application developers to understand and capture data/reporting requirements
• Identified subject-matter experts and drove the requirements gathering process through approval of the documents that convey their needs to management, developers, and quality assurance team.
• Performed technical project consultation, initiation, collection and documentation of client business and functional requirements, solution alternatives, functional design, testing and implementation support.
• Captured Business Process Flows and Reengineered Process to achieve maximum outputs.
• Developing ODS mapping and extracting all the source system data to staging tables.
• Designing dimension and fact tables for sdwh load.
• Developing the transformation logic, Identifying and tracking the slowly changing dimensions, heterogeneous sources and determining the hierarchies in dimensions.
• Using Workflow Manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.
• Developing complex Informatica Mappings, Mapplets and reusable transformations.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Using most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator, Update Strategy, Rank, Expression and lookups while transforming the Data according to the business logic.
• Creating Sessions, Worklets and Batches in Workflow Manager and Scheduled the batches and sessions at specified frequency.
• Involving in performance tuning by removing bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.

Environment: ETL (OWB. Informatica, Oracle, Toad, Control M, putty, Unix)