Description
Experience Summary: * 11+ years of total experience in Business Requirements Analysis, Data Integration, Data Warehouse/Data Marts, Business Intelligence, ETL, Dimensional Data Modeling, Coding, Development, Testing and Implementation with RDBMS and non RDBMS. * 10 years of experience using Informatica in designing and developing ETL mappings and scripts using Informatica Power Center 9.6/9.5/9.1/8.6/8.5/8.1/7.1/7.0. * 3 Years of experience in designing and developing ETL mappings and scripts using SAP data services-BODS. * 2 Years of experience in SAP HANA modeling creating attribute, analytical and calculation views * 11+years of database experience using Oracle, DB2 MS SQL Server, Teradata, PostgreSQL, Sybase IQ Netezza, SAP HANA * 2 years of experience in IBM infosphere Change Data Capture- CDC management console. * Extensive experience working in Wealth Management, Finance, mortgage, retail and sales-shipment. * Experience in translating user requirements into functional, technical specifications and ETL mapping documents. * Experience on Dimensional Data Modeling like Star and Snowflake schemas. * Business Intelligence experience using Oracle BI (OBIEE), Business Objects and Tableau. * Extensively worked on SQL & PL/SQL programming. * Skilled in UNIX shell scripting and experience on different UNIX platforms. * Excellent troubleshooting/Production Support skills, user interaction. * Experiences on big data - Hadoop-HDFS, Hive and map reduce. * Experience in working on Informatica data quality-IDQ to attain data profiling, worked on reference data. * Experience in working on Informatica Meta data manager. * Experience in Master data management-MDM * Experience in working in an onsite-offshore structure and effectively coordinated tasks between onsite and offshore teams. * Experience in working with business users in gathering requirements, converting them to technical artifacts. * A highly motivated self-starter and a good team-player with excellent verbal and written communication skills. * Experience in training business users on using products developed and creating user support documents. * Experience in creating TIDAL batches to schedule jobs as per the business needs. * Proficient in production support activities with effective change management configurations using visual source safe VSS, Handling Incident tickets, change requests and Problem tickets using Remedy Incident Management and Quality Center tool. * Involved in carrying out Quality Reviews, Audits, design and development reviews, review of user-cases and test-cases, business scenarios and root-cause analysis, coordinating user acceptance testing, training, and implementing new processes.
Accomplishments
Highlights:
Keywords
