Neos Consulting
City :
Austin
State :
Texas
Neos is a leading Austin-based IT Staffing and Consulting firm, and was recognized as one of the Best Places to Work in Austin.
Neos are seeking a Mid-level (4-7 years) and Sr. Level (8+ years) Data ETL Engineer for a long term contract opportunity.
100% REMOTE
Project Overview:
Will work within D2I and the Data Modeling Group to support and deliver complex data models for use by campus. The Data ETL Engineer develops extract, transform, and load (ETL) procedures using Informatica for complex data models that reflect academic and administrative business processes at the University of Texas at Austin. The Data ETL Engineer plays a critical part in establishing a valuable cloud data warehouse that supports critical business decisions and data analysis processes for the campus community. The Data ETL Engineer leverages their creativity to solve complex data and business problems and builds effective relationships through open communication.
Requirements: • Minimum 4 years of experience designing and implementing ETL technical solutions for complex data models using multiple data sources • Minimum 3years of experience with Informatica Cloud, Python, SQL, and PL/SQL • Demonstrated expert judgment in selecting methods, techniques, and evaluation criteria for designing ETL solutions and optimizing ETL performance • Minimum 3 years of experience with Oracle and AWS PostgreSQL database environments including schema architecture • Strong communication and collaboration skills and good documentation habits. • Demonstrated experience with orchestration and automation of database processes. • Strong aptitude for troubleshooting and problem solving. • Team player, comfortable communicating cross-functionally and across management levels. • Self-motivated and able to organize work independently in a rapidly changing environment.
Development & Design (40%): • Develop ETL programs for complex dimensional data models within modern data platforms such as AWS Aurora Postgres, Snowflake, etc. • Interpret and devise data mapping documents • Design and automate ETL solutions for data cleansing, preparation, data validation and related processes
Adaptation & Maintenance (35%): • Adapt ETL programs to evolving data models and business needs • Adapt ETL programs in response to data quality assurance findings
Communication & Collaboration (25%): • Partner with key stakeholders including enterprise data architect, subject matter experts (SMEs), data modelers, and teammates • Guide complex technical projects, enabling effective communication and collaboration with project stakeholders
Preferred Experience and Skills • Graduate degree in computer Science or related field with five years of professional experience as an ETL Developer utilizing Informatica, IBM DataStage, SQL, PL/SQL, and Python. • Three years of experience working in a cloud-based data warehouse environment. • Experience with multiple types of databases. • Experience with high availability database implementations. • Basic networking knowledge as it relates to database systems. • Informatica and AWS certifications. • Strong knowledge of Quality Assurance processes, test case development and execution. • Knowledge of Agile software development methodologies (Kanban, Scrum). • Experience with issue tracking systems (JIRA).
Austin
State :
Texas
Neos is a leading Austin-based IT Staffing and Consulting firm, and was recognized as one of the Best Places to Work in Austin.
Neos are seeking a Mid-level (4-7 years) and Sr. Level (8+ years) Data ETL Engineer for a long term contract opportunity.
100% REMOTE
Project Overview:
Will work within D2I and the Data Modeling Group to support and deliver complex data models for use by campus. The Data ETL Engineer develops extract, transform, and load (ETL) procedures using Informatica for complex data models that reflect academic and administrative business processes at the University of Texas at Austin. The Data ETL Engineer plays a critical part in establishing a valuable cloud data warehouse that supports critical business decisions and data analysis processes for the campus community. The Data ETL Engineer leverages their creativity to solve complex data and business problems and builds effective relationships through open communication.
Requirements: • Minimum 4 years of experience designing and implementing ETL technical solutions for complex data models using multiple data sources • Minimum 3years of experience with Informatica Cloud, Python, SQL, and PL/SQL • Demonstrated expert judgment in selecting methods, techniques, and evaluation criteria for designing ETL solutions and optimizing ETL performance • Minimum 3 years of experience with Oracle and AWS PostgreSQL database environments including schema architecture • Strong communication and collaboration skills and good documentation habits. • Demonstrated experience with orchestration and automation of database processes. • Strong aptitude for troubleshooting and problem solving. • Team player, comfortable communicating cross-functionally and across management levels. • Self-motivated and able to organize work independently in a rapidly changing environment.
Development & Design (40%): • Develop ETL programs for complex dimensional data models within modern data platforms such as AWS Aurora Postgres, Snowflake, etc. • Interpret and devise data mapping documents • Design and automate ETL solutions for data cleansing, preparation, data validation and related processes
Adaptation & Maintenance (35%): • Adapt ETL programs to evolving data models and business needs • Adapt ETL programs in response to data quality assurance findings
Communication & Collaboration (25%): • Partner with key stakeholders including enterprise data architect, subject matter experts (SMEs), data modelers, and teammates • Guide complex technical projects, enabling effective communication and collaboration with project stakeholders
Preferred Experience and Skills • Graduate degree in computer Science or related field with five years of professional experience as an ETL Developer utilizing Informatica, IBM DataStage, SQL, PL/SQL, and Python. • Three years of experience working in a cloud-based data warehouse environment. • Experience with multiple types of databases. • Experience with high availability database implementations. • Basic networking knowledge as it relates to database systems. • Informatica and AWS certifications. • Strong knowledge of Quality Assurance processes, test case development and execution. • Knowledge of Agile software development methodologies (Kanban, Scrum). • Experience with issue tracking systems (JIRA).