ETL Developer / BI Resource

7NSoft Systems (Pvt) Ltd Unverified

Karachi , Pakistan

Posted Nov 06, 2019 147 views

PKR. 40,000 - 150,000/Month

Apply For This Job


Job Description

·         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

Total Positions:
1 Post
Job Shift:
Second Shift (Afternoon)
Job Type:
Job Location:
Minimum Education:
Career Level:
Experienced Professional
Minimum Experience:
4 Years
Apply Before:
Dec 05, 2019
Posting Date:
Nov 06, 2019
Show fewer details Read full job description

What is your Competitive Advantage?

Get quick competitive analysis and professional insights about yourself
Talk to our expert team of counsellors to improve your CV!
Try Rozee Premium

7NSoft Systems (Pvt) Ltd

Information Technology · 1-10 employees - Karachi

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