Joao Cotrim, Developer in Lisbon, Portugal
Joao is available for hire
Hire Joao

Joao Cotrim

Verified Expert  in Engineering

Data Engineer and Developer

Lisbon, Portugal
Toptal Member Since
December 20, 2022

Joao has been working as a data engineer since 2009. In the last two years, he mainly worked on energy and utilities projects with different responsibilities, from developer to technical lead on a ten-element team. Joao is keen on problem-solving and constantly searches for the best solution. He works well independently but enjoys working in a group, learning, and sharing knowledge. He is very familiar with Agile-Scrum and ServiceNow, not only as an end user but also as a data source.


DXC Technology
Databases, SQL, Databricks, Informatica PowerCenter, Oracle SQL, Jira, Scrum...
Informatica PowerCenter, ServiceNow, SQL, Oracle SQL, JSON, CSV...
Informatica PowerCenter, SQL, PL/SQL, Oracle SQL, PL/SQL Tuning...




Preferred Environment

Databricks, Informatica PowerCenter, Databases, SQL, Analytics, Business Intelligence (BI), Data Engineering, Data Lakes

The most amazing...

...promotion I've had is to tech lead on a ten-element team, building analytics over IT Sources like ServiceNow, Jira, SAP SuccessFactors, and other data sources.

Work Experience

Tech Lead

2017 - 2022
DXC Technology
  • Developed Databricks notebooks over thousands of tables between IT JSON data sources, including ServiceNow, Jira, IBM Tivoli Composite Application Manager (ITCAM), Kiuwan, and SonarQube, into Azure Data Lake Storage Gen2.
  • Established hundreds of processes in PowerCenter to extract data from ServiceNow (web services consumer transformation), Jira (Open Database Connectivity (ODBC)), and ITCAM (ODBC) to an Oracle database on-premise.
  • Used the data stack with Microsoft Azure cloud services with Databricks, Data Factory, Azure Synapse, Azure Key Vault, and CI/CD with Azure DevOps.
  • Identified new business data as the IT product grew by creating a new instance for corporate data with corporate data from SAP SuccessFactors tables on Azure Delta Lake.
  • Managed a team of ten data engineers as a tech lead, emphasizing security compliance, code quality, and promoting and maintaining best practices. Handled welcoming and giving formation to new elements.
  • Worked with Agile and Scrum using Jira and Xray. Used ServiceNow's workflow to create service and change requests, including incident management.
  • Integrated and maintained minimum-value projects developed by external contractors on Azure Databricks and Data Factory.
  • Analyzed requirements and designed technical solutions with source integration and target database models to answer and deliver business needs.
Technologies: Databases, SQL, Databricks, Informatica PowerCenter, Oracle SQL, Jira, Scrum, PySpark, Analytics, Business Intelligence (BI), ServiceNow, Azure Data Lake, Azure Databricks, Azure SQL Databases, Azure Synapse, PostgreSQL, JSON, CSV, Microsoft Excel, ETL, Synapse, Microsoft SQL Server, SQL DML, SQL Performance, Data Queries, T-SQL (Transact-SQL), Performance Tuning, Linux, APIs, Data Warehousing, Leadership, Data Management, Data Pipelines, Data Engineering, Data Processing, Azure, Oracle SQL Developer, PySQL, SQL DDL, Excel 2016, Unix, Data Lakes, Informatica ETL

Data Engineer

2016 - 2017
  • Developed incident resolution and corrective and evolutive application maintenance for energy and utility products with Informatica PowerCenter and SQL Developer, which also involved using ServiceNow to manage tasks.
  • Extracted data in a voice-of-the-customer (VoC) project from different SAP sources and crossed them into a small Oracle database model with four tables to give an analytic overview of customer satisfaction.
  • Monitored and enhanced performances on ETL processes with Informatica PowerCenter and SQL and PL/SQL with SQL Developer.
  • Performed ETL developments as a developer in an ongoing marketing analytics project with PowerCenter over source files (CSV or XLS) and Oracle sources, resulting in a target database to overview marketing data.
Technologies: Informatica PowerCenter, ServiceNow, SQL, Oracle SQL, JSON, CSV, Microsoft Excel, ETL, SQL DML, Data Queries, Data Warehousing, Data Management, Data Engineering, Data Processing, Oracle SQL Developer, PySQL, SQL DDL, Excel 2016, Informatica ETL

ETL Developer

2009 - 2016
  • Performed technical and functional analysis and design and implementation of ETL processes and database structures for data integration and analytics over a customized Oracle E-Business Suite environment that served over 20 water supply companies.
  • Facilitated application management resolving incidents and service requests of different business areas such as contracts, invoicing, debt, billing, and reads.
  • Conducted performance analysis of daily ETL processes, Oracle Database tables and indexes, and SQL tuning on reporting queries as key methods to provide detailed and aggregated information on time.
  • Developed and maintained PL/SQL functions and procedures to framework and control process execution.
Technologies: Informatica PowerCenter, SQL, PL/SQL, Oracle SQL, PL/SQL Tuning, PL/SQL Developer, Databases, Analytics, Business Intelligence (BI), Database Administration (DBA), CSV, Microsoft Excel, ETL, Microsoft SQL Server, SQL DML, SQL Performance, Data Queries, Performance Tuning, Data Warehousing, Data Management, Data Engineering, Data Processing, Oracle SQL Developer, PySQL, SQL DDL, Excel 2016, Unix, Informatica ETL

BI over Oracle EBS Customization for Water Utilities

An Oracle E-Business Suite (EBS) data integration into an Oracle database that would serve for reporting different types of data, from invoicing and billing to contracts that read for several water companies in Portugal. I've worked on this project for four years, where I grew my database design thinking, ETL, and SQL skills. I started as a developer and evolved into a team leader in a five-element team.

Data Analytics over IT and Corporate Data

A project that prioritized analytics over IT-services data, such as ServiceNow and Jira. I started as an ETL Informatica PowerCenter developer in a two-element team in 2016, then became a tech lead of a ten-element team developing in cloud Azure with Databricks, Data Factory, and PowerBI. This product was refactored in 2020 from an on-premises environment to the cloud with Microsoft Azure. In the six years of this project, agile scrum methodology was used.
2006 - 2010

Engineer's Degree in Computer Engineering

Iscte - University Institute of Lisbon - Lisbon, Portugal


Microsoft Certified: Azure Data Engineer Associate





Informatica PowerCenter, Jira, Excel 2016, Informatica ETL, Oracle Warehouse Builder (OWB), Microsoft Excel, Synapse


SQL, T-SQL (Transact-SQL), SQL DDL, SQL DML, Java, Python


Scrum, Business Intelligence (BI), ETL


Databricks, Azure, Azure Synapse, Unix, Linux


Databases, Oracle SQL, SQL Performance, Azure SQL Databases, PL/SQL, PL/SQL Developer, PostgreSQL, JSON, Oracle SQL Developer, Microsoft SQL Server, Data Lakes, Data Pipelines, Database Administration (DBA)


Development, Programming, Azure Data Lake, Azure Databricks, Data Processing, Data Engineering, Azure Data Factory, ServiceNow, Analytics, CSV, Data Queries, PL/SQL Tuning, PySQL, Performance Tuning, Data Warehousing, Data Management, Physics, Electrodynamics, APIs, Leadership

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.


Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring