AspenTech is looking to convert and develop customer data using ETL processes to generate high-fidelity customer distribution network models necessary for AspenTech software.
Requirements
- Familiarity with ETL tools and methodologies,
- Understanding of geospatial data concepts and principles,
- Proficiency in SQL and scripting languages (Python, Perl, etc.),
- Experience troubleshooting complex systems and software applications,
- Identify and analyze database queries associated with ETL workflows.
- Tune SQL queries and indexes to improve query execution times.
- Monitor and troubleshoot ETL performance issues.
Responsibilities
- Engage in a conversion and development of the customer data using ETL (Extract Transform Load) processes, to generate high-fidelity customer distribution network models necessary for AspenTech software.
- Responsible for generating and refining working DMS data models.
- Focus on understand existing customer data sources, their schema, and representation, and applying this knowledge in rapid model development.
- Extract data from various sources, including databases, web services, and APIs.
- Transform data by cleaning, formatting, and validating it.
- Develop and maintain data quality checks, execute systems and acceptance testing with customers.
- Document and improve ETL processes and procedures, document implementation processes and project deliverables.
Other
- Under the Subject Matter Expert supervision
- Highly engaged with our customers, participating in all project delivery activities.
- Strong communication skills, both verbally and written,
- Proven ability to organize and prioritize work within tight timelines,
- Willingness to travel (25% average).
