SUMMARY:

• Over 16+ years of IT experience in design, development, testing, implementation, enhancements and support of business applications, which includes 9 years of experience in Data Warehousing
• Worked as Sr. Data warehouse and ETL Informatica Developer
• Informatica Certified Developer
• Experience in the concept of building Fact tables, Dimensional tables and handling slowly changing dimensions
• Worked on ETL methodology for supporting Data Extraction, Transformation and Loading processing using Informatica and BO reporting.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet & Mapping designer
• Experience in Migrating Informatica objects to different environment
• Exposure to Informatica Administration
• Experience in Informatica tool set: Informatica B2B DT, IDQ
• Experience in creating SSIS packages and DTS packages
• Experience in creating SSRS reports
• Having good experience in PL/SQL programming- Database Triggers, Packages, Stored Procedures and Functions
• Involved in Business Analyst testing
• Strong experience in developing TEST plans in Mercury QC
• Experience in creating and configuring Tidal Jobs
• Highly motivated, energetic individual and a team player with good communication and interpersonal skills.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Windows XP/NT,UNIX,LINUX

DATAWARE HOUSING TOOLS: Informatica 9.5.1/ 8.x/7.x/6.x5.x, Informatica B2B

Data Transformations, Data Exchange,: Informatica Data Quality(IDQ), Power Exchange

(CDC), SSIS,DTS: DATA MODELLING TOOLS

Erwin 5.0: REPORTING TOOLS

Business Objects XI R2, SSRS, Viador: DATABASES

Oracle 8i/9i/10g/11g,: SQL server 2000/20, DB2

Teradata 13.1: DATABASE UTILITIES

TOAD, PL SQL developer, Management Studio,: Benthic

SCHEDULING TOOLS: TIDAL, Control-M, Cron tab, Informatica Scheduler

VERSION CONTROL TOOLS: PVCS, Synergy,SVN

LANGUAGES: C,C++,JAVA,COBOL

SCRIPTING LANGUAGES: UNIX, VB, PERL

PROFESSIONAL EXPERIENCE:

Confidential, Virginia Beach, VA

Sr. ETL Developer

Responsibilities:

• Working as a Lead Informatica Developer
• Involved in FICO project
• Supported FICO Project
• Worked with Business Analyst in gathering requirements and prepared technical BRD
• Develop Informatica maps to extract data from different source systems into Teradata targets and flat files
• Experience in loading unstructured data using Informatica B2B Data Transformation.
• Created Informatica Custom and Automatic profiles using IDQ to profile source data
• Created Informatica Change Data Capture maps
• Experience in utilizing Teradata load utilities(Fast Load, Mload)
• Experience in writing BTEQ scripts
• Worked with DBAs in Informatica deployment
• Involved in query performance tuning and Informatica performance tuning
• Created Teradata PL SQL procedures
• Experience in creating SSIS packages and SSRS reports
• Created Business Requirement Documents and ETL mapping documents
• Mentoring Junior developers and provide status reports to Management
• Created Test plans in Mercury QC
• Involved in Staging and Integration QA testing as part of Business Analyst Testing
• Experience in mentoring Jr. Developers

Environment: Informatica 9.5.1/8.6.1 , IDQ, PowerExchange, Oracle 10G, Teradata,SQL Server 2008,, SSIS,SSRS, Mercury QC,Subversion, Tidal

Confidential, Richmond, VA

Sr. ETL Developer

Responsibilities:

• Involved in Data archival project
• Developed mappings to archive data
• Providing results to Query Requests
• Application Enhancement
• Developing test plans in Mercury Quality Center
• Involved in data migration project and developed Informatica maps
• Developed DTS and SSIS packages
• Involved in Data validation project
• Involved in SQL Server 2008 Upgrade
• Supporting the NCDW application
• Scheduled workflows in Informatica Scheduler

Environment: Informatica 8.6.1, Oracle 10G, SQL Server 2000/2005/2008 , DTS,SSIS,Viador Reporting, Mercury QC,Synergy

Confidential, Boston, MA

Sr. ETL Developer

Responsibilities:

