Posted Nov 06, 2019 5 views
· 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
Job Details
7NSoft Systems (Pvt) Ltd
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.
What is your Competitive Advantage?
Ali Aziz
CEO
Shopistan
Zohaib Ali
Marketing Manager
Digital Online Devices
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
Muzammil Baig
Digital Marketing Manager
IT Services Group
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
Mona Sharif
Senior Team Lead
Konext PVT. LTD
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
Aqib Irshad
Head of HR, Training & OD
FINCA
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
