Hyundai Capital America is looking to solve the problem of designing and developing data pipelines and information assets to ensure alignment with reference architecture, data requirements, and time frames for iterative delivery of data pipeline artifacts.
Requirements
- Proven experience with Data Integration tools such as Informatica, AWS Glue, AWS Redshift, AWS S3, and languages such as Stored Procedures, Python, Spark, etc.
- SQL and Oracle knowledge required.
- Experience in building and optimizing relational and structured data pipelines, architectures and data sets.
- Strong analytic skills to work with unstructured datasets.
- Has in-depth functional expertise and broad business knowledge of data domains.
- Ability to find solutions on data requirements and issues.
- Ability to conduct code reviews to ensure that the technical output conforms to best practices and standards.
Responsibilities
- Create and maintain optimal data pipeline architecture.
- Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS big-data technologies.
- Build data pipelines, ELT optimization, data mappings, and ETL progress design to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.
- Implement improvements to application performance for potential bottlenecks.
- Update process documentation to keep system library up to date.
- Validate system developed according to requirement by testing.
- Follow processes and practices to enable the delivery of data engineering artifacts.
Other
- Minimum 5-7 years’ progressive experience in data analytics, computer systems engineering, or software engineering.
- Bachelor’s degree required.
- Advanced degree preferred.
- Ability to communicate and influence Business and IT in terms of understanding the data requirements, respective data solutions, and technical decisions.
- Strong collaboration and motivation skills.
