SUMMARY:

• About 9+ years of programming experience as an Informatica and PL SQL Developer Involved in Requirement Analysis, Development, Maintenance, Production support, Functional Studies, Quality Reviews and Testing
• Developed Mappings, sessions, work ows based on business logic using informatica ETL tool
• Scheduling of work ow/jobs on Control - M, Autosys
• Experience in FTP to SFTP file system migration
• Experience in Informatica migration from 9.1 to 10.0
• Expertise in implementing ETL (extract, transform and load) by using) Informatica and Oracle Data Integrator.
• Experience in migration of source code using version control system - GIT, Stash, Source Tree.
• Experience in creating shell script, to data loads from flat files into the database.
• Extensive Data Modeling experience in Star, Snow ake schema’s, Fact, Dimensions tables, Physical, logical data modeling
• Worked on Variables, Parameters, Work ow Variables and Session Parameters in Informatica
• Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Hints, Sequences, Synonyms, Database Links, and User Defined Data Types.
• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting.
• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
• Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, PL/SQL table, Cursors, Nested tables, V arrays, Records, Types and Dynamic SQL for DML operations for better performance.
• Proficient in Oracle 12C/11g/10g/9i/8i/7.3, PL/SQL back end applications development Toad, SQL Plus, and PL/SQL Developer.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table Partitioning.
• Developed many front-end applications using APEX 4.2.2
• Assist in design and development of large-scale Perl applications and Created Perl scripts using DBI/DBD for data extraction
• Worked on Oracle Forms 12c/11g/10g/9i/6iReports 11g/10g/9i/6i.
• Well-versed with different stages of Software Development Life Cycle (SDLC).
• Extensively used PL/SQL to build Oracle Reports 12c/11g/10g and views for processing data, enforcing referential integrity and needed business rules.
• Experienced in Tuning Queries for better performance with large volume of data. Extensive experience in developing applications using XIDOCS Forms / Reports.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL, and SQL Loader.
• Reasonable understanding in CORIC reporting tool
• Created automated CI/CD deployment Pipe line by integrating Stash -Jenkin’s - uDeploy for deploying DB and ETL components as part of Dev-Ops.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Unix Shell Scripts, HTML, XML.

RDBMS Oracle: 12c/11g/10g/9i/8i, MS-SQL Server 2000/2005, Sybase, DB2, MS Access.

Oracle Utilities: SQL*Plus, SQL*Loader, SQL developer, TOAD, Rapid SQL

GUI Tools: APEX 4.2,3.2, Golden gate, Autosys, Control-M, JIRA and QC quality center.Informatica power center 9.1/10, AWS informatica cloud,Jenkins,Bitbucket Stash,UDeploy

PROFESSIONAL EXPERIENCE:

Confidential

Oracle PL/SQL and AWS Informatica

Responsibilities:

• Development, documentation, Design, Code reviews and unit testing of database
• Creating Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects
• Tables, Views, Materialized Views, Triggers, Sequences, Synonyms and User Defined Data Types, Dynamic SQL, Global Variables to call post and pre work flow
• Developing and monitoring AWS Informatica Work flows, Mapping and stage load
• Scheduling and supporting Control M and Autosys Scheduler jobs.
• Data Migration to the Public Cloud - AWS
• Maintenance/Support of the existing components including database and batch for all the Tracks.
• Data engineer Support, Maintenance and Development for downstream support systems. Used
• Explain Plan for performance tuning of the code.
• Continous Intergration and Continous deployment pipe line

Environment: Oracle 12C/10g/11g, SQL*Plus, SQL, PL/SQL, SQL Developer, EXPLAIN PLAN, AWS Informatica Cloud,Jenkins, Bitbucket Stash, uDeploy,Fitness,J Meter, ICEDQ Testing tool,Snow ake,Python Scripting, Shell,Groovy

Confidential, Durham, NC

Oracle PL/SQL and Informatica Developer

Responsibilities:

• Development, documentation, Design, Code reviews and unit testing of database
• Creating Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects
• Tables, Views, Materialized Views, Triggers, Sequences, Synonyms and User Defined Data Types, Dynamic SQL, Global Variables to call post and pre work flow
• Developing Informatica Work flows, Mapping and stage load
• Maintenance/Support of the existing components including database and batch for all the Tracks.
• Data engineer Support, Maintenance and Development for downstream support systems. Used
• Explain Plan for performance tuning of the code.
• Migrated the script changes from development to test and production environments.
• Involved in System Testing and UAT (User Acceptance Test) with multiple Business Scenarios.
• Co-wrote Test plan and Created Test Scenarios.
• Support that involves trouble-shooting, problem analysis and solving user problems.
• Part of all agile ceremonies including daily scrum, Release planning, Iteration planning etc.
• Created shell scripts for data loads.

Environment: Oracle 12C/10g/11g, SQL*Plus, SQL, PL/SQL, SQL Developer, EXPLAIN PLAN, Informatica

Confidential

Oracle PL/SQL and Informatica Developer

Responsibilities:

• Development, documentation, Design, Code reviews and unit testing of database
• Creating Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects
• Tables, Views, Materialized Views, Triggers, Sequences, Synonyms and User Defined Data Types, Dynamic SQL, Global Variables to call post and pre work flow
• Developing Informatica Work flows, Mapping and stage load
• Scheduling and supporting Control M and Autosys Scheduler jobs.
• Maintenance/Support of the existing components including database and batch for all the Tracks.
• Data engineer Support, Maintenance and Development for downstream support systems. Used
• Explain Plan for performance tuning of the code.
• Migrated the script changes from development to test and production environments.
• Involved in System Testing and UAT (User Acceptance Test) with multiple Business Scenarios.
• Co-wrote Test plan and Created Test Scenarios.
• Support that involves trouble-shooting, problem analysis and solving user problems.
• Part of all agile ceremonies including daily scrum, Release planning, Iteration planning etc.
• Created shell scripts for data loads.

Environment: Oracle 12C/10g/11g, SQL*Plus, SQL, PL/SQL, SQL Developer, EXPLAIN PLAN, Informatica, XDIOC and CORIC reporting tools.

Confidential

Role: Senior Data Engineer / Informatica Developer

Responsibilities:

• Development, documentation, Design, Code reviews and unit testing of database
• Creating Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects
• Tables, Views, Materialized Views, Triggers, Sequences, Synonyms and User Defined Data Types, Dynamic SQL
• Developing Informatica Work flows, Mapping and stage load
• Scheduling and supporting Control M and Autosys Scheduler jobs.
• Maintenance/Support of the existing components including database and batch for downstream consumers.
• Provided an automated script solution and developed to reduce manual intervention on data requests from source systems and downstream as well
• Data engineer Support, Maintenance and Development for downstream support systems.
• Part of all agile ceremonies including daily scrum, Release planning, Iteration planning etc.

Environment: Oracle 11g/12c, Oracle, Apex4.2.2, SQL Developer, HP QC, Informatica Power Center 10,Putty,GIT hub, ODI, SQL*Plus, SQL, PL/SQL, SQL Developer

Confidential

Data Engineer

Responsibilities:

• Developed, modified, and optimized complex queries for data retrieval and modification.
• Involved in designing and developing various interactive reports with column lters for managing Applications using Oracle Application Express.
• Involved in SSO Con guration set for UsersCreated a data design for dynamic report lay out driven from data base completely
• Developed and modified PL/SQL, procedures, functions, triggers, reports as per business requirements
• Created and configured session as well as used various partitioning techniques such as key-range, hash key and round robin partitioning to provide faster execution of ETL process
• Provided end user training and Production System Support.
• Used various transformations like Source qualifier, expression, joiner, router, and filter.
• Developed and supported four User Interface Tools from Scratch in Oracle Application Express.

Environment: Oracle, Apex4.2.2, SQL Developer, HP QC, Informatica Power Center 9.1, ODI HTML, Java Scripting, PL/SQL, Data Modeling, Autosys JIL Scripting

Confidential

Senior System Analyst/ Oracle PL/SQL Developer

Responsibilities:

• Responsible for creation of technical specifications document for various mappings. & End user training to the business users.
• Involved in the design, development and implementation of Customer Analytics Data mart.
• Used various transformations like Source qualifier, expression, joiner, router, and filter.
• Developed, modified, and optimized complex queries for data retrieval and modification.
• Developed and modified PL/SQL, procedures, functions, triggers, reports
• Provided end user training and Production System Support.

Environment: Putty, Rapid SQL, Toad, HP - Quality Center, Informatica Power Center 9.1