SUMMARY

• Having good experience in ETL Infrastructure support for Data Warehousing analysis, design, development, testing, application support and related Integration projects in the BI space.
• Having good development and support experience in Informatica 6.2/7.1.5/8.6.0/9.1/9.5.
• Extensive interaction with business users, IT Managers in analyzing business requirements and translating requirements into functional and technical specifications.
• 24x7 Production Support for business continuity.
• Having good experience with Informatica HA, GRID, and RealTime and supporting Informatica on Redhat Linux/AIX/Solaris
• Willingness to learn new concepts and ability to articulate alternative solutions.
• Design and build the DR (Disaster Recovery) Informatica Infrastructure setup.
• Informatica infrastructure Capacity planning and Charge back process.
• Proficiency with DW concepts and practice of relational and dimensional data modeling with extensive experience in development and support
• Leveraged ETL tools such as Informatica Power Center, Power Exchange and B2B Transformation, IDQ, RTM, MM, DVO testing and troubleshooting of Informatica programs.
• Comprehensively implemented all the Performance Tuning Methodologies involving Tuning Sources, Targets, Mappings, Sessions as per Informatica best practices
• Expertise in batch loads, error/rejected records processing, process dependencies and integration of various data sources like SalesForce.com, SAP, Mainframes, XML, sql server, Oracle, DB2 and Flat Files.
• Understanding in Unix Shell (Korn Shell, Bash Shell) scripting.
• Having good experience in Informatica Support/Administration Activities like installation and configuration of Informatica PWC/PWX Domain/nodes on UNIX, Linux and Windows Environment and Creation of Integration/repository services and Grid
• Having good experience with Salesforce adapter (an Informatica add - on)
• Manage day-to-day Infrastructure and Application support activities and ensure the health and maintenance of Informatica environments.
• Having good experience with Big Data (Hadoop)
• Expertise in writing SQL, PLSQL code and Unix Scripts and Excellent verbal and written communication skills
• Full lifecycle exposure to Data Warehouse projects and Data Marts with Star and Snowflake Schemas.
• Excellent exposure to Teradata and SQL query performance tuning techniques.
• Having experience in Teradata database & its tools Utilities like BTEQ Scripting Fast-Load, Multi-load and Fast-export.

TECHNICAL SKILLS

ETL Tools: Informatica 10.1, 9.5, 9.1 8.6 & Informatica Power Exchange & B2B MFT Console. Trained on Hadoop (HDFS & Map Reduce), PIG, HIVE (Hue), HBase, Sqoop, Impala, HiveQL

Reporting Tools: Micro Strategy

UNIX Systems: Linux, HP-Unix, Sun Solaris, AIX

Operating Systems: Windows 2000/NT, UNIX AIX & Linux & Solaris

Programming Languages: Java, Python, C++, UNIX

RDBMS: SqlServer, DB2, Oracle 9i-11g, Teradata V2R5, Netezza, MySql

Scripting Languages: UNIX Scripting

Networking Protocols: TCP/IP, HTTP, FTP, SFTP, Firewall

Methodologies: Star Schema, Snowflake Schema

Data Modeling Tools: Erwin, ER Modeling, Dimensional modeling

PROFESSIONAL EXPERIENCE

Confidential

Senior Informatica Consultant

Responsibilities:

• Worked on upgrade project analysis and requirement gathering for upgrade from 950 to 10.1
• Worked on Informatica 10.1 installation and configuration and domain restore.
• Configure the Informatica LDAP configuration from Native user ids
• Worked on Informatica B2B data Exchange MFT tool to exchange the files transfer from one vendor to other vendor with SSL authentication & PGP encryption & decryption process.
• Involved in designing of star schema based data model with dimensions and facts.
• Worked on Sales force plug in configuration with Informatica power center
• Worked SAP plug ins configuration and installing the SAP transports on SAP server end
• Worked on Web Service provider configuration with Informatica 10.1 setup along with Power Exchange setup.
• Worked with different Sources such as Oracle, SAP ABAP code generation, SQL Server and Flat files. Used Informatica to extract data into Data Warehouse built on Oracle.
• Identified and tracked the slowly changing dimension tables, heterogeneous Sources and determined the hierarchies in dimensions.
• Involved in designing test cases for unit and system testing.
• Modified Unix Shell Scripts for executing the Informatica workflows.
• Install and Configured the Salesforce plug ins
• Created parameters and variables for incremental data loading effectively using Informatica workflow manager.
• Efficiently interacted with UAT team and supported system testing and fixed bugs in mappings during QA phase.
• Worked on DVO & IDQ & ILM data management & Informatica Cloud administration
• Optimized or tuned mapping/ sessions during load testing in QA environment.

