SUMMARY:

• Around 10+ years of technically sophisticated & business savvy software professional with strong leadership qualifications and hands - on experience in Data warehouse and Business Intelligence.
• Expertise in Informatica including administration, designing, development, performance tuning and Production support as software development activities.
• Skilled in administration, developing, designing and implementing technology to support large user groups, supporting users.
• Experienced in Production Support and Informatica administrator and change management.
• Managed incident and change management activities.
• Experience in documenting High Level Design, Low level Design, STM's, Unit test plan, Unit test cases and Deployment documents.
• An effective communicator with exceptional analytical, technical and client relationship management skills with the ability to relate to people at any level of business and management.
• Experienced in creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
• Experienced in Installation, Configuration, and Administration of Informatica Power Center 9.x/8.x, MDM, IDQ and patch installation.
• Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Expertise in Dimensional Modelling using Star Schema/Snowflake Schema, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modelling using ERWIN.
• Basic knowledge in Big-data which includes Hadoop (Architecture, Hadoop distributed file system, Map-Reduce).
• ETL/Informatica Administration and Development: Experienced in Installation, Configuration, and Administration of Informatica Power Center 9.x,8.x. Experienced in using ETL tools like Informatica (Power Center) Designer, Repository Manager, Administration console and Workflow Manager. Proficient in creating design documents based on user requirement specifications and developing various transformation logics by utilizing Informatica transformations. Designing Informatica Mapping for different stages of ETL, debugging Informatica sessions by utilizing the logs of the sessions and tuning the mappings.
• Project Management: Managing resource allocations and setting up of communication channels between offshore and onsite. Conducting system analysis/process study for project scoping, estimation and tracking. Interacting with the client for system study, requirements gathering and analysis. Defining best practices for project support and documentation. Planning the work according to the objectives, Allocation of resources, Acquiring human and material resources, Assigning tasks, tracking and reporting progress, Testing applications and Defect prevention, communicating to senior management and clients.

TECHNICAL SKILLS:

• Unix
• Windows NT
• Windows 2000
• MS-DOS
• Z/OS
• INFORMATICA PowerCenter 9.6.1
• Data warehouse
• Oracle, Teradata
• TOAD
• SQL, PL/SQL
• Shell scripting
• HortonWorks Hadoop Ecosystem
• VSS
• Informatica
• Clear case
• Opsware
• Mainframes
• Pig & Hive
• Autosys
• Control-M

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL Consultant/ Informatica Administrator

Responsibilities:

• Participating in User meetings, gathering requirements, discussing the issues to be resolved, translating the user inputs into ETL technical design documents.Done Installation, Configuration, and Administration of Informatica.
• Setup and configure PowerCenter domain, grid and services. Maintaining the Grids and Nodes
• Done Repository Service Backup, Recovery and Migration of ETL objects between Dev, UAT and Prod environments.
• Using ETL tools like Informatica Designer, Repository Manager, Administration console and Workflow Manager.
• Experience in performance tuning of sources, transformations, targets, mappings, worklets, workflows, sessions and batches.
• Involved in Code review, Functional and Integration testing for all the mappings and workflows.
• Prepared L2 design documents, Technical Object documents, Business Scenario documents.
• Developed shell scripts to validate Headers and Footers of a file, automation of execution and sending the reports through mail to required persons. Worked on PRCD’s (Problem request change design).
• Done object deployment in QA and production environment
• Done batch job management.
• Developed standard and reusable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.

Confidential

Administrator/Sr. Developer

Responsibilities:

• Analysing the existing system and understanding the business specifications and preparation of Low level design as per the business specifications.Experienced on administration activities like user creation, folder creation, configuring DB connections etc.
• Experienced with Installation, Configuration, and Administration of Informatica and patch installation in Unix environment.
• Involved in Performance Tuning of sources, targets, mappings, transformations and sessions to optimize session performance.
• Analyzed the client requirements and create design document.
• Developed the mappings and workflows as per the Low level design documents.
• Performed objects deployment on versioned repositories from QA to Production.
• Preparation of understanding documents as per the business functionality.
• Debugging and rectification of test case statements.
• Experienced in Informatica administrator, change management and Production Support.

Confidential

Sr. Developer

Responsibilities:

• Understanding the business specifications and functional specification.Understanding the subject areas such as Accounts, Trades, Transactions, Clients, Security Master etc.
• Prepared the Technical design document which includes design, conceptual and logical architecture.
• Analyzing the tables by capturing the index, partition, category, DCLGEN, copybooks, load jobs, load files and backup files.
• Analyzing the Files by capturing the DCLGEN, copybooks, creator jobs, receiver jobs. Load jobs, load files and backup files using mainframe.
• Preparation of understanding documents as per the business functionality.
• To coordinate the smooth functioning of the module, status reporting, progress reports, resource allocation, planning, organizing project related s and holding team meetings.

Confidential

Informatica Developer

Responsibilities:

• Understanding the business, functional specification and preparation of Application design document.Participation in knowledge sharing sessions with the customer.
• Preparing/reviewing the component design documents
• Discussion with client about the derivations rule for each item and prepare the data.
• Developing/Reviewing the mappings and workflows as per the Component design documents.
• Perform the Unit testing and preparing/reviewing the test plan.
• Debugging and rectification of test case statements.
• Upgrade PowerCenter to version 8.6 from 8.5.
• To coordinate the smooth functioning of the module, status reporting, progress reports, resource allocation, planning, organizing project related s and holding team meetings.

Confidential

Developer

Responsibilities:

• Generate the Reports by running the jobs as per the COB each country.Changes the coding as per new geo code includes for new region retail stores.
• Monitored the autosys jobs.
• Wrote shell scripts to run the session
• Designing test cases and obtaining the test results.
• Involved in preparation and execution of unit test cases.
• Status report meetings with onsite/team members.
• Tracking the tasks and issues in the project.

Confidential

Developer

Responsibilities:

• Received Involved in the analysis, coding and implementation of Change Requests sent by SuperValuWorked on Type 2 Slowly Changing Dimension.
• Developed ETL mappings using Informatica Powercenter 8.6 to load data from flat files, Oracle to Staging Oracle and from Staging Oracle to Teradata.
• Created mappings using transformations like Source Qualifier, Normalizer, Expression, Filter, Router, Aggregator, Lookup, Update Strategy, Sequence generator, Rank and Joiner transformations.
• Created sessions from Workflow Manager for the mappings developed
• Wrote shell scripts to run the session
• Designing test cases and obtaining the test results.
• Involved in preparation and execution of unit test cases.