Solange Souza's Location
Brazil, Brazil
About Solange Souza
A Specialist in Data Engineering professional, holding over 12 years of professional experience. Being adaptable and open to change allows me to quickly respond to evolving requirements and technologies. Can proactively identify opportunities for improvement and drive innovation. Taking ownership of data pipelines, quality, and reliability ensure that critical processes run smoothly, meeting deadlines and deliver high-quality results. ✔ ETL and Data Migration: Solid experience in ETL, data manipulation, and migration.✔ Data Cleansing and Sanitization: Proficient in handling, sanitizing, and anonymizing data.✔ Data warehouse and Datamart: Extensive knowledge in these areas.✔ ETL Tools: Proficiency in DataStage, PowerCenter, Integration Service, Glue, and ADF.✔ Programming Languages: Over 11 years of experience with SQL, knowledge about Python, and PySpark.✔ Interest in Cloud and Continuous Learning: Currently expanding my knowledge in cloud infrastructure and programming languages.✔ Responsible for implementing several successful case studies Data Warehouse projects at the Ministry of Health, and to mention of the most important projects, the SISAGUA project which was an urgent case due to the tragedy that occurred in Mariana, MG. They needed data on the quality of water supplied in the region. I travelled to seminars and met with various teams to gather information about their needs. I developed 6 out of 12 scopes with extremely important reports for decision-making.✔ As an architect at BANCORBRAS, I also created a hybrid Data Warehouse (on-premises / cloud) to obtain information and unify clients into a single database. The data was cleansed and encrypted, ensuring quality and security. We established a master database with the most up-to-date client data, making it easier to analyse the customer’s lifetime value. Campaigns were created based on this project, and the company’s profits increased significantly.✔ Good didactics for teaching. I usually trained interns and trainees. I put in a lot of effort to meet deadlines and have always received praise for it. ✔ I spare no effort to solve problems and deliver requests. I am very communicative and seek to gather as much information as possible from the client or data owner. I like to validate each step to avoid the risk of rework, making delivery planning easier.Open to network 🚀Contact number: +44 07568083706Email: solleles@hotmail.com
Solange Souza's Current Company Details
Senior Data Engineer | Big Data Specialist | Business Inteligence Specialist
Solange Souza Work Experience Details
-
Senior Data EngineerBanco Votorantim S.A. Sep 2022 - Mar 2024São Paulo, São Paulo, Brazil• Designed and created data pipelines within the Databricks environment, extracted, transformed, and manipulated data using Python, Pyspark, and SQL.• Provided support for Azure Data Factory (ADF) pipelines and ensured smooth execution and maintenance of ADF workflows.• Managed data manipulation tasks using Azure Synapse, performed data transformations and optimizations to enhance data quality and accessibility.• Monitored the health and performance of the Databricks environment, kept track of resource utilization, job execution, and system stability.• Led data migration initiatives using AWS Glue, migrated data from various sources to a unified storage solution to streamline data access and improved data governance.• Managed data storage and retrieval processes in Amazon S3 and stored data securely and retrieved it efficiently when needed.• Demonstrated proficiency in Bitbucket and GitHub and collaborated with team members, tracked changes, and managed code repositories.• Implemented continuous integration and continuous deployment (CI/CD) processes, automated build, test, and deployment workflows to accelerate software delivery and ensured code quality.• Evaluated and improved streaming table structures, refactored schema design and optimized data flow to enhance real-time data processing capabilities.
-
Data EngineerUol Pagseguro Nov 2021 - Sep 2023São Paulo, Brasil• Developed and maintained database procedures and scripts, wrote, optimized, and troubleshooted scripts in Oracle, SQL, and Redshift for efficient data processing and reliable database operations.• Assessed ETL (Extract, Transform, Load) strategies, evaluated different approaches for efficient data loading to inform decisions on the best loading methods.• Enhanced process automation created and improved PL/SQL scripts to streamline data workflows and reduce manual effort.• Automated workflows designed Directed Acyclic Graphs (DAGs) for task scheduling in Airflow for efficient and scheduled execution of processes.• Handled data pipelines, configured, and managed data processing workflows in Jenkins to smooth data flow and reliable execution.• Managed data storage in Amazon S3 cloud storage. • Managed code versions, Using Git for version control and collaboration to organize codebase and collaboration with other developers.• Developed data solutions, used Python and Jupyter Notebook for data analysis and modelling for valuable insights and data-driven decision-making.• Enhanced analytics processes developed Spark scripts for data analysis to improve data insights and performance.• Ensued ADF processes run smoothly by monitoring, troubleshooting, and maintaining ADF workflows for reliable data integration and transformation.• Ensured Databricks processes are optimized, analysed, and improved Databricks workflows for efficient data processing and analytics. -
Data EngineerQintess Nov 2020 - Dec 2021São Paulo, Brasil• Extracted data using Power Datastage, configured data extraction from DB2, MariaDB, and Hive databases to access to relevant data for further processing.• Assessed ETL (Extract, Transform, Load) strategies, evaluated different approaches for efficient data loading to inform decisions on the best loading methods.• Enhanced process automation created and improved PL/SQL scripts to streamline data workflows and reduce manual effort.• Understood SAP systems, reverse engineering SAP processes for integration with Datastage for a seamless data flow between SAP and Datastage.• Automated SQL and COBOL processes developed Datastage jobs for script execution for efficient data handling and execution.• Ensured ETL job functionality, fixed issues, built new ETL jobs in datastage for reliable data movement and transformation.• Created high-quality data jobs, designed, and implemented robust ETL processes for a consistent data quality and accuracy.• Adhered to LGPD (Brazil’s data protection law), developed jobs that handle data while maintaining privacy to keep compliance with data privacy regulations.• Automated workflows in Airflow, designed Directed Acyclic Graphs (DAGs) for task scheduling fpr am efficient and scheduled execution of procedures and queries.• Automated tasks using Jenkins, created Jenkins pipelines for package management to streamline deployment and execution.• Developed predictive models and data manipulation, utilized Python, Pyspark, and Spark for data analysis for valuable insights and data-driven decision-making. -
Senior Data EngineerEngesoftware Tecnologia S.A Nov 2019 - Oct 2020Brasília, Distrito Federal, Brasil• Extracted data using Power Datastage, configured data extraction from DB2 and Hive databases to access to relevant data for further processing.• Assessed ETL (Extract, Transform, Load) strategies, evaluated different approaches for efficient data loading to inform decisions on the best loading methods.• Enhanced process automation created and improved PL/SQL scripts to streamline data workflows and reduced manual effort.• Ensured ETL job functionality, fixed issues, built new ETL jobs in datastage for reliable data movement and transformation.• Created high-quality data jobs, designed and implemented robust ETL processes for a consistent data quality and accuracy.• Adhered to LGPD (Brazil’s data protection law), developed jobs that handle data while maintaining privacy for compliance with data privacy regulations. -
Data Architect Dw/Bi Big DataLogiks Consultoria E Serviços E Ti Mar 2019 - Oct 2019Brasília E Região, Brasil• Designed and managed data architecture in a hybrid environment using AWS, implemented data solutions, optimized performance, and ensured data availability for efficient data management and seamless integration between on-premises and cloud environments.• Handled data using various storage technologies, extracted, transformed, and loaded (ETL) data, ensured data quality for a clean, structured data ready for analysis and reporting.• Oversaw data loading processes, monitored data ingestion, identified bottlenecks, and ensured timely data updates for reliable and up-to-date data for business operations.• Created documentation for ETL processes, defined ETL strategy, documented specifications, and mapped data flows for a clear guideline for data integration and transformation.• Evaluated PL/SQL scripts, automated data processes, extracted business insights from scripts to streamline workflows and informed decision-making.• Ensured project continuity, developed a plan for handling disruptions, backups, and disaster recovery to minimize downtime and data loss during unexpected events.• Designed data models, created star schemas, snowflake schemas, and other dimensional models to optimize data retrieval for reporting and analytics.• Established database structures, designed tables, indexes, and relationships for a well-organized data storage and retrieval.• Improved data quality, cleaned, standardized, and enriched data for a high-quality data for accurate analysis and decision-making.Achievement: Led the technical team, guided team members, resolved technical challenges with an effective collaboration and successful project outcomes. -
Senior System AnalystB2T - Business To Technology 2014 - Oct 2018Brasília• Designed efficient data models for reporting and analysis, created multidimensional schemas for data marts and the overall data warehouse architecture to optimize data structures supporting analytical needs.• Understood business needs and translated them into technical requirements, collaborated with stakeholders to define project requirements. To clear project scope and well-defined objectives.• Automated ETL processes, analysed and developed PL/SQL scripts for data transformation to streamline data processing and reduced manual effort.• Created visual insights for decision-makers, built dashboards and reports using SAS and PowerBI for accessible data-driven insights.• Ensured smooth ETL operations, managed ETL workflows using PowerCenter and SSIS to obtain reliable data flow from source to destination.• Designed data models, create relational and multidimensional models to structure data for efficient querying.• Enhanced data quality-built processes for data enrichment to improve data accuracy.• Profiled data, generated profiles using Data Quality tools for insights into data characteristics.• Created a semantic layer for reporting, developed and mapped semantic objects in MicroStrategy to simplify reporting and analysis.• Populated a Data Lake, extracted data using PowerCenter to obtain data available for big data processing.• Defining ETL requirements, gathered requirements and planned ETL strategy for well-defined ETL processes.• Ensured ETL reliability, managed ETL workflows using PowerCenter for a consistent data movement.• Created visualizations, developed reports and dashboards using Microstrategy to offer accessible insights for end-users.• Shared expertise, transferred knowledge related to services rendered to improve team capabilities. -
Senior System Analyst Team LeadTgv Tecnologia Aug 2013 - May 2014Ministério Da Saúde• Ensured the smooth operation of existing ETL processes. Built, edited, and managed ETL maps and workflows within the PowerCenter to obtain reliable data extraction, transformation, and loading.• Designed data models for efficient querying and reporting, created relational and multidimensional data models to optimize data structures for analytical purposes.• Managed projects and ensured alignment with project goals, developed project artifacts (e.g., TAP, business rules document, stakeholder management, schedules, data dictionary, project plan) for well-organized project execution and documentation.• Enhanced data quality through enrichment, built processes to enrich data (e.g., data cleansing, standardization, matching) to improve data accuracy and completeness.• Automated ETL processes, wrote PL/SQL scripts for data transformation and automation, streamlined data processing, and reduced manual effort to improve data quality, applied data cleansing, standardization, and matched concepts. For high-quality data for reporting and analysis.• Analysed and reported on data quality indicators, created reports based on data quality metrics for insights into data accuracy and reliability. -
Etl AnalystCds Tecnologia Nov 2011 - Aug 2013Brasil• Ensured the smooth operation of existing ETL processes, identified, and fixed any issues, monitored ETL jobs, troubleshooted errors, and applied necessary fixes for a reliable data flow from source systems to the data warehouse.• Designed data models that support efficient querying and reporting, created multidimensional schemas (e.g., star schema, snowflake schema) for data marts and the data warehouse to optimize data structure for analytical purposes.• Understood business needs and translating them into technical requirements, collaborated with stakeholders to define data requirements, KPIs, and reporting needs to clear project scope and well-defined objectives.• Enhanced ETL processes through automation, wrote SQL scripts to transform, cleanse, and load data efficiently for a streamlined data processing and reduced manual effort.• Documented data elements, definitions, and relationships, created and maintained a data dictionary that describes data entities, attributes, and their meanings to Improve data governance and understanding of data semantics.
Solange Souza Education Details
-
Faculdade Sul Americana -FasamCiência De Dados - Big Data E Machine Learning -
UnidescTecnólogia Da Informação
Frequently Asked Questions about Solange Souza
What is Solange Souza's role at the current company?
Solange Souza's current role is Senior Data Engineer | Big Data Specialist | Business Inteligence Specialist.
What schools did Solange Souza attend?
Solange Souza attended Faculdade Sul Americana -Fasam, Unidesc.
Not the Solange Souza you were looking for?
-
1alpino.com.br -
-
Solange Souza
Customer Success | Estratégia De Cobrança | Experiência Do Cliente | Performance De Carteira | BackofficeGuarulhos, Sp1gmail.com -
1gmail.com
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial