Senior Informatica Developer Resume

SUMMARY:

Senior Database Developer with 12 years of diversified experience on stored procedures, functions, packages, and database triggers using SQL and PL/SQL programming.
Senior Informatica Developer with 5 years of experience utilizing Informatica PowerCenter 9.5.1, 9.6.1
Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center on Oracle and SQL Server Databases
Experience in converting legacy database systems into Oracle and create stored procedures to convert and transform data into Oracle standard data.
Have been involved in all roles of application development in multiple full life - cycle implementations.
Worked on several projects on SSIS and SSRS. Have more than 3 year experience in MSBI.
Extensively worked on Oracle 11i Applications - Design and Development of Interfaces for Oracle Order Management, Distributor Management and Financials modules.
Worked on Informatica Mappings and Development.
Expertise in design and development of application in relational database, client server environment and web-enabled environment using Oracle 8i/9i/10.
Worked on ASP .NET in several projects.
Experienced in usage of UNIX commands and writing shell scripts.

TECHNICAL SKILLS:

Languages: PL/SQL, T-SQL, UNIX Shell scripting, C, C++, ASP .NET

RDBMS: Oracle9i, Oracle8i, Oracle 10g, Oracle 11g, SQL Server

Database: Oracle 11i, Oracle Applications Release 11.5.10

ETL: Informatica, SSIS

Operating Systems: UNIX, Windows XP, 9x, 2000

Tools: MSBI, SSIS, SSRS, TOAD, SQL * Plus, Oracle Workflows Manager, Oracle Forms Builder, Oracle Reports Builder, MS Visio, MS Word, Excel, MS Power Point, ExStream Dialogue, Informatica PowerCenter

Testing Tools: Tortoise SVN, Visual Source Safe, PVCS, TOAD, RADAR, DART, Test Director, Support Magic, Unicenter Service Desk

PROFESSIONAL EXPERIENCE

Confidential

Senior Informatica Developer

Reponsibilities:

Analyzed Informatica workflows/mappings and documented logic transformations that occur
Developed Informatica sources, targets, mappings, maplets, and transformations in PowerCenter Designer
Developed Informatica workflows, worklets, sessions, and tasks utilizing PowerCenter Workflow Manager
Mentored junior developers and reviewed their code.
Based on the requirements provided by the Business Analysts, developed Informatica packages and SSRS Reports.
Designed, developed and tested Stored Procedures in SQL Server 2012
Designed and developed a Reporting Cache Database.
Along with the DBA team, I was involved in Performance tuning of the existing procedures and packages, by creating indexes or using other fine tuning methods.
Mentored junior developers and reviewed their code.
Participated in software development life cycle, by working along with the production support teams.
Adhered to coding standards and best practices and encouraged junior developers to do the same.
Maintained Task Status for each developer in the team. Based on the meetings held twice a week, I accessed each one's available bandwidth and assign tasks accordingly.
Estimated the LOE for any work that is initiated by the business analysts.
Provided the required trainings for SSRS and SSIS components to the new employees and contractors.
Attended the Agile Methodology training and implemented the same while leading the team.

Confidential

Freelance IT Architect

Responsibilities:

Develop a Database (SQL Server) for all the employees to login their personal information and daily transactions and work.
Integrate all the company's Accounts and Official Records in a single Database (SQL Server and SSIS)
Maintain the daily theatre box office records in the database.
Generate Reports every week-end (SSRS).

Confidential

Oracle/SQL Developer

Responsibitlies:

Written PL/SQL stored procedures, views and functions for Date migration between databases.
Prepared a few sets of SQL, PLSQL, Oracle questions for recruiters to interview freshers and experienced candidates for Oracle jobs.
Prepared Oracle and RDBMS study material and power point presentations for training freshers.
Worked on a few independent projects on SSIS and SSRS.

Confidential

Oracle Developer

Responsibility:

Involved in Study of Technical Design Document (TDD) and identifying gaps if any.
Involved in design and development of major/minor enhancements.
Involved in Tuning of PL/SQL procedures to enhance performance.
Writing Test plan and Test cases to verify the working and credibility of the application.
Documenting the test cases, test scripts, pre-test conditions, input data and the actual and expected results for System Integration testing
Setup Test Environment, prepare master test data and Unit Testing.

Environment: Oracle 10g

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship