PROFESSIONAL SUMMARY:

• Experienced professional with 12 years of expertise in analyzing the requirements, Development, Testing, Production support and a comprehensive background in Data bases and Data warehousing Technologies.
• Hands - on experience in Installation, upgrading, Bug fixing, migrating repositories on Enterprise Data Warehouse environments and hot fixes, configuration
• Hands of experience in configuring the Informatica Power Center with Code pages and Data Movement in single and multi bytes like ASCII and Unicode
• Good Understanding of Master Data Management, Data Governance, Identity Analysis, Data Analysis, Metadata Management and defining Data Quality rules according to Business rules of enterprise-wide
• Proficient in UNIX Administration Skills, Setup, upgrade and configure Informatica connectivity to various platforms, especially SAP, SQL Server, Teradata, Oracle
• Configured the connections to extract and load data from Metadata systems, and setup encryption and compression values to encrypt and compress data during the Power Center session.
• Worked on taking backup of repository and restore in different location by synchronizing the properties of that environment.
• Worked on Version Control Labels in Migration of Informatica workflows, Security issues and managing the repository with user connection and user locks happens on workflows and sessions.
• Hands of experience in scheduling workflows, Sessions and generating metadata reports on load time and system performance.
• Hands of experience in configuring and managing the Informatica Integration services to run on a Grid and assigning a single node to different sets of nodes .
• Good Knowledge in configuring the Informatica workflows to process massively with Parallel Processing methods for different Informatica Domain Repository services .
• Good Techniques of Installation, Upgrading, Configuring and Registering Informatica Repository Server and Informatica Server on UNIX and Windows Servers.
• Hands of experience in moving the Logical data models to physical metadata models and in implementations of Data warehouse and Data marts.
• Experience in Erwin Database programming for Data Warehouses (Schemas), proficient in dimensional modeling, Star Schema, Snowflake and Hierarchy modeling .
• Good Idea in Configuring Informatica Power Exchange and Power Center Integration services to extract and load Relational, Non-Relational, and Changed Data during Batch, Change and Real- Time basis.
• Hands of experience with Informatica Cloud based data movements by using Data services.
• Extensive database experience using Oracle, Teradata, DB2, MS SQL Server, MS Access, MS Excel, Flat Files and XML
• Hands on experience on different Databases load utilities and Hadoop HDFS file processing
• Exclusively worked on Siebel Admin tool in creating Informatica Repository (.rep), Analytics Repository (.rpd), Web catalog.
• Hands on Experience in performing Administrative tasks on huge databases and migrating repositories of OBIEE, Informatica and DAC between environments like DEV, SIT, UAT and PROD.
• Experience in performance tuning the bottlenecks of source DB, mappings, target DB and Informatica Workflows and sessions.
• Effectively interacted with other members of the Business Engineering, Quality Assurance, Users and other teams involved with the System Development Life cycle.
• Strong technical exposure with good degree of competence in business systems like Finance, Healthcare, Insurance, Telecom, Truecomp Callidus, Sales force, Manufacturing, Energy Solutions, Pharmaceutical, Food & Beverages and e-commerce Retail.
• Worked on Shift Basis and 24/7 rotation basis for support and trouble shoot the Issues and tickets.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Developer

Responsibilities:

• Experience in Erwin Database programming for Data Warehouses (Schemas), proficient in dimensional modeling, Star Schema, Snowflake and Hierarchy modeling .
• Good Idea in Configuring Informatica Power Exchange and Power Center Integration services to extract and load Relational, Non-Relational, and Changed Data during Batch, Change and Real- Time basis.
• Hands of experience with Informatica Cloud based data movements by using Data services.
• Extensive database experience using Oracle, Teradata, DB2, MS SQL Server, MS Access, MS Excel, Flat Files and XML
• Hands on experience on different Databases load utilities and Hadoop HDFS file processing
• Exclusively worked on Siebel Admin tool in creating Informatica Repository (.rep), Analytics Repository (.rpd), Web catalog.
• Hands on Experience in performing Administrative tasks on huge databases and migrating repositories of OBIEE, Informatica and DAC between environments like DEV, SIT, UAT and PROD.
• Experience in performance tuning the bottlenecks of source DB, mappings, target DB and Informatica Workflows and sessions.
• Effectively interacted with other members of the Business Engineering, Quality Assurance, Users and other teams involved with the System Development Life cycle.
• Strong technical exposure with good degree of competence in business systems like Finance, Healthcare, Insurance, Telecom, Truecomp Callidus, Sales force, Manufacturing, Energy Solutions, Pharmaceutical, Food & Beverages and e-commerce Retail.
• Worked on Shift Basis and 24/7 rotation basis for support and trouble shoot the Issues and tickets.