· Experience in creating HANA Native Data Models
· Experienced in SDI/SDA
· Design ETL jobs to extract, transform data from multiple sources
· Design Flow graphs, Replication tasks and HANA Procedures for extracting, transforming data using Smart Data Integration
· Replicate data Real-time for running Real-time Analytics Dashboard
· Knowledge of HANA SQL and development will be an added advantage
· Experience with ETL/ ELT tools such as Data Services, Informatica, Data Stage, SSIS and HANA SDI/SDQ
· Worked on Informatica Designer Components – Source Analyzer, Target Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
· Strong Experience on Workflow Manager Tools – Task Developer, Worklet & Workflow Designer.
· Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schemas.
· Designed, developed ETL mappings, enabling the extract, transport and loading of the data into target tables.
· Responsible for creating and modifying PLs, Packages, procedures, functions, cursor, refcursor, view, materialized view, collections etc. according to the business requirements.
· Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter, source qualifier and Aggregator transformations.
· Created and scheduled Worklets. Setup workflow and Tasks to schedule the loads at required frequency using Workflow Manager.
· Designed and developed Informatica mappings for data loads and data cleansing. Extensively worked on Informatica Designer.
· Implemented a partitioning strategy similar to Informatica’s partitioning to increase parallelism.
· Performed tuning functions on Informatica sessions, batches and other related scripts.
· Extensively used almost all of the transformations of Informatica including lookups, stored procedures, Update Strategy and others.
· Prepare documentation on all aspects of ETL processes, definitions and mappings.
Rigorous unit testing and functional testing to reduce the defects before QA
Legacy to the Cloud Founded in 2004 by visionaries from leading technology organizations, MLOGICA’s leaders envisioned a faster, more efficient way of modernizing IT infrastructures to eliminate the skyrocketing costs of legacy systems that had stymied innovation and eaten away at enterprise profitability for years. They also realized modernization offered their customers the opportunity to harness the power of globally dispersed data to build revenue. mission is to assist its customers in driving enterprise profitability through advanced analytics and Cloud modernization. Helping customers unravel the complexities of migrating mission-critical, enterprise applications, databases, infrastructure, and data—while saving them time, money and business disruption is how we do it.