Job Overview:
This role will support the ETL team with the development, implementation, and maintenance of data solutions such integrations, interfaces and ETL's for Data Warehousing and other systems. As part of the IT Data and Analytics team, the Intern will work with the team to design solutions and implement programs according to the requirements and timelines specified in each business project.
Responsibilites:
- Support the ETL team with the develop and maintain ETL pipelines in and out of databases using combination of ETL Talend, SQL Server, Python, Java, API's, Web Services with a focus on performance, reliability, durability, data quality, security, and SLA expectations.
- Analyzes, designs, documents, builds, tests, and implements integration technology solutions that meet the specifications of a project or service request.
- Perform data mappings and design of system ETL workflow solutions.
- Write SQL queries against MS SQL and databases.
- Provide production support for database issues such data load problems and transformation translation problems.
- Support and maintain existing ETL processes.
- Creating technical design documents, codes, and unit tests for deliverables.
- Document ETL and database warehouse processes, procedures, and flows.
- Work closely with business analysts to understand requirements and develop solutions.
- Working with Python and SQL scripting and writing PL/SQL packages, procedures, functions, and triggers for database projects.
Location Description
Remington is a dynamic, growing, independent hotel management company with over 40 years of experience in the hospitality business. Providing top quality service in the areas of property management and condominium hotel management, Remington's track record of success demonstrates a unique understanding of the hotel business in all phases of the economic cycle. Our culture across these disciplines is centered on achieving results. At Remington, we believe that our people are the ultimate source of our competitive advantage.
Requirements
- Data Management, Data Science or Similar ongoing master's or bachelor's degree is highly preferred.
- Experience with database, procedures and triggers is preferred.
- Oracle or Azure Databases is preferred.
- Talend Studio ETL and/or OIC integration is preferred.
- Programming languages: Oracle PL/SQL packages, MySQL, SQL, Python, Oracle APEX, HTML, PHP, JavaScript
- BI Tools: Power BI