Malt welcome

Welcome to Manohar's freelance profile!

Malt gives you access to the best freelancers for your projects. Contact Manohar to discuss your project or search for other freelancer profiles on Malt.

Manohar Bisht

Data Engineer
  • Suggested rate
    £208 / day
  • Experience3-7 years
  • Response rate100%
  • Response time1 hour
The project will begin once you accept Manohar's quote.
Location and workplace preferences
Location
London, England, United Kingdom
Remote only
Primarily works remotely
Verifications

Freelancer code of conduct signed

Read the Malt code of conduct
Verified email
Languages
Categories
Share this profile
Skill set (15)
Manohar in a few words
A methodical and innovative Data Engineer with extensive experience in in software development, Application support, Database design, Data management, Data integration and ETL/ELT pipelines of batch / streamed processing.

I have expierence in various tools and technologies like SQL, PL/SQL, Python, Apache Airflow, Kafka, dbt, snowflake, Oracle databases, Informatica, Tableau which I gained across my expierence.

My recent achivements includes
1. Landing colleague performance data for sainsbury and Argos Depot employees to snowflake for performance reporting and enhancement in record time from kafka to snowflake resulting reporting on time which made an financial impact on overall performance of each employe.
Experience
  • Sainsbury's Digital, Tech and Data
    Data Engineer
    October 2022 - Today (2 years and 1 month)
    London, UK
  • Coforge
    Data Engineer
    October 2020 - Today (4 years and 1 month)
    United Kingdom

    • Work closely with Business Analysts of Cargo domain to understand requirement of data for visualization and analytics.
    • Uses ETL Techniques (Informatica, Python script, Bash Script, PL/SQL, SQL Loader and SQL) to develop pipelines for data loading, transforming and ingestion into on-prem data warehouse and AWS Redshift.
    • Ensure data governance and modeling.
    • Design and develop below 2 types of pipelines to copy data into AWS Redshift Tables i. Copy structured data (csv, parquet) from S3 files to Redshift tables using Lambda function ii. Transform and Load semi structured data (JSON, XML, text log files) from S3 to Redshift tables using AWS Glue, Athena pipelines.
    • Developed below pipelines in on-prem using Informatica, SQL Loader, Bash and SQL i. ETL pipeline for Airline registered Agents data from Salesforce to Oracle database. ii. ETL pipeline to copy flight disruption data in csv to oracle database using shell script and sql loader. iii. ETL pipeline to copy revenue data from AWS RDS database to on premise oracle database.
    • Developed Tableau Dashboards i. To visualize real time alerts generated by databases which helps to quickly identify the issue in database by L2 ops team. ii. To visualize database inventory at various grouping level for database support team.
    • Uses AWS Services like S3, Lambda, AWS Glue, AWS CatLog, AWS Athena, AWS redshift, AWS Sage maker.
    • Exposure to Apache Hive, Apache Kafka, Apache Presto, Apache Spark, Apache Airflow
    • Works in Agile environment and uses Automated CI/CD process of Git and Jenkins.
  • NIIT Technologies
    Oracle Application Database Administrator
    May 2014 - September 2020 (6 years and 4 months)
    London, UK

    • Administration of Oracle database (Standalone, RAC, ASM) and Microsoft SQL server databases up to 100 TB in 10g, 1 1g,12c and 19c.
    • Proficient in SQL, PL/SQL, SQL Performance tuning, Indexing, and using database statistical tools (AWR, explain plan, Segment advisor, SQL tuning advisor, SQL profiles, fragmentation).
    • Designed multiple databases for application at schema, object (tables, view, MVIEWS, procedures) level.
    • Supported NO SQL Redis (in memory) database used for in memory customer data for ba.com.
    • Worked with HDFS (Hadoop architecture) using Hive tool.
    • Automated below solutions resulting saving in effort and cost. i. Schema cloning process on ba.com dev database which saved effort of manual cloning and reduces cloning effort to 10%. ii. Monitoring process of oracle databases (700+) using centralized database using SQL, PL/SQL, and bash scripting. iii. Database users audit process in BA which reduced the effort of auditing from 45 days to 10 days.
    • Expertise in oracle migrations/upgradations.
Recommendations
Education
  • Bachelor of Science
    Delhi University
    2006
    Bachelor of Science (B.Sc.), Mathematics and Computer Science
  • MCA, Computer Science
    SMU
    2012
    MCA, Computer Science
  • XII, Physics, Chemistry and Maths
    Kendriya vidyalaya
    2003
    XII, Physics, Chemistry and Maths
Certifications
  • Tableau
    Tableau
    2022
  • AWS Practcioner
    Amazon
    2021
  • OCP
    Oracle
    2019