Oracle Training near me in Begur Road, Bangalore

I am Oracle Certified Professional

Around 9 years of IT experience with extensive involvement in the development of Data Warehousing solutions using Informatica and Oracle. Hands-on Experience in Informatica PowerCenter, Informatica Cloud(IICS), Unix, SQL, PL/SQL, SSIS, SAP HANA, Tivoli Workload Scheduler(TWS), Business Objects(BO), SqlServer, Basics of PowerBI, Basics of SPSS Modeler, Visual basic, Macros, AWS and Big data

I am Having 9+ years of IT experience in Data Integration, Data warehousing as an ETL developer such as Extraction, Cleaning, Transformation and Loading using Informatica Powercenter and Informatica cloud data integration in Finance, Retail & Healthcare Domain. Had experience in data modeling like Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling. Basic knowledge on High Level Design and Data Modelling concepts. Good experience on Implementation and supporting the enhanced Business Information. Involved in building a small Independent DataMart and developed Logical and Physical Data Model. Worked with different data sources, non-relational Databases such as Flat files, and other relational sources such as Oracle, SQL Server. Hands on experience in Oracle 11g and Informatica. Hands on experience in writing and executing SQL queries. Experience in database programming in PL/SQL (Stored Procedures, Triggers and Packages). Strong Exposure in Data Warehouse concepts like star schema &Snow-flake schema. Strong exposure in ETL process and Data warehouse lifecycle. Experience in Performance Tuning and Debugging of mappings and sessions. Involved in designed the mapping with multiple files loading using file repository. Extensive experience in Extraction, Transformation and Loading of data using Informatica from heterogeneous sources. Designed various Mappings for extracting data from various sources involving relational tables and flat files. Ability to work as a part of a team or individually & ability to pick up new skills quickly. Extensively worked with informatica cloud (IICS) and informatica PowerCenter. Worked on Data synchronization task, Data Replication, mapping, Mapping configuration tasks in data integration. Experience in the full-cycle software development including requirements gathering, prototyping, and proof of concept, design, documentation, implementation, testing, and maintenance. Good Understanding of Dimensional Modelling, Star and Snowflake Schemas. Created Informatica mappings to load data using transformations like source qualifier, sorter, aggregator, expression, joiner, connected and unconnected lookup, filters, sequence generator, router and Update strategy. Experienced in doing the process of extraction, transformation and loading data from multiple sources like flat files and OLTP systems into data marts using Informatica Power Centre. Basic Hands-on Experience in Informatica BDM & Hadoop. Good knowledge of Redshift and Hive. Professional Skills: Languages: Teradata SQL, Unix (Shell Script). Tools: Teradata SQL Assistant, BTEQ, Fast Load, Multiload, Putty, PL/SQL developer. ETL: Informatica PowerCenter V10.4, Informatica BDM. Database: HIVE, Oracle 11g/12c, Redshift.

I'm an Oracle PLSQL developer with an 8+ years of extensive development and administration experience. I have an hands-on experience in latest Oracle versions such as 12c , 19c which have multitenant architecture. Also, have knowledge on Oracle Cloud infrastructure.

Trainer Exp: 16 yrs Qualification: B.E

â?¢Worked as Software Engineer in ACCENTURE from Jan 2014 to Mar 2017. â?¢Working as Technology Analyst in INFOSYS from April 2017 to till date. â?¢A logical, analytical thinker with exceptional database skills possesses rich experience of 4.8 years as Oracle PL/SQL developer. â?¢Experience in SQL, PL/SQL, ETL Scripting, Query Optimization â?¢Experience in UNIX Shell Scripting, Control M, Cron jobs to automate process. â?¢Experience in Actimize (AIS Modeler and Designer). â?¢Expertise in Database designing and creation. â?¢Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines. â?¢Collected User Requirements by participating in meetings and studying existing System. Involved in Requirement gathering, analysis, design, build, testing, defect resolution, deployment, documentation and maintenance. â?¢Increased the overall efficiency of the project by creating robust code, reusable components and scripts to reduce overhead in future deployments of the models. â?¢My role was to analyze & create database objects like Stored Procedures, Functions, Packages and Triggers. â?¢Involved in creation of Tables, Views, Synonyms, Sequences and constraint. â?¢Experience in advanced PL/SQL concepts like Cursors, Global temporary tables, Bulk collect, Dynamic SQL. â?¢Wrote complex queries using joins, sub queries and correlated sub queries to retrieve data from the database. â?¢Experience in ETL (Extract, Transform and Load) â?? Moving data from OLTP to DMART. â?¢Used SQL*Loader to load data from a flat file into the database. Used UTL_File packages to write data to files. â?¢Tuning of the SQL query which takes long time to process the request using Explain Plan, Hint to reduce the response time. â?¢Extensive use of Unix shell scripts, Cron Jobs to automate process. â?¢Automated the monitoring activity which was performed by the team. â?¢Worked on number of enhancements with timely delivery against aggressive deadlines.

* Skilled and certified IT Engineering leader. * PMP and CSM certified project leader * Mobile, telecom and embedded systems expert * Interested in pursuing career in IT project management, Agile Scrum training and consulting projects and career coaching buddy IT leaders

-Oracle 11i, R12i, Linux, Solaris, Oracle 9i, 10g/11g/12c etc Weblogic 11g -Single/Multi Node installation, OTM build, Vendavo Upgrade, R12i upgrade

4 years of experience in teaching