DWH ETL Consultant (Informatica, Oracle SQL and PL/SQL, Unix, BO)

• Core Data Warehousing experience of 8+ years, with focus on ETL (Informatica), Data Modeling, Data Analysis, PL/SQL and UNIX Shell Scripting.
• Informatica Certified Developer in Informatica 8.x.
• Comprehensive experience in Software Development Life Cycle which includes Requirement Analysis, Functional Analysis, Design, Development, Implementation, Testing, Debugging, Productions Support, and Maintenance of various Data warehousing Applications.
• Proficient in understanding Business Processes / Requirements and translating them into High level and low level Technical specifications.
• Extensive experience in working in onshore/offshore development model.
• Extensive experience in managing fixed price projects.
• Profound knowledge in banking and financial domain.
• Data Warehousing experience using Informatica Power Center 8.6/7.x/6.2/6.1.
• Design and Development of Universes and Reports using Business Objects XI R 3.1
• Experience in Solaris (SDSS) Packaging using Generic Staging 6.x/7.x.
• Strong knowledge on handling SwanXP Change Requests.
• Proficient in the integration of various data sources such as Oracle, SQL Server, Sybase, Fixed Width Flat Files, Delimited Flat Files, VSAM files.
• Proficient in the development of ETL (Extract, Transform, Load) processes with a good understanding of source to target data mapping, ability to define, capture Metadata and Business rules.
• Experienced in Performance Tuning and Debugging of existing ETL processes.
• Experienced in Star-Schema, Snow-Flake data modelling, Normalization, Logical and Physical data model design process.
• Experienced in developing Test Plans, Test Strategies and Test Cases for Data Warehousing projects ensuring the data meets the business requirements.
• Sound knowledge of RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL, Stored Procedures.
• Experience in UNIX shell scripting, job scheduling on multiple platforms like windows NT/2000, Linux environment.
• Designing ETL Jobs and Execution flow using Autosys and Control-M Scheduling tool.
• Proposal Writings for various Data Warehousing and ETL Related Projects.
• Maintain an awareness of existing, new and emerging technologies.
• Team player, motivated and dynamic with excellent oral and written communication skills.
• Worked extensively on Rational Clear case, Quality Center, Remedy, PACE, TOAD, Rapid SQL, CVS and Sub Version.
• Onsite experience of more than 1 year in US for Fidelity Investments.
• Working as a Senior IT Consultant for Credit Suisse AG, Zurich in Credit & Risk Domain, handling areas such as Analysis, Design, ETL Development, Unit Testing, Integration and Acceptance Testing, Production Deployments and Support.


SOFTWARE SKILLS
ETL Tool Informatica Power Center 8.6/7.x/6.x
Data Modeling Tools Power Designer
Databases Oracle 11g/10g, Awareness on DB2 and Sybase
Business Domain Banking and Finance
Languages SQL, PL/SQL, Unix Shell Scripting
Reporting Tool Business Objects Designer and Reports XI 3.0
Testing Tool HP Quality Center
GUI Tools TOAD, RAPID SQL
Operating Systems Sun Solaris, HP UNIX, Linux, Windows Server 2000
Versioning Tools CVS, SVN, Clear case
Others MS Project/Visio 2010, Autosys, Control-M, Clearquest
Remedy, PACE, SwanXP, SDSS