Confidential

Senior Informatica Consultant

Responsibilities:

• Worked closely with the business analyst and Data warehouse architect to understand the source data and need of the Warehouse.
• Worked on Informatica B2B data Exchange MFT tool to exchange the files transfer from one vendor to other vendor with SSL authentication & PGP encryption & decryption process.
• Worked on Netezza administration support activities giving access to users, group, database backups, restores upgrades and data migrations.
• Involved Upgrade & migration from Informatica Power Center from v9.5 to V9.6.1 HF2
• Involved in designing of star schema based data model with dimensions and facts.
• Have done POC on other Informatica Products like B2B Data Exchange, B2B Data Transformation
• Worked with different Sources such as Oracle, SQL Server and Flat files. Used Informatica to extract data into Data Warehouse built on Oracle.
• Worked on setting up Netezza - ODBC connectivity for applications utilizing Netezza as source and target database.
• Worked on multiple upgrades and migrations from INFA v9.1 to INFAv9.5/INFAv9.6
• Identified and tracked the slowly changing dimension tables, heterogeneous Sources and determined the hierarchies in dimensions.
• Creation of transformations and using Expression, lookup, update strategy & mappings and loading the warehouse extensively.
• Scheduled the workflows using scheduler using Email tasks and using multiple workless.
• Metadata Manager, Data Quality, Data Explorer, and Data Validation Option
• Involved in designing test cases for unit and system testing.
• Modified Unix Shell Scripts for executing the Informatica workflows.
• Created parameters and variables for incremental data loading effectively using Informatica workflow manager.
• Utilized of Informatica IDQ 8.6.1 to complete initial data profiling and matching/removing duplicate data.
• Efficiently interacted with UAT team and supported system testing and fixed bugs in mappings during QA phase.
• Optimized or tuned mapping/ sessions during load testing in QA environment.

Confidential

Senior Informatica Administrator

Responsibilities:

• As a Senior Informatica Administration/Application architect at onsite, I have involved in the Project Design Phase (PDP), analysis, design, build, testing and implementation phases of the project.
• Day to Day interactions with business users on design changes during various SDLC phases.
• Daily Interactions with End-to-End(E2E) team for defining the project requirements, based on understanding of the business needs and help them in analysis sessions
• Installation and configuration of Informatica Power Center Domains and nodes (Worker/Gateway), integration/Repository services and Grid.
• Designing the system and its architecture according to the project requirements.
• Co-ordination the tasks between offshore and onsite on daily basis during project life cycle.
• Reviewing the code developed by offshore and providing the inputs on fixes.
• Prepare the Design documents and provide the test data characteristics
• Playing a key role in resolving the ETL issues faced during System Integration Testing (SIT)
• Regular interactions via conference calls and meetings with business users to resolve the data quality issues concurred in the project.
• Configuration of LDAP server with Informatica Power Center domain
• Backup, restore and upgrade of domain and Repository services.
• User and Group management(Assign privileges and permissions to users/groups)
• Upgrade Informatica repositories from v7.1.5 to v8.6 and v8.6 to v9.1
• High availability recovery and set the sessions to recover automatically in case of any failure.
• Security management (accessibility, folder and group permissions)
• Server Administration (startup / shutdown, configuring the services) and system Maintenance (Log analysis, backups and archival)
• Infrastructure maintenance and support activities to ensure availability for Development, Test and Production environments across all systems in the bank.
• Performed Informatica Administrative tasks like creating folders, granting permissions, creating, backup and restore of repositories.
• Migration of Informatica components from development to QA and Production Environment.
• Worked with admin console of Informatica 8.6.1/9.1, creating users, roles, configuring services.
• Installed and configured PWX for VSAM, CDC and B2B Complex Data Exchange for unstructured B2B DT studio (data transformation).
• Worked on Oracle client, ODBC installations and db2 catalog entries on the UNIX machines.
• Developed Unix scripts for various admin activities like health check, analyze repos, backups, purging the metadata etc.
• Managed Change control implementation and coordinating daily, monthly releases and reruns.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.