ETL Developer

San Jose (Hybrid 3 days a week in office)

We are partnered with a company that provides consulting services specializing in statistical analysis and risk management who are looking for an ETL Developer to join their growing team.  

The ideal candidate will have a strong background in Extract, Transform, Load (ETL) processes and technologies, as well as expertise in designing and implementing interoperability solutions to facilitate data exchange between disparate systems and applications. The role will focus on ETL and Interoperability integration processes enabling seamless data exchange and integration across production systems.

Responsibilities:

ETL creation:

• Design, create, and maintain ETL processes to extract data from various sources, transform it into the required format, and load it into target systems or data warehouses.
• Create custom scripts, workflows, and data pipelines to automate data integration tasks.

Interoperability Solution Design & Development:

• Collaborate with stakeholders to understand integration requirements and design interoperability solutions that enable seamless communication and data exchange between disparate systems and applications.
• Define integration patterns, protocols, and standards to facilitate interoperability and information flow across systems.

Integration Implementation:

• Implement middleware, APIs, connectors, and integration layers to facilitate communication and data exchange between different systems, platforms, and data sources.
• Develop custom adapters, connectors, and plugins to integrate with third-party systems and applications.

Data Mapping and Transformation:

• Define data mappings, transformations, and business rules to ensure accurate and consistent data exchange between systems.
• Develop data transformation scripts, mappings, and rules using ETL tools, scripting languages, and transformation frameworks.

Performance Optimization:

• Optimize ETL processes and integration workflows for performance, scalability, and efficiency.
• Identify and address bottlenecks, optimize queries, and implement caching strategies to improve data processing speed and reduce latency.

Documentation and Reporting:

• Create and maintain comprehensive documentation of ETL processes, data mappings, integration workflows, and support procedures.
• Generate reports, documentation, and data lineage diagrams to facilitate knowledge sharing and troubleshooting.

Quality Assurance and Testing:

• Implement data quality checks, validation rules, and error handling mechanisms to ensure data accuracy, completeness, and integrity throughout the integration process.
• Conduct unit testing, integration testing, and user acceptance testing to validate ETL processes and integration workflows.

Qualifications:

• Bachelor's degree in computer science, information technology, or a related field.
• Strong technical skills in ETL tools and technologies, such as Informatica, Pentaho, MS SSIS, or custom scripting languages (e.g., Python, SQL).
• Experience with data modeling, database design, and SQL query optimization.
• Proven experience in interoperability with expertise in designing and implementing solutions for data exchange and integration between systems.
• Knowledge of integration patterns, protocols, and standards (e.g., REST, SOAP, JSON, XML).
• Strong analytical and problem-solving skills, with the ability to analyze complex data integration challenges and propose effective solutions.

This is a fantastic opportunity to join a growing team.  The company offers life & health insurance coverage, additional annual time off, and training sponsorship program. 

If this sounds like the ideal position for you apply today with an English version of your CV!