SUMMARY

Title: Informatica Developer and Tester
Primary Skills: Informatica, ETL, Data warehousing, Oracle, Shell Scripting

• Around 5 years of experience in analysis, design, development, testing and implementation involving Informatica and various other Data Warehousing software Applications
• Worked extensively in Informatica Power Center Repository Manager, Designer, Workflow Manager and Workflow Monitor
• Extensive experience in integrating disparate data sources (flat files, XML, CSV) with multiple relational databases
• Implemented complex business rules in Informatica by creating re-usable transformations, robust mappings/mapplets, utilizingvaried transformation logic like lookups, router, filter, expression, aggregator, joiner, update strategy, normalizer and more
• Exposure to Data modeling techniques like star and snowflake schemas using Erwin
• Expertise in designing and implementing SCD - slowly changing dimensions types (1, 2 and 3) and CDC - change data capture
• Expertise in performance tuning of the mappings, ETL Environments, procedures, queries and processes
• Expertise in handling and loading high volumes of data into data warehouse in a given load window
• Extensive experience with Shell and Perl Scripting in the UNIX and Linux environments
• Knowledge in design and development of BI reports using Microstrategy
• Proficient in implementing ETL QA procedures and Exposure to all stages of Software Development Life Cycle
• Expertise in preparing test strategy, test plan, test summary reports, test cases and test scripts for automated and manual testing based on user requirement documents and system requirement documents.
• Experience in performing Functionality testing, System Integration Testing (SIT), Graphical User Interface (GUI) Testing, Integration, Negative testing, User Acceptance (UAT), Stress Testing and Regression testing on several applications as needed to minimize defects
• Significant exposure to scheduling tools like Appworx and Autosys
• Worked under extremely tight deadlines
• Experienced with coordinating cross-functional teams, project management and presenting technical ideas to diverse groups
• Good at various open sourcetechnologies like Perl, PHP, LAMP, Jscript, MySQL
• Great team player with excellent communication skills
• Functional knowledge of media & wireless industries and e-commerce

DW & BI: Informatica 8.6/7.1, Microstrategy 8i
Databases: Oracle 10g, MySQL, MS Access
Environment: Windows NT/2003/XP/Vista/7, Linux, Mac
Programming: SQL, PL/SQL, shell & batch scripting, Perl, PHP, Java, Asterisk, HTML, XML, AJAX, CSS
Servers: Apache, Microsoft IIS
Tools: Appworx, Autosys, Erwin, MS Visio, SQL Plus, Toad, Flash, Joomla, Subversion

CTS Consulting, NC, USA Apr 2010 - Feb 2011
CTS consulting provides a range of IT services to various US based clients. The project aimed at creating a solution framework for data sharing between interfaces in a near real time scenario. It also aimed to leverage robust messaging and data integration mechanisms for sharing data between inbound / outbound applications and Oracle Applications

Roles & Responsibilities (Senior Informatica Consultant)

• Extensively involved in requirements gathering, writing ETL Specs and preparing design documents
• Designed and developed Informatica mappings for data sharing between interfaces utilizing SCD type 2 and CDC methodologies
• Fixed various performance bottle-necks involving huge data sets by utilizing Informatica's partitioning, pushdown optimizations and SQL overrides
• Worked on parameters, variables, procedures, scheduling and pre/post session shell scripts
• Built sample Microstrategy reports to validate BI requirements and loaded data
• Designed migration plan and cutover documents; created and monitored Informatica batches
• Worked on requirement traceability matrix, provided support for integration and user acceptance testing

Confidential, NC, USA Mar 2010 - Apr 2010
Confidential, is a leader in voice and text based advertising and content services that offer a basket of SMS, audio and mobile web enabled services

Roles & Responsibilities (Consultant)

• Tuned existing Perl codes, developed MySQL procedures and presented data in Excel reports
• Developed asterisk apps for IVR, live music, sports, news, entertainment, 1-800-WEATHER & more
• Shell scripting and server side programming
• Worked extensively in manually testing SQL scripts, matching the output with complex requirements

Confidential, Bangalore, India Oct 2008 - Dec 2009
An organization with innovative concept of producing unique, proprietary, dynamic content and services for a huge clientele ranging from the media industry to IT sector. It is fundamentally an idea think tank comprising of a small team of designers, writers and technologists who work together to produce 'creative products' across a range of mediums.

Roles & Responsibilities (Senior Programmer Analyst)

• Developed ETL Informatica workflows to handle weblogs and in-house database loads
• Developed code to extract, transform, and load (ETL) data from inbound flat files and various databases into outbound flat files and XML files using complex business logic
• Implemented Informatica error handling, dynamic parameter file generations and coding best practices
• Created automated shell scripts to transfer files among servers using FTP, SFTP protocols and download files from web servers and hosted files
• Reviewed data models using Erwin tool to find out data model dependencies
• Worked extensively in Perl, shell scripting and click stream analysis
• Performed end-to-end testing for business case scenarios covering all the subject areas

Confidential, Noida, India Jul 2006 - Sep 2008
A private venture involved in the field of marketing and media in the form of \'afaqs!' a media & marketing portal and \'The Brand Reporter\', a fortnightly magazine. afaqs.com is India's largest portal in the advertising, media and marketing space.

Roles & Responsibilities (Senior Software Developer)

• Developed mappings and workflows in Informatica to extract data files in disparate file formats (XML, csv, fixed width, delimited, etc.) for automated feeds to third party vendors
• Developed a JAVA-based multi-thread program that downloads and processes data files which are then picked up by Informatica for loading into Oracle9i databases
• Responsible for analyzing, designing and coding of the applications primarily in Perl, Java and Apache
• Was part of the team that developed aFaqs e-commerce high traffic portal with features like product listings, shopping cart and news feeds
• Involved in LAMP based website and portal enhancements and maintenance

• Bachelors in Electronics Engineering with First Class
• A valid US EAD (Employment Authorization Document)

References available on request