We provide IT Staff Augmentation Services!

Sr. Oracle And Informatica Developer Resume

Boston, MA

SUMMARY

  • ConspectusOver 9 years of IT experience with more than 8 years of experience in Design, Development, Implementation and Support of applications and systems as Architect/Database/ETL Developer.
  • Engineering/Technology Leader with extensive experience defining, delivering and supporting complex engineering solutions.
  • Profound experience with various databases like Oracle, SQL server, Sybase, DB2, Data warehouse Appliance Netezza.
  • Over 5+ years using Dimensional Data Modeling, Star Join Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin.
  • Strong in Database Design, Creation, Migration, Upgrading, Performance Tuning, Logical and Physical Design,Database Tuning, Installation and Upgrade of Database, as well as managing the Object and System Privileges.
  • Experience working in different development methodologies including Agile, Test Driven and global delivery model.
  • Excellent communication, interpersonal skills and a team-worker with good customer interaction.

TECHNICAL SKILLS

Platforms: Windows 2003 Server, UNIX, Red Hat Enterprise Linux, Fedora, Sun Solaris 2.7/2.6,HP-UX 10.20/9.0, IBM AIX 4.3/4.2, MS-DOS 6.22, Novell Netware 4.11/3.61, Win 98/95/3.x, Win NT 4.0

ETL/ Reporting Tools: Informatica Power Center 9.5/ 9.1/8.1/7.1/6.2/5.1/4.7 , Power Mart 5.1/4.7, SQL*Plus, SQL* Loader, Business Objects XI/ 6.5.1/6.0/5.1

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema, Snow-Flake Schema, FACT and Dimension Tables, Physical and Logical Data Modeling, ERWIN 4.2/3.5.2/3. x, ER Studio Data Architect 9.1

Databases: Oracle 11g/10g/9i/8i/8.0/7.0, MS SQL Server 2008/2005/2000/7.0/6.5/8.0 , MS Access 2003/2000/97 , DB2 8.0/7.0, Netezza 3.03,, Sybase Power Designer 12.0

Languages: .Net (C#, Vb.Net and Asp.Net), C, C++, Visual Basic 6.0, PL/SQL, SQL, SQL*Plus, Transact SQL, HTML, DHTML, Unix Shell Scripting

Web Technologies: Java, JSP, ASP, XML, VBScript

Servers: IIS 6.0, Apache, TomcatOthers: Visio Data modeling, TOAD, SQL Navigator, PVCS/CVS, Autosys, Control-M, Visual Source Safe, ClearCase,ClearQuest,Embarcadero Rapid SQL, Maven, Junit, SVN

 

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr. Reports Developer

Responsibilities:

  • Analyzed Test Cases and Test Plans. Involved in Unit, System testing and User Acceptance testing.
  • Extensively involved with Production support team in various performances related issues.
  • Extensively involved in fixing production bugs.

Environment: Informatica Power Center 9.1/8.1, SVN, SQL Server 2008/2012, Windows 7, Oracle 10g,Business Objects XI,Unix (ksh) Shell, Control-M, .NET 4.5, BPM, MicroStrategy

Confidential, Billerica, MA 

Sr. Architect

Responsibilities:

  • Extensively involved in the Design and Development of projects.
  • Gathered the requirements from the Business and did analysis based on all the requirements.
  • Extensively worked in the performance tuning of ETL processes and SQL.
  • Developed mapping parameters and variables to support incremental loads on the target database.
  • Developed UNIX scripts for scheduling the jobs, cleanup of log files.
  • Modified existing BOXI universe and reports based on the business requirements for the end user.

Environment: Informatica Power Center 9.5/9.0.1,SVN, Windows XP, Oracle 11g,Business Objects XI,Unix (ksh) Shell, SAP Business Object Data Services 4.0, ER Studio Data Architect 9.1

Confidential, Boston, MA

Sr. Reports Developer

Responsibilities:

  • Involved in the Design and Development of the projects.
  • Gathered the requirements from the Business and did an Analysis based on all the requirements.
  • Analyzed Test Cases and Test Plans. Involved in Unit, System testing and User Acceptance testing.
  • Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
  • Created complex stored procedures and views to handle the business logic.
  • Created BOXI universe and reports based on the business requirements for the end user.

Environment: Informatica Power Center 9.1/8.1, Clearcase, Sybase, SQL Server 2008/2005, Windows XP, Findur 9.1/8.1 AVS Scripting, Oracle 10g,Business Objects XI,Unix (ksh) Shell, Control-M, Access 2003, .NET 4.5, BPM

Confidential  

Sr. DATABASE/INFORMATICA DEVELOPER

Responsibilities:

  • Collection of requirements from business users and analyzed based on the requirements.
  • Identify source systems, connectivity, tables, and fields ensure data suitability for mapping.
  • Developed and documented Data Mappings/Transformations and Informatica sessions as per the business requirement.
  • Extensively worked in the performance tuning of programs, ETL procedures and processes.
  • Error checking and testing of the ETL procedures and programs using Informatica session log.
  • Designed and developed Oracle PL/SQL Procedures.
  • Involved in fixing invalid Mappings, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.

Environment: Informatica Power Center 8.11, Oracle 9i, Flat files, PL/SQL, SQL, Toad 9.0, Windows 2000

Confidential, Boston, MA

Sr. ORACLE AND INFORMATICA DEVELOPER

Responsibilities:

  • Involved in the Design and Development of the projects.
  • Used advanced techniques of Informatica to load data from flat files into the target Oracle database.
  • Developed mapping parameters and variables to support connection for the target database as Oracle and source database as Oracle.
  • Created different Oracle packages and ran them using Unix korn shell scripting.
  • Optimized/Tuned all the oracle stored procedures for better performance and efficiency.
  • Scheduled all the process of running the aggregates using Control-M.

Environment: Informatica Power Center 7.1.2, Control-M, Oracle 9i, Flat files, PL/SQL, SQL, Toad 9.0, Windows 2000, HP-UX 11.x, Unix (ksh) Shell, Sybase Power Designer, Visual Source Safe

Confidential, Boston, MA           

Sr. INFORMATICA DEVELOPER       

Responsibilities:

  • Business Analysis and Requirements Gathering.
  • Did the installation of informatica 7.1.4 on windows client and migrated the repository from informatica 6.2.2 to informatica 7.1.4.
  • Used Informatica Power Connect for Netezza to pull data from Netezza data warehouse.
  • Migrated all the views in sql server to the Netezza warehouse. Tuned the views to get better performance.
  • Developed mapping parameters and variables to support connection for the target database as Netezza and source database as Oracle OLTP database.

Environment: Informatica Power Center 7.1.4/6.2.2 , Netezza, Oracle 8i/9i, MS SQL Server7/2000, Flat files, PL/SQL, SQL, Toad 7.0, Win-SQL, Windows 2000, HP-UX 11.x Unix (ksh) Shell.

Hire Now