6+ years of experience in analysis, design, development, administration and implementation of Client/Server and Data warehouse applications using Informatica, Oracle, DB2, MS SQL server on Windows, IBM AIX and Linux platforms.
Experience in the roles of ETL Designer/Developer and ETL Administration.
Expertise in building data integration applications – more... using Informatica integration with ERP systems like SAP ECC/CRM, SAP BW and BCI.
Expertise in design and development of Informatica integration with other middleware tools like MQ Queues, IBM Message Broker and Tibco.
Designed and developed the ETL workflows, worklets, various tasks and Mappings using Informatica tool to extract data from different source systems and load to different target systems.
Extensively used various ETL Transformations for developing Informatica mappings.
Good knowledge and experience in UNIX scripting, SQL and PL/SQL programming, DB performance tuning. Good knowledge in Data warehousing and slowly changing dimension implementation
Fair Knowledge in Data modeling tool Erwin and Reporting tool SAP BO, Cognos report studio.
Experience in administrating the Informatica services, installation and configuring the informatica s/w and environment, migrating the ETL applications to the new versions.
Upgrade the informatica applications to higher version with the code and maintaining the Admin console. Migrated ETL applications from Informatica-8.6.1 on Unix to Informatica-9.5.1 on Linux
Established, maintained and supported Informatica environment for Warner Bros client
Setting up of an Informatica Grid computing environment for Warner Bros with failover and load balancing capabilities
Involved in setting up of an Informatica Disaster Recovery (DR) environment.
Implemented the High Availability (HA) and Informatica grid.
Experienced in migrating Informatica code using deployment groups and troubleshooting the code migration issues.
Checking the mappings, sessions and workflows for validation and prepare the relese checklists
Established and performed industry standard Informatica maintenance activities to improve performance of ETL code and written the UNIX scripts to automate the maintenance activities.
Working with infrastructure teams to ensure an effective operating environment including throughput, repository sizing, capacity planning, monitoring and maintenance.
Creation and maintenance of technical documentation, deployment diagrams and check-lists.
Conducting research into Informatica related issues and working with developers and the vendor when necessary.
Checking Network utilization, server utilization and disk space problem
Setup Power Exchange for MQ Design, JMS/Web Services and SAP Plug-ins.
Good Knowledge in Apache Hadoop architecture, HDFS concepts and Databases like Hive and PIG.
Good Experience in BMC Remedy ITSM processes like Incident, Change, Problem and Release management Methodologies.
Expertise in preparing the Root Cause Analysis of severe business impact incidents and handling critical production outages.
Good experience in Continuous service improvement initiatives, Process automation activities. – less