• Over 5+ years of IT experience with expertise in analysis, design, development and implementation of Data warehouses and Decision Support Systems (DSS) using ETL tools Informatica 10.2/9.x with RDBMS like Oracle, MS SQL server, Teradata and MySQL databases on Windows and UNIX platforms.
• Extensive exposure in overall SDLC including requirement gathering, development, testing, debugging, production deployment and production warranty support.
• Extensive experience of providing IT services in engineering, construction and HealthCare domain.
• Good understanding of Data Warehousing Concepts like Dimensions Type I and II, Facts, Surrogate keys, ODS, staging area.
• Good understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling.
• Good experience of writing SQL Queries for Data analysis, Data mapping specification, Data Profiling, Data Migration and creating Data Dictionaries.
• Expert in writing complex SQL queries and optimizing the queries in Oracle, SQL Server and Teradata.
• Experience in developing very complex mappings, reusable transformations, sessions and workflows using Informatica ETL tool to extract data from various sources and load into targets.
• Experience in tuning and scaling the procedures for better performance by running explain plan.
• Experience in Performance tuning of ETL process using pushdown optimization and other techniques.
• Used mapplets, user defined functions, reusable transformations, look-ups in Informatica mapping.
• Assisted the other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.
• Skilled in creating Source to target mapping, ETL Specification Documents and capturing requirement.
• Experience with Informatica tools using real-time CDC (change data capture) and MD5.
• Good communication and presentation skills, works well as an integral part of a team, as well as independently, intellectually flexible and adaptive to change.

TECHNICAL SKILLS:

• ETL tools Informatica PowerCenter 10.2/9.6/9.2
• RDBMS Database Oracle 12c/11g, MS SQL Server 2018, MySQL, Teradata 16
• Tools Microsoft Visio, Erwin 9.5/8.1, TOAD, Oracle SQL developer, WINSCP, MS Office,
• Control-M, Rally, JIRA
• Mythologies SDLC, Agile, Waterfall