Description
PROFESSIONAL SUMMARY * Over (7+) years of experience in the IT field with extensive Data Warehousing implementations and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter 9.5.1/8.6.1/7.1 and PowerExchange 9.5.1/8.6. * Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment. * Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets. * Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema). * Extensively worked on Data extraction, Transformation and Loading data from various sources like Oracle, SQL Server and Flat files (.txt, .dat, .csv & xml). * Proficient in Optimizing Database querying, data manipulation and population using SQL PL/SQL and Utilities in Oracle 11g/10g/9i, Teradata 13/12/V2R6, DB2 UDB and SQL Server 2008/2000, Sybase databases. * Experience in integration of various data sources like Oracle, DB2, Sybase, SQL server and MS access and non-relational sources like flat files into staging area and DWH DB. * Experience in creating Reusable components like transformation, mapplets and tasks. * Loading data from various data sources and legacy systems into Teradata production warehouse using utilities BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD. * Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages. * Excellent working knowledge of UNIX shell scripting, job scheduling on multiple platforms, experience with UNIX command line and LINUX. * Worked on CDC using Informatica PowerExchange to load data in Real-time mode. * Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase. * Assign work and provide technical oversight to onshore and offshore developers * Excellent analytical/communication skills and good team player. * Worked on workflow parameters & variables to run the workflow dynamically. * Have good experience by communicating with customer's regarding the requirements, issues & tasks. * Good understanding of Data Warehousing Concepts. * Created test cases for the mappings developed and then created unit test plan document. * Have hands on experience in Team Leading / Team coordination / Problem solving. * Hands on experience in database programming Complex SQL queries. * Worked at client location & co ordinate team activities. * Excellent communication, documentation and presentation skills.
Accomplishments
Highlights:
Keywords