• Involved in getting the requirements
• Prepared Business Requirement Documents
• Designed and developed the Informatica mappings based on the requirements
• Worked with sources like XML, flat files and relational
• Extensively used Joiner, Lookup, Aggregator, Update Strategy Transformations
• Created Reusable Transformations and mapplets and used them in mappings
• Created UNIX Scripts to automate the Workflows
• Involved in the code migration process
• Designed Test Plans to test Informatica mappings

Environment: Informatica 8.1.1, Oracle 9i, SQL Server 2005 SQL/PLSQL UNIX, TOAD, PVCS

Confidential, Boston, MA

Sr. ETL Developer

Responsibilities:

• Understand the existing systems.
• Creating Dependency Documents
• Convert Informatica Scheduling process to ESP scheduling process
• Create Batch Control Information for applications
• Create Load Statistics for mappings
• Create Email tasks to notify Load Success to Business Users
• Perform the Unit Testing of mappings

Environment: Informatica 8.1.1, SQL Server 2005, Windows 2003 Server, UNIX, PVCS

Confidential, Boston, MA

Sr. ETL Developer

Responsibilities:

• Understand Business Requirements and developing business specifications.
• Defining the new Data warehouse Standards and techniques
• Extensively involved in designing Data Extraction and Loading (ETL) process from source to target using Informatica Power Center.
• Training the current data warehouse team how to design and implement their data warehouse based on their own unique necessities.
• Tuning the corporate data warehouse including database tuning, query tuning, ETL tuning and re-modeling.
• Extensively used transformations like Lookups, Update strategy, joiner, Router and Stored Procedure during mapping development.
• Created Reusable transformations and mapplets.
• Developed complex queries to override default SQL queries.
• Performed extensive debugging.
• Created control files for data validation
• Created UNIX scripts to run mappings.
• Created FTP scripts.
• Supported ETL and Business Objects applications,
• Defined the dimensions and the fact tables for the current reports data elements.
• Developed new enhancements and reports based on user’s requirement.
• Trouble shooting Informatica mappings and Business Objects Reports.

Environment: Informatica 8.1.1, Business Objects XI, Oracle 9i,SQL/PLSQL,UNIX, Rapid SQL

Confidential, Chicago, IL

Sr. ETL Developer

Responsibilities:

• Understand Business Requirements and developing business specifications.
• Extensively involved in designing Data Extraction and Loading (ETL) process from source to target using Informatica Power Center.
• Extensively used transformations like Lookups, Update strategy, joiner, Router and Stored Procedure during mapping development.
• Created Reusable transformations and mapplets.
• Developed External PL/SQL Procedures.
• Implemented Exceptions handling through mappings.
• Developed complex queries to override default SQL queries.
• Performed extensive debugging.
• Performed performance tuning.
• Extensively worked on Repository object.
• Scheduled jobs using Workflow manager.
• Supported ETL and Business Objects applications,
• Developed new enhancements and reports based on user’s requirement.
• Worked closely with testing team to test the business logic,
• Trouble shooting Informatica mappings and Business Objects Reports.

Environment: Informatica 7.0, Business Objects 5.1.8, Oracle 9i, Unix

Confidential

Developer

Responsibilities:

• Worked on data analysis for various source systems.
• Involved in the analysis Dimensions and Facts.
• Created design documents based on the Business Requirements.
• Creating mappings, applets and stored procedures
• Implemented change requests
• Developed Sessions and Batches for mappings.
• Creating test cases and testing the Informatica mappings.
• Implemented slowly changing dimensions.
• Used SQL loader to load some of the files to Data warehouse tables.
• Involved in UAT
• Developed UNIX shell scripts to automate the jobs with restart ability.

Environment: Informatica 6.2, Oracle 9i, Unix

Confidential

Developer

Responsibilities:

• Involved in creation of Universe
• Production Support like resolving some reporting tickets, Universe enhancement tickets, and user creation tickets.
• Developed reports according to user’s requirement.
• Fine tuning the reports.
• Informatica load monitoring and mapping enhancements.
• Informatica and Business Objects Trouble shooting.

Environment: Informatica6.2, Business Objects 5.1.8, Oracle 9i, Windows NT