Informatica Developer

INFORMATICA DEVELOPER/APPLICATION DEVELOPER/ORACLE DEVELOPER

OBJECTIVE: Over 5+ Years of experience in Data Warehousing which includes data analysis, data manipulation, programming, testing, implementation and report generation with concentration in Informatica tools. I desire to gain quality experience that will allow me to take full advantage of my degree in Computer Application. In addition, I am eager to contribute my creativity and hard work towards achieving the company’s strategic goals.

FORMAL EDUCATION

Tilak Maharashtra University (Pune, India)

Bachelor in Computer Application (2008)

Mumbai University (India)

Diploma in Chemical Engineering (2002)

Outstanding Fellow Award (Computer Science Department @ Tilak Maharashtra University (2008))

SKILLS / TECHNICAL EXPERTISE

Over 5 years of solid experience in Data Warehousing and clear understanding of Business Intelligence concepts with emphasis on ETL and Life Cycle Development.

Extensive knowledge in using various Informatica Designer Tools such as Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer for implementation of ETL methodology in Data Extraction, Transformation and Loading.

Excellent knowledge of Data Marts, Star and Snow Flake Schema Modeling, Kimball Methodology for Relational and Dimensional modeling, Entity-Relationship Modeling, OLTP and OLAP concepts.

In-depth knowledge of the Object Oriented Programming including but not limited to C, C++, JAVA and Visual Basic.

Thorough knowledge of Web languages such as HTML, VBScript, JavaScript, XML.

Exceptional knowledge of various OS (Windows 2000/XP/Vista, Windows 2003 server, UNIX, Linux).

Basic understanding of LAN/WAN and TCP/IP.

PROFESSIONAL EXPERIENCE

RHT InfoWay, Inc.

Edison, NJ

Oct ’09 – Present

Informatica Developer Intern

• Work with senior team members to gather customer requirements for various data warehousing projects.

• Design and develop ETL environments for Data Warehouses with effective use of active & passive transformations as per user requirements.

• Develop PL/SQL codes such as Stored Procedures, functions, triggers, cursors, packages, indexes, views, tables etc.

• Install and upgrade various OS to support large customer databases.

• Work with the Business Intelligence tools such as Business Objects and Crystal Reports as well as with DBA in installing and configuring Oracle 10g.

• Perform a variety of complex programming tasks such as designing, documenting and coding program logic.

• Implement various new components such as increasing the DTM Buffer Size, Database estimation, Incremental loading, Incremental aggregation and load efficiency.

• Resolve production issues using Session Logs and Workflow Logs.

• Determine and fix bottlenecks with performance tuning.

Ceat Ltd.(RPG Group)

Mumbai,INDIA

Jul ’07 – Jul ’09

Informatica Developer

• Used the capabilities of Power Center namely PMCMD, PMREP, Target Override, Connected and Unconnected Lookups, Persistence Lookups, Dynamic & Static Lookups.

• Fine tuned performance of Informatica sessions by implementing database partitioning and increasing block size, data cache size, sequence buffer length and target based commit interval and SQL overrides.

• Used Informatica Repository Manager to maintain the Metadata to create Local and Global Repositories, Users, Folders, User Groups, Permissions/Security.

• Implemented complex business rules in Informatica by creating re-usable transformations and robust mappings/mapplets.

• Developed Hierarchies to provide the Drill-down and Slice & Dice Functionality.

• Utilized Unconnected Lookup to update Slowly Changing Dimensions.

• Created FTP connections, Database connections for the sources and targets.

• Recommended, introduced and integrated new and emerging technologies to enhance users experience and reduce operating expense.

Century Textiles & Industries Ltd. (B.K. Birla Group)

MUMBAI,INDIA

Aug ’02 - Jul ’07

Junior Software Developer

• Installed, configured and maintained various OS including Windows, UNIX, and Linux.

• Installed and maintained high-valued applications such as Informatica Power Center, Oracle and SQL.

• Developed and maintained SQL codes for company’s core application using the Triggers, Functions, Packages, Views, Cursors, Synonyms, Sequences and Stored Procedures for the database management.

• Under supervision tuned SQL queries using table indexing and table partitioning and correct database fragmentation.

• Designed & built the frames & Applets based on JAVA.

• Worked with many different Operational Data Sources such as Oracle, DB2, SQL Server, and XML, Excel, Flat Files.

• Designed and developed various mappings from varied transformation logic including but not limited to Unconnected and Connected Lookups, Router, Filter, Expression, Aggregator, Joiner Update Strategy.

• Devised various techniques to monitor Informatica sessions to minimize user/network impact. Debugged mappings for failed sessions using Workflow Monitor and Session Log.

• Created Oracle Forms for User interface and for Drill-down reports.

REFERENCES

Paresh Patel 917-***-****

Gurudas Patil 732-***-****

Contact this candidate