We provide IT Staff Augmentation Services!

Sql Developer Resume

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.

Hire Now