· 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
Sybase Solutions Corporation Pvt. Ltd., managed by a dynamic team specialized in Information Management & Integration, Enterprise Mobility, Development, Designing and Modeling Tools. Sybase products enables customers to unwind their enterprises, where business-critical information can be securely m ...Read More