J

Jackson Vieira

About

Detail

São Caetano do Sul, State of São Paulo, Brazil
Contact Jackson regarding: 
work
Full-time jobs

Timeline

work
Job
school
Education

Résumé

Jobs verified_user 0% verified
  • Intermedia
    Senior Data Engineer
    Intermedia
    Feb 2025 - Current (1 year 9 months)
    • Designing and implementing scalable integrations between Salesforce CRM, NetSuite ERP, and other systems via APIs using Boomi • Supporting the ongoing implementation of Process Optimization improvements, specifically around Product Data Processes • Building, monitoring, and maintaining ETL pipelines using Boomi • Ensuring data integrity and performance through unit testing, UAT, and DevOps best practices • Managing tasks and progress using JIRA (planning meetings, dailies, review, retrospective, and refinement) • Focused on delivering efficient, automated, and reliable data workflows to enhance business operations and scalability
  • d
    Senior Data Engineer
    dPlus
    Jun 2024 - Jan 2025 (8 months)
    • Pipeline development in AWS using Airflow DAGs and data modeling in Athena (CTE statements) • Creation of fact and satellite tables as sources for Power BI dashboards in the gold layer (medallion architecture) • Development of SQL queries and data transformations in AWS Athena • ETL process development and optimization for silver to gold layer transitions • Data cleaning and analysis in PySpark for silver layer tables • Participation in Sprints using Jira (planning meetings, dailies, review, retrospective, and refinement)
  • H
    Senior Data Engineer
    HARTB
    Mar 2023 - May 2024 (1 year 3 months)
    • ETL/ELT process development, pipelines in Azure Data Factory (ADF), Synapse Analytics, and Databricks Notebooks (Python and SQL codes) • On-premise data ingestion to Azure Data Lake Storage (ADLS) in the Bronze layer (raw) in parquet format using ADF, transformations in Databricks using PySpark library for the Silver (validated) and Gold (enriched) layers in delta table format (cleaning, deduplication, aggregation, etc.) • ADF pipeline development for consuming REST APIs and storing data in the Bronze (raw) layer of Storage • Implementation of CI/CD pipelines in Azure DevOps • Migration of legacy SSIS packages on-premise to ADF (sources: Tasy, WPD, and MV hospital systems, and TOTVS Protheus ERP) • Development of SSAS cubes (multidi
  • Challenge TI
    Senior Data Engineer
    Challenge TI
    Nov 2020 - Mar 2023 (2 years 5 months)
    • Pipeline development in Azure Data Factory (ADF) and Data Cleaning in Databricks Notebooks (Python codes) • Migration of legacy SSIS packages on-premise to ADF • Development and updating of Power BI dashboards via ADF (datasets automatically updated via pipeline) • ETL process development in SSIS • Creation and consumption of REST APIs via C# (testing via Postman) • Data analysis/exploration in SAS • Transposition of PL/SQL business rules to T-SQL • Participation in Sprints using Jira (planning meetings, dailies, review, retrospective, and refinement)
  • Accenture Brasil
    Senior Data Engineer
    Accenture Brasil
    Nov 2017 - Nov 2020 (3 years 1 month)
    • Migration of on-premise environment (Control-M meshes) to GCP (Cloud Composer) and validation/homologation • Development of ETL processes in PowerCenter 10.2 (loading Flat Files into Oracle) and troubleshooting workflows (manager, monitor, designer) • Troubleshooting of entire Big Data ecosystem (nodes offline, HDFS issues, fixing partitions in HIVE PostgreSQL/Greenplum tables, adhoc shell scripts, etc.) • Development of dashboards in Power BI and Looker • Maintenance of ETL routines in DataStage environment • Data analysis/exploration in Python and SAS • Management of RabbitMQ queues (configuration, monitoring, and troubleshooting) • Environment maintenance, with 24x7 on-call support (N3 level) • Agile methodologies (Scrum and K
  • A
    Senior Data Engineer
    Amil Assistência Médica)
    Jun 2017 - Nov 2017 (6 months)
    • Development of ETL processes in SSIS • Development of multidimensional SSAS cubes in Microsoft Parallel Data Warehouse (PDW) • Data analysis/exploration in Python and SAS • Extractions via Sqoop from Big Data (HIVE tables) to Oracle (dashboards and studies) • Data analysis/exploration in R and SAS
  • I
    Senior BI Analyst
    IQVIA Brasil)
    May 2012 - Jun 2017 (5 years 2 months)
    • Development of ETL processes in SSIS • Development of ETL processes in Pentaho (government's Datasus database) • Development of SSAS OLAP cubes and offline (Excel templates) • Administration of databases for all servers (physical machines and VMs via Citrix), acting as DBA and AD • Development of dashboards in Power BI and Tableau • Analysis of hardware/software for server acquisition/upgrade • Agile methodologies (Scrum and Kanban)
  • Unione
    Senior BI Analyst
    Unione
    Jul 2011 - May 2012 (11 months)
    • Development of a Database Marketing (DBM) for the CRM area • Development of ETL processes in SSIS • Development of SSAS cubes (multidimensional) • 24x7 on-call support for legacy systems
  • Cadmus
    Senior BI Analyst
    Cadmus
    Apr 2009 - Jul 2011 (2 years 4 months)
    • Development of 3-tier architecture (DLLs in VB connecting to mainframe broker/COM+/IIS/ASP) • Development of Excel dashboards (VBA) with OLAP Essbase as a data source • Development of ETL processes in SSIS • Development of ETL processes in DataStage • Data analysis/exploration in SAS • Ad-hoc extractions in Teradata • 24x7 on-call support
  • I
    Senior Systems Analyst
    Interfile Business Process Outsoucing
    Aug 2008 - Mar 2009 (8 months)
    • Development of 3-tier architecture (DLLs in VB/COM+/IIS/ASP) • Acting as a SQL Server 2005 and Oracle 8.1 DBA (tuning applications, backup/recovery of databases) • Deadline management using MS Project
  • K
    Business Analyst
    Ka Solution
    Mar 2007 - Aug 2008 (1 year 6 months)
    • Responsible for migrating ERP RM (currently TOTVS) version 6 to 10.20 (Saldus, Fluxus, Bonum, and Nucleus) • Requirements gathering in Accounting, Treasury, Budgeting, and Accounts Payable/Receivable departments • Analysis and performance improvement in SQL Server 2000 (tuning) • Management and implementation of third-party solutions (packages) with Bovespa • T-SQL coding (SQL Server) • PL/SQL coding (Oracle) • VB 6 / Dot.net coding • 24x7 remote on-call support • Deadline management using MS Project
  • W
    Senior Systems Analyst
    WA Informática
    Jan 2006 - Mar 2007 (1 year 3 months)
    • Development of 3-tier architecture (DLLs in VB/COM+/IIS/ASP) • Crystal Reports reporting • Deadline management using MS Project • Occasional on-call shifts for version turnovers, application of database changes (creation of Back-and-Forth Plans)
  • P
    Senior Systems Analyst
    Point Systems
    Jan 2005 - Jan 2006 (1 year 1 month)
    • Development of 3-tier architecture (DLLs in VB/COM+/IIS/ASP) • Deadline management using MS Project
  • P
    Programmer/Analyst Jr/Pl/Sr
    Aug 1999 - Dec 2004 (5 years 5 months)
    • During this period (4 years), I worked with various clients across different sectors (banks, call centers, healthcare), primarily as a developer in low-platform systems. I acquired experience and expertise in the field, developing in Clipper, VB (all versions)/VBA, and Delphi
  • SAO PAULO
    Data Processing Technician
    SAO PAULO
    Jan 1994 - Jan 1998 (4 years 1 month)
Education verified_user 0% verified
  • Universidade Mackenzie
    Bachelor of Information Systems
    Universidade Mackenzie
    Jan 1999 - Jan 2002 (3 years 1 month)