A highly motivated and goal oriented professional over 17 years of experience in Informatica ETL Design, Data Warehousing, Data Modeling and Data Engineering. Experienced in building data warehouse design from scratch. Ability to perform as a good team player and build up a collaborative team. Excellent problem-solving skill and adept at handling a high-pressure fast-paced work environment.Specialties:- Demonstrated expertise to implement Data Integration Solution by developing ETL/ELT processes using Informatica tools (Workflow Designer, Workflow Manager and Workflow Monitor) heterogeneous data sources- Extensively worked on Analysis, Design, Development, Implementation and Maintenance of moderate to complex ETL components in Informatica, UNIX shell scripts, Oracle, PL/SQL & Teradata - Strong understanding of Data Modeling in DWH environment (Star schema and snowflake schema)- Strong analytical and conceptual knowledge in Database Design and Development for Relational databases like Oracle, PostgreSQL, MySQL and Teradata - Experienced in writing, testing, and implementation of the Cursors, Procedures, and functions at database level using PL/SQL and MySQL stored procedures. - Hands on with MLOAD, FASTLOAD, TPT, and FAST EXPORT utilities of Teradata utilities for faster loading. - Familiar with Erwin 4.X and Sybase Power Designer 11 as Data modeling tools. - Working experience in a traditional Waterfall Based as well as Agile Methodologies of Software Development Life Cycle - Excellent communication and interpersonal skills, ability to learn quickly and high adaptability to new tools and technologies.
