We provide IT Staff Augmentation Services!

Sr. Etl Developer Resume

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).

Hire Now