User's Cover Picture
User's avatar

MUHAMMAD JUNAID UMER

Data Engineer | Python Developer

Message
Intro
Karachi, Pakistan
Data Engineer at ilmiya
ETL Developer at Kavtech Solutions (Private) Ltd
Studied Computer science and Software Engineering at International Islamic University, ISLAMABAD
Joined September 12, 2021

Skills

Languages

English
-
Intermediate
Urdu
-
Native or Bilingual
About
4+ years of experience in Data Engineering and Analysis having core expertise in Data Engineering, Python Scripts, API Integration, ETL Pipelines, Data warehouses, Power BI, Optimization of Databases and visualization. I got many job titles in previous years like SQL Data Processing Analyst, ETL Developer, Data Engineer, Data Analyst, DBA, and Python Developer. Tech Stack: - Python | SQL - Power BI - Pentaho | Informatica - AWS - MYSQL | PostgreSQL - Experience in Data warehousing with domain knowledge of telecommunications, Real Estate, and Fintech Based datasets. - Exposure to large data volumes database systems in PostgreSQL and MySQL. I have successfully delivered several Enterprise Data Management projects for Real Estates, Transactional Dataset I do have a working knowledge of the complete Data Engineering development life cycle. Including Requirements gathering, Development, Documentation and Testing. I have extensive experience in managing data integrations, business analytics and reporting using ETL tools that involve its integration using various APIs. I have good analytical & design skills, a focused approach, team player, hard working and professional attitude to work.
Experience
User avatar
ilmiya
Jul 2022 – Present
Remote
Data Engineer
User avatar
Kavtech Solutions (Private) Ltd
Nov 2020 – Present
Lahore, Pakistan
ETL Developer
- Analyzed the source system and was involved in designing the ETL data load. - Extensive SQL querying for Data Analysis and writing, executed, performance-tuned SQL Queries for Data Analysis & Profiling. - Worked in various transformations like Lookup, Joiner, Sorter, Aggregator, Router, Rank, and Source Qualifier. - Implemented documentation standards and practices to make mappings easier to maintain.
User avatar
Johnsnowlabs.com
Jan 2022 – Jun 2022
Remote
SQL Data Processing Analyst
- Creating SQL Queries - Responsible for preparing the existing SQL platform for upgrades that were installed as soon as they were released. - Assisted in creating and presenting informational reports for management based on SQL data.
User avatar
Techline
Jan 2020 – Nov 2020
Lahore, Pakistan
Data Analyst
- Extracting data from MYSQL and PostgreSQL database systems for the purpose of detailed analysis will provide the team valuable and relevant insights. - Validate and provide support for all Analyses using standard statistical methods. - Prepare and present a comprehensive report/summary of conclusions drawn from the analysis. - Identify patterns and develop predictive models on complex data sets
Education
User avatar
International Islamic University, ISLAMABAD
Sep 2014 – Aug 2018
BS IN SOFTWARE ENGINEERING, Computer science and Software Engineering