Senior Data Engineer - Data Integration & ETL

Eetdbuyersguide; San Antonio (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

Eetdbuyersguide is seeking a data integration engineer to develop and automate ETL/ELT processes across diverse datasets, including big data platforms and cloud services. You will build scalable pipelines, implement data quality checks, and support enterprise data Warehouse operations.

The role emphasizes Python development, Spark-based processing, and collaboration with multiple business units to deliver reliable data integrations and analytics capabilities.

Qualifications

• Experience in a data integration role.
• Experience using Apache Spark, Nifi and/or Kafka.
• Experience using Python.
• Experience integrating enterprise software using ETL modules.
• Knowledge of data architecture, structures and principles with the ability to critique data and system designs.
• Ability to design, create and/or modify data processes that meet key timelines while conforming to predefined specifications utilizing the Informatica and/or Mulesoft platform.
• Understanding of big data technologies and platforms (Hadoop, Spark, MapReduce, Hive, HBase, MongoDB).
• Ability to integrate data from Web services in XML, JSON, flat file format, SOAP.
• Knowledge of RAML 1.0 and MuleSoft solutions.

Responsibilities

• Design, Develop, and unit test new or existing ETL/Data Integration solutions to meet business requirements.
• Daily production support for Enterprise Data Warehouse including ETL/ELT jobs.
• Design and Develop data integration/engineering workflows on big data technologies and platforms (Hadoop, Spark, MapReduce, Hive, HBase, MongoDB, Druid)
• Develop data streams using Apache Spark, Nifi and/or Kafka. Strong Python development for data transfers and extractions (ELT or ETL)
• Develop workflows in the cloud environment using Cloud base architecture (Azure or AWS)
• Develop dataflows and processes for the Data Warehouse using SQL (Oracle, Postgres, HIVEQL, SparkSQL & Dataframes)
• Perform data analysis & model prototyping using Spark/Python/SQL and common data science tools & libraries (e.g. NumPy, Pandas, scikit-learn, TensorFlow)
• Develop Data integration workflows using Web services in XML, JSON, flat file format, SOAP
• Participate in troubleshooting and resolving data integration issues such as data quality.
• Deliver increased productivity and effectiveness through rapid delivery of high-quality applications.
• Provide work estimates and communicate status of assignments.
• Assist in QA efforts on tasks by providing input for test cases and supporting test case execution.
• Analyze transaction errors, troubleshoot issues in the software, develop bug-fixes, involved in performance tuning efforts.
• Makes some independent decisions and recommendations which affect the section, department and/or division.
• Participates and provides input to area budget. Works within financial objectives/budget set by management.
• Develops alternative solutions for decision-making which support organizational goals/objectives and budget constraints.
• Works with minimum supervision, conferring with superior on unusual matters. Incumbents have considerable freedom to decide on work priorities and procedures to be followed.
• Provide reporting and analytics functionality to monitor API usage and load (overall hits, completed transactions, number of data objects returned, amount of compute time and other internal resources consumed, volume of data transferred).
• Use results from API reporting/analytics to guide API Developer offering within an organization's overall continuous improvement process and for defining software Service-Level Agreements for APIs.
• Performs other duties as assigned.

Skills

Apache Spark

Nifi

Kafka

Python

ETL/ELT

SQL

RAML 1.0

MuleSoft

Informatica PowerCenter

Oracle/SQL

Tools

Hadoop

Hive

SparkSQL

Druid

Azure

AWS

Job description

Eetdbuyersguide is seeking a data integration engineer to develop and automate ETL/ELT processes across diverse datasets, including big data platforms and cloud services. You will build scalable pipelines, implement data quality checks, and support enterprise data Warehouse operations.

The role emphasizes Python development, Spark-based processing, and collaboration with multiple business units to deliver reliable data integrations and analytics capabilities.