VALIBABA SHAIK
Data Engineer
Dublin
Summary
Technical Expert with an extensive experience in implementing solutions with Oracle Database Technologies, SQL, PL/SQL, SQL*Plus, TOAD,
SQL*Loader, Oracle performance tuning, UNIX Shell Scripting, MS SQL Server, Google SQL and Autosys Jil Scripting.
Strong working experience with large scale Data warehousing and Data Lake project implementations with Data Vault 2.0. Hands on working
experience in Python to build Data pipelines.
Overview
11
11
years of professional experience
Work History
Specialist
Bosch Global Software Technologies
02.2022 - Current
- Understand and analyzed the feasibility of the Business Requirement given in the OKR's and create the EPIC and respective Jira tickets.
- Implemented and designed ETL data pipelines using Python.
- Implemented the GDPR attributes anonymization service using PLSQL.
- Implemented Central Logging mechanism, when different DB API services are called using PLSQL.
- Experience with data storage and processing frameworks like Hadoop and Spark.
- Created the Raw-Vault objects like Hubs, Links & Satellites, and End Dating-Satellite objects.
- Worked on Physical Data model changes and extensions in Raw-Vault.
- Created and modified the Data-pipeline procedure to load the data from Stage schema to Raw-Vault schema to load the data from Stage to Raw Vault objects.
- Created the Delivery & Application views by incorporating business logic as per User department requirement.
- Written Python code for Unit & Integration test cases for Data Ingest service.
- Worked on utPLSQL testing framework for PLSQL & SQL.
- Strong experience with Agile & DevOps methodology practices.
- Participated in code reviews to ensure code quality met as per standards defined.
- Created Liquibase DB scripts for deployment to Dev, Qua and Prod.
- Worked on creating Splunk alerts and Dashboards to monitor various DB API servies.
- Prepared and documented the Run books, Data flow and Architecture diagrams.
- Leveraged specialized knowledge to act as subject matter expert within organization.
SQL Developer
Global Logic
11.2019 - 02.2022
- Developed the new collaterals (reports) from the scratch using Google internal eco-system and also modified existing collaterals as per the business requirements.
- Worked closely with PO's for requirement feasibility gaps and data mapping.
- Provided technical leadership to teammates through coaching and mentorship.
PL/SQL Developer
Birlasoft
06.2018 - 10.2019
- Created and modified PL/SQL Packages, Procedures and Functions effectively incorporate business logic.
- Migrated 80+ Oracle SQL queries into Azure SQL queries in reporting system.
- Worked on tuning the queries to improve the performance of the system.
PL/SQL Developer
Tata Consultancy Services
04.2016 - 05.2018
- Worked Data migration from Oracle 11g systems to Exadata 12c migration for large scale DWH systems.
- Identified and created Indexes for the required columns to improve the performance of the queries.
- Written SQL queries for adhoc reporting.
PL/SQL Developer
Tech Mahindra
11.2013 - 03.2016
- Delivery of BAU L3 Support functions, work on BAU Production support environment and manage client expectations in terms of delivery SLAs.
- Monitoring and Supporting the client applications and On-call dedicated Critical Support 24*7 for client dedicated applications.
- Involved in various processes like Incident management, Problem management and Change management.
Education
Master of Science - MSc - Computer Science
Andhra University
2010
Bachelor of Science - BSc - Computer Science
Andhra University
2007
Skills
- SQL, PLSQL, Python & Unix Shell Scripting
- Data Modeling, Data Vault 20, Data Warehousing & Data Lakes
- Azure Data Factory, Azure Databricks, Azure SQL & Snowflake SQL
- Oracle 11g/12c/19c, MS SQL server, Hadoop/Spark frame work & SQL/NoSQL databases
- Agile/Scrum Methodology
Languages
English, Hindi, Telugu, German
First Language
English
Proficient
C2
Hindi
Proficient
C2
Telugu
Proficient
C2
German
Beginner
A1
Certification
DP-203: Data Engineering on Microsoft Azure
PL-300: Power BI Data Analyst
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Specialist
Bosch Global Software Technologies
02.2022 - Current
SQL Developer
Global Logic
11.2019 - 02.2022
PL/SQL Developer
Birlasoft
06.2018 - 10.2019
PL/SQL Developer
Tata Consultancy Services
04.2016 - 05.2018
PL/SQL Developer
Tech Mahindra
11.2013 - 03.2016
Master of Science - MSc - Computer Science
Andhra University
Bachelor of Science - BSc - Computer Science
Andhra University
Similar Profiles
Girish MGirish M
Senior Manager, Data Analytics at Bosch Global Software Technologies (BGSW – Bosch)Senior Manager, Data Analytics at Bosch Global Software Technologies (BGSW – Bosch)
PANDU RANGA RAO UPANDU RANGA RAO U
Senior Network Engineer at Bosch Global Software Technologies Pvt. Ltd.Senior Network Engineer at Bosch Global Software Technologies Pvt. Ltd.
Kunal ChaturvediKunal Chaturvedi
IT Project Manager ( IT Governance Automations) at Bosch Global Software Technologies Pvt. LtdIT Project Manager ( IT Governance Automations) at Bosch Global Software Technologies Pvt. Ltd
Linto TomyLinto Tomy
Head of Operations at AlShield – Bosch Global Software Technologies Pvt LtdHead of Operations at AlShield – Bosch Global Software Technologies Pvt Ltd
PARTH SUNIL PATHAKPARTH SUNIL PATHAK
Assistant Manager / Supervisor at Circle K EuropeAssistant Manager / Supervisor at Circle K Europe