SUMMARY

• A senior PL/SQL, Datastage and Hadoop Developer with over 12 years of diverse experience in Database Design, Development, Administration, Enhancement and Implementation.
• Strong in Database Design (Logical and Physical data model) and Development of Relational / Multi - Dimensional Schemas for Data Warehouse databases.
• Expertise in Oracle 9i/10g databases, PL/SQL.
• Proficient working experience in SQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers, Indexes, SQL *Plus and TOAD.
• Extensive experience with Hadoop, Pig, Hive, Sqoop, Flume, spark, scala.
• Worked Extensively on Informatica ETL tool, in designing mapping, workflows.
• Experience in Performance Tuning and Explain plan, Tkprof, SQL*Loader, DBMS JOB, Utl File, Indexes, Import and Export utilities and Shell scripting for auto process.
• Experience with handling very large data files using Oracle export & import and SQL*Loader.
• Experience in Performance tuning by implementing different options in Oracle like Parallel Query, Partitioning, Oracle Parallel Queries, Materialized Views, Bulk Collects and Collections etc.
• Experience in Oracle 6i forms reporting, developing business reports through Oracle form builder.
• Experience in Worldwide Trade Compliance Processes and Customs Reporting/trade collaborator.
• Worked with and managed cross-functional and cross-IT teams (Oracle ERP, SAP ERP, TIBCO, EDI, GXS, etc.).
• Proficient in UNIX shell script and Object Oriented and Relational database Concepts.
• Good interpersonal and leadership skills, self motivated, an effective problem solver with the ability to work under pressure in fast paced, challenging environments
• Client Server experience includes backend development experience using Oracle, PL/SQL. Procedures, functions and triggers using PL/SQL.
• Providing daily, weekly and monthly status reports to managers

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.6.1/8.1 , Informatica Designer, Workflow Manager, Star Schema, Snowflake Schema, OLTP, OLAP, Data-stage 8.6/9.5

Web Technology: HTML

Languages: PL/SQL, SQL, UNIX Shell Scripting, Pig scripting

Database: Oracle 8i/9i/10g/11g

Operating Systems: Windows 7/98/XP/Vista, UNIX

Tools: PL/SQL Developer, TOAD, SQL Loader, SQL *PLUS, iSQL PLUS, MS Visual Studio, Informatica PowerCenter, Oracle Forms 11gPL/SQL Developer, MS Visio Studio, Report builder 6i, Form builder, Hadoop, Pig, Hive, Sqoop, Flume

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Developer

Responsibilities:

• Perform technical analysis of critical business areas within Bank such as Business Requirements, Production application issues, Feature driven development activities.
• Resolve, communicate and support technical issues, risks with software applications to Business and technology stakeholders of Project.
• Plan, Design, Develop and Manage technology using Oracle, UNIX, Windows, Datastage .
• Responsible for documentation and audit artifacts as per defined SDLC process.
• Review technical design, code, testing strategies and test cases as per Barclay’s process/ standard.
• Conduct design walk-through and communicate design rationale to Design Review Committee (Data Architects, DBAs and Business Analysts).
• Using WINcvs, SVN and Bit bucket for version control.
• Using SQOOP to import Oracle tables into Hadoop and export from Hadoop.
• Ingest text files to Hadoop.
• Working with AWS Cloud to install RDS and S3.
• Using Apache Solr to index files.
• Designed and Developed PL/SQL Procedures to support email alerts to customers who did not enrol to Barclay card website after signing to paperless to back to paper.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Creation of required indexes hints and partitions to improve the performance of complex queries.
• Created Unix Shell Scripts for automating the execution process. Datatype mismatch in replication frame work which is used to transfer data from Production to reporting database.
• Creation of database objects like tables, views, Materialized views, using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions on big sized database.
• Support IT/Business team for System Testing / User Acceptance Testing. Closure of defects and regression testing.
• Creating Production Turn Requests and help DBAs / Admin implementing code in production environment.
• Familiar with release management, Jenkin.

Environment: Oracle 10g/11g, UNIX, PL/SQL, UNIX, MS Project Plan, MS Visio, MS Virtual Source Safe, Subversion (Configuration Management).

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Analysis of business requirements of the project by studying the Business Requirement Specification document.
• Conduct design walkthroughs and communicate design rationale to people in other disciplines (project managers, developers, business analysts and customers).
• Working with various active transformations in Informatica PowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
• Database capacity planning (data storage) for projects and capacity planning for UNIX storage required.
• Conduct design walk-through and communicate design rationale to Design Review Committee (Data Architects, DBAs and Business Analysts).
• Creating Tables, Indexes, Views, Triggers.
• Using Tortoise SVN for version control.
• Designed and Developed data validation, load processes using PL/SQL scripts, Stored Procedures, Functions, and Triggers.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Creation of required indexes, hints and partitions to improve the performance of complex queries.
• Created Unix Shell Scripts for automating the execution process.
• Worked on UNIX scripts to transfer files using FTP to all the UNIX servers at one time.
• Creation of database objects like tables, views, Materialized views, using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions on 30 Terabytes sized database.
• Written SQL queries for data Validation
• Support IT/Business team for System Testing / User Acceptance Testing. Closure of defects and regression testing.
• Creating Production Turn Requests and help DBAs / Admin implementing code in production environment.

Environment: Oracle 10g/11g, UNIX, PL/SQL, UNIX, MS Project Plan, MS Visio, MS Virtual Source Safe, Subversion (Configuration Management).

Confidential

Technical Lead Oracle PL/SQL and Informatica Developer

Responsibilities:

• Analysis of business requirements of the project by studying the Business Requirement Specification document.
• Conduct design walkthroughs and communicate design rationale to people in other disciplines (project managers, developers, business analysts and customers).
• Create Design documents, data model (Facts / Dimensions), source to target ETL mappings and process flow diagrams.
• Communicate with different business units / business SMEs for requirements clarifications.
• Database capacity planning (data storage) for projects and capacity planning for UNIX storage required.
• Conduct design walk-through and communicate design rationale to Design Review Committee (Data Architects, DBAs and Business Analysts).
• Define logical modules and task assignment to team (onsite/offshore) and task monitoring . Preparing status reports (technical portions) with Project Manager for project stakeholders .
• Creating Tables, Indexes, Views, Triggers
• Designed and Developed data validation, load processes using PL/SQL scripts, Stored Procedures, Functions, and Triggers.
• Writing Shell scripts to call stored procedures and packages to load data files using external tables
• Code Review to ensure code is tuned and following corporate coding standards.
• Created data acquisitions strategies based on the defined Key Performance Indicators.
• Review if deliveries from onsite / offshore deliveries.
• Developed volume and capacity estimates and defined archival strategy.
• Development code on Informatica/ Oracle databases.
• Creation of coding standards - SQL / Informatica mappings/ maplets/ sessions/ workflows.
• Creation of required indexes, hints and partitions to improve the performance of complex queries.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Worked on UNIX scripts to transfer files using FTP to all the UNIX servers at one time.
• Creation of database objects like tables, views, Materialized views, using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions on Terabytes sized database.
• Designed the facts and dimensions tables and created the dimensional model for the custom database.
• Support IT/Business team for System Testing / User Acceptance Testing. Closure of defects and regression testing.

Environment: Informatica Power Centre 9.1(Informatica Designer, Repository Manager, Workflow manager, Workflow monitor), Oracle 10g/11g, UNIX, PL/SQL, UNIX, MS Project Plan, MS Visio, MS Virtual Source Safe, Subversion (Configuration Management).