UST, formerly known as UST Global, is a provider of digital technology and transformation, information technology, and services, headquartered in Aliso Viejo, California, United States. Stephen Ross founded UST in 1998 in Laguna Hills. The company has offices in the Americas, EMEA, APAC, and India.
• In-depth, hands-on experience with data warehouse ETL tools and technologies such as Informatica, Snowflake/Oracle, Control-M that will be leveraged to support our ETL platform for SIE FMA.
• ETL: Informatica/DataStage/Talend…
• Database: Snowflake/Oracle/MySQL/Teradata…
• Scheduler: Control-M/Apache Airflow/Autosys…
• Scripting Language: Python/Java/Shell/Golang…
• Work with developers and architects to advise on standards and best practices.
• Good understanding of Database architectures and data models.
• Creating and maintaining technical documentation.
• Actively work with onshore team.
• Exposure of working in Agile model.
• Participate in weekdays & weekend on-call Support rotation and off-hours maintenance windows.
• Ready to work in 2 shifts on rotational basis (Morning and afternoon).
• Work with developers and architects to advise on standards and best practices.
• Good understanding of Database architectures and data models.
• Creating and maintaining technical documentation.
• Actively work with onshore team.
• Exposure of working in Agile model.
• Participate in weekdays & weekend on-call Support rotation and off-hours maintenance windows.
• Ready to work in 2 shifts on rotational basis (Morning and afternoon).
• Very good knowledge on ETL Architecture and development (Informatica preferred). • Very good knowledge on Data warehouse Concepts and Architecture. • Very Good Knowledge on SQL concepts (Oracle, MySQL…). • Knowledge on Snowflake database • Good exposure on Enterprise Schedule (like Control-M) • Should have exposure to Extensive Operations Support on the above-mentioned applications. • Should be ready to work in shifts • Programming & Development Skills: • Strong scripting skills (Unix, python etc...) • Coordinate with the Systems Engineering team to plan and execute system upgrades of existing warehouse application tools. • Maintain the software development disciplines including version control using Git repository • AWS cloud knowledge. • Good understanding of AWS data services such as Lambda, EMT, Athena, Glue, Redshift • Preparing Dashboards and metrics collection using tools such as Grafana, Datadog • Automation of monitoring frameworks for key business jobs