AashiqKumar Sharma
Consultant
Palghar
Summary
Jr . ETL Developer and technical Support with 2.6 years of hands-on experience in developing and Support in ETL processes for data integration. Proficient in utilizing ETL tools such as Datastage to extract data from various sources, transform it according to business rules, and load into data warehouses or other target systems. Demonstrated expertise in SQL querying, data profiling, and Ad-hoc Support and Technical Support to ensure optimal ETL process efficiency. Strong problem-solving skills with a commitment to delivering high-quality solutions that meet business requirements.
Overview
3
3
years of professional experience
3
3
years of post-secondary education
2
2
Certificates
Work History
Technical Support and Junior ETL Developer
MINDCRAFT Software Pvt.Ltd.(Client - TATA AIA)
11.2021 - Current
- This project involved providing ETL support and development for a leading insurance company
- The project aimed to maintain and improve data workflows to ensure seamless data availability and integrity for stakeholders
- Responsibilities included providing ad hoc support for ETL processes and data-related queries.
- Assisting in the development of ETL jobs using Datastage.
- Extracting, transforming, and loading data from various sources to target databases.
- Writing complex SQL queries and managing databases (Oracle, SQL Server, MySQL).
- Optimizing queries and performing database performance tuning.
- Implementing data warehousing concepts and ETL workflows.
- Conducting data analysis and improving data quality.
- Gathering and analyzing requirements from stakeholders.
- Collaborating with cross-functional teams.
- Providing technical support and troubleshooting ETL-related issues.
- Monitoring ETL jobs, scheduling tasks, and ensuring timely execution.
- Supported various ad hoc requests from end-users by delivering accurate datasets as per their requirements.
- Implemented proactive monitoring solutions for ETL processes, identifying potential bottlenecks before they impacted users.
UAT (User Acceptance Test)
TATA AIA
03.2023 - 08.2023
- Extracting, transforming, and loading data from various sources to target databases.
- Monitoring ETL jobs, scheduling tasks, and ensuring timely execution.
- Providing technical support and troubleshooting ETL-related issues.
- Technical support
Education
Bachelor of Science in Information Technology -
MUmbai University
Palghar, Maharashtra 01.2018 - 04.2021
Skills
ETL Support (Datastage)
Data Extraction, Transformation, and Loading
SQL and Database Management (Oracle, SQL Server, MySQL)
Oracle SQL Developer
Data Warehousing
Data Analysis and Improvement
Requirement Analysis
Strong Analytical and Problem-Solving Abilities
Team Collaboration
Technical support
Jobs Monitoring and scheduling
Cloud Fundamentals
Certification
IBM Datastage For Administrators and Developers (Udemy)
Timeline
UAT (User Acceptance Test)
TATA AIA
03.2023 - 08.2023
Technical Support and Junior ETL Developer
MINDCRAFT Software Pvt.Ltd.(Client - TATA AIA)
11.2021 - Current
Bachelor of Science in Information Technology -
MUmbai University
01.2018 - 04.2021
Technical Details
Datastage, Oracle, SQL Server, MySQL, SQL, PL/SQL, Oracle SQL Developer, Data Warehousing, Data Analyst, Technical Support
UAT Project Duration
5 months
Technical Details
Datastage, Oracle, SQL Server, MySQL, SQL, PL/SQL, Oracle SQL Developer, Data Warehousing, Data Analyst, Technical Support