We provide IT Staff Augmentation Services!

Senior Plsql/informatica Developer Resume

SUMMARY

  • Over 13+ years of work experience as Oracle Lead/ Senior PLSQL/Informatica Developer in Design, Development and Maintenance of applications and Data ware housing project and Oracle Reports.
  • Extensively worked on data warehouses and data marts using Informatica Power center (Designer, Repository Manager, Workflow Manager, and Workflow Monitor). Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, and look up, Rank, Joiner, and Expression etc. for the business logic in the mappings.
  • Involved in Data migration from On Premises Database (Oracle and SQL Server) to Snowflake Data warehouse via Microsoft Azure Data Factory.
  • Extensively Worked in Oracle Migration project. Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
  • Worked in SQL performance tuning using Cost - Based Optimization (CBO), Explain Plan and HINTS and related features such as Query Optimizer, Execution Plans and Indexes.
  • Extensive experience in writing complex sub queries and complex database objects like Stored Procedures, Functions, Packages and Triggers and Inline Views.
  • Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables
  • Developed materialized views for data replication in distributed environments. Used advance concepts like Partitioning, Collections, Bulk Binds, External Tables and PRAGMA Compiler.
  • Solid understanding of inheriting PL/SQL object types, casting PL/SQL object types into Descendant types, converting PL/SQL object collections into a result set, bulk operations and pipelined functions.
  • Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
  • Imbibe advanced commands sed, awk, xargs, tar, mount and find in shell scripting.
  • Good knowledge in AML (Anti Money Laundering).
  • Strong experience in banking domain (Private Banking, Market Risk, Credit Risk and Operational Risk).
  • Extensive knowledge of creating Business Requirement and Technical Design Document
  • I nvolved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
  • Strong Experience in front-end and back-end development using Oracle Forms and Reports.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, UNIX Shell Scripting, SQLServer, DB2

RDBMS / Database: Oracle 12c, 11g, 10g, 9i, 8i (SQL & PL/SQL), SQL Server 2005

Cloud: Microsoft Azure, Snowflake

Data Design Tools: TOAD, PLSQL Developer, SQL Developer, Informatica Power Center, SQL Server Management Studio

Configuration Tools: Eclipse, Autosys, Quartz (Python), Putty, SSH Tectia

Testing Tools: SQL Developer

Operating System: Windows and UNIX

Third Party Tools: Clear Case, GIT, Bit bucket, Ctrl + M, ITRS

PROFESSIONAL EXPERIENCE

Confidential

Senior PLSQL/Informatica Developer

Responsibilities:

  • Involved in table design across all the factories in Oracle 12C.
  • Extensively used Oracle 12c features like XMLAGG, Automatic List Partitioning etc. for complex queries and performance tuning.
  • Worked on PLSQL packages with the use of Collections to handle huge volume data to capture metrics
  • Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager
  • Worked on Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Stored Procedure, Sequence Generator, Filter, Sorter, and Source Qualifier.

Environment: Oracle 12c (SQL, PLSQL), SQL Developer, Informatica.

Confidential

Senior PLSQL Developer/ Oracle Lead

Responsibilities:

  • Proposed architectural strategies/solutions to best meet business needs.
  • Involved in resolving all database performance issues, performance enhancements, and tuning strategies.
  • Used PL/SQL and SQL*Loader to create migration packages for flat file loading and error during migration.
  • Partitioned the fact tables, materialized views to enhance the performance.
  • Extensively used for all and bulk collect to fetch large volumes of data from the table
  • Own the creation high level technical designs, transition those designs to team, review low level designs created by team and provide continuous ongoing oversight and code review in relation to those designs.
  • Extensively used Oracle 11g, 12c features like Top N Queries (Ops Reports), Invisible column for performance in UAT phases, DDL Logging .
  • Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager
  • Worked on Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Stored Procedure, Sequence Generator, Filter, Sorter, and Source Qualifier.
  • Responsible for reviewing/approving all SQL code before deployment to Production

Environment: Oracle 12c (SQL, PLSQL), SQL Developer, SQL Loader,, Informatica and Java.

Confidential

Senior PLSQL Developer/Senior Systems Analyst

Responsibilities:

  • Automated tools designed in Oracle to reduce daily BAU tasks.
  • Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQLNavigator. Generated server side PL/SQLscripts for data manipulation and validation and materialized views for remote instances.
  • Involved in creating UNIX Shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
  • Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams.
  • Build several Unix Shell wrappers for Pro*C programs to schedule them on Crontab.
  • Created High Level Architecture and design.
  • Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Partitioned tables by determining the suitable methodology to improve performance and manageability.
  • Involved in incident fix, change and problem Management.
  • Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
  • Extracted data from SQL Server system to Staging Area and loaded the data to the target database by ETL process using Informatica Power Center.

Environment: Oracle 11g, 12c (SQL, PLSQL), TOAD, SQL Loader, Informatica and Unix Shell Scripting

Confidential

Technical Lead/Assistant Consultant

Responsibilities:

  • Developed tools in VBScript and Oracle to automate the reports which Operations can use directly.
  • Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures
  • Worked as a Technical Lead with a team of 7 members.
  • Worked on preparing Technical Design Document.
  • Created many database structures like tables, sequences and procedures as per the requirement for solving the issues and also for new enhancements.
  • Responsible for using dynamic SQL in PL/SQL which is an advanced programming technique that makes the applications more flexible and versatile

Environment: Oracle 11g (SQL, PLSQL), TOAD Developer, SQL Loader and Unix Shell Scripting

Hire Now