نبذة عني
Software developer with 5+ years of experience in IT sector specializing in Data Engineering, Data Warehouse & Business Intelligence (BI) platform with expertise in Data Analysis, Design and implementation of Database an…
Software developer with 5+ years of experience in IT sector specializing in Data Engineering, Data Warehouse & Business Intelligence (BI) platform with expertise in Data Analysis, Design and implementation of Database and ETL processes using Talend Data Fabric, Developing BI reports & dashboards using Tableau and Power BI.
Worked on Data Warehousing & Business Intelligence projects that includes jobs related to Data Integration, Data Migration and Business Intelligence.
Having good experience in interacting with various stakeholders such as Data Architect, Database Administrators, Business Analysts, Business Users & Product Owners.
الخبرة
ETL & BI Developer / Tech Lead
<p>Evaluating functional requirements and mapping documents<br>
Extracting and analyzing the source data<br>
Creating data model, mappings and ETL workflows<br>
Creating custom database SQL programs for business logics<br>
Creating Business Intelligence (BI) dashboards and reports<br>
Writing and validating test cases and design documents<br>
Assisting team in ongoing development works<br>
Engaging clients in requirement gathering, development activities and reporting</p>
PowerBI Developer
Evaluating functional requirements & mapping documents
Extracting & analyzing the source data
Creating Data model, mappings & ETL workflows
Creating custom database SQL programs for business logics
Creating Business Intelligence (BI) dashboards & Reports
Writing & validating Test cases & design documents
Assisting team in ongoing development works
Engaging clients in requirement gathering, development activities and reporting
ETL and Power BI Developer
<p>Designing and developing data integration jobs in Talend to retrieve data from source systems and load them into the enterprise data vault and data warehouse dimensions and facts tables<br>
Designing aggregated tables according to business requirements<br>
Using views and stored procedures to process the data effectively<br>
Working with the business team to assist user acceptance tests<br>
Configuring data integration jobs to run in different frequencies as needed<br>
Publishing Power BI reports in Power BI Service to share the reports<br>
Creating Power Automate tasks to send the Power BI report as a PDF to users via mail</p>
ETL and BI Developer
<p>Creating users and projects using Git Repository and Remote engines in Talend Management Console<br>
Assigning roles to users and permitting the level of access to each user<br>
Using ETL methodologies and best practices to create Talend ETL jobs<br>
Enhancing programming and naming standards to load the data from various sources<br>
Building DI jobs to retrieve the data from source systems and load into dimensions, time variant dimensions and facts<br>
Tuning SQL source queries to restrict unwanted data in ETL process<br>
Optimizing ETL jobs and using views and stored procedures effectively<br>
Creating jobs to take weekly, monthly and yearly snapshots for building reports<br>
Scheduling jobs in Talend cloud version for incremental load<br>
Creating Tableau dashboards and reports for business analytics</p>
Tableau BI Developer
<p>Building Tableau dashboards based on requirements from SQL Server<br>
Resolving performance issues for existing dashboards<br>
Creating aggregated queries to reduce extracting time from source<br>
Publishing and scheduling Tableau dashboards in Tableau Server<br>
Monitoring Tableau run status using Tableau administrator access<br>
Creating interactive Tableau workbooks using Tableau Desktop<br>
Publishing Tableau dashboards and scheduling them in Tableau Online</p>
Data Integration (Talend) and Business Intelligence (Tableau) Developer
<p>Preparing data mappings<br>
Acquiring and interpreting business requirements, creating technical artifacts, and determining the most efficient and appropriate solution design<br>
Extracting, transforming and loading data from different data sources<br>
Handling data using Talend Tool (Big Data)<br>
Developing and analyzing Hadoop cluster and different Big Data components including Pig, Hive, Spark, HBase, Kafka, Elastic Search, database and Sqoop<br>
Installing Hadoop, Map Reduce, Confidential, and developing multiple Map-Reduce jobs in Pig and Hive for data cleaning and pre-processing<br>
Performing performance tuning and optimization in product<br>
Preparing and performing incremental logic along with job audits and mail alerts for job status<br>
Creating rich dashboards using Tableau and applying actionable insights<br>
Generating dashboards with quick filters, parameters and sets to handle views more efficiently<br>
Developing Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD analysis</p>
ETL and Tableau BI Developer
<p>Building DI jobs to retrieve data from source systems and design dimensions, time variant dimensions and facts<br>
Optimizing ETL jobs and using views and stored procedures effectively<br>
Designing aggregate tables according to business requirements<br>
Creating jobs to take weekly, monthly and yearly snapshots for building reports<br>
Coordinating with the team to fix issues and guiding the team to complete modifications and new business requirements<br>
Scheduling jobs in cloud version for incremental load<br>
Creating rich dashboards using Tableau and applying actionable insights<br>
Scheduling dashboards in Tableau Server for incremental refresh</p>
Power BI Developer
<p>Studying, analyzing and understanding business requirements in context to business intelligence<br>
Understanding the Qlik Dashboard and creating a data model accordingly<br>
Analyzing previous and present data for better decision making<br>
Creating Power BI report and complex DAX queries efficiently<br>
Validating the data in visuals and implementing quality checks</p>