IT Systems Analyst Senior
ON Semiconductor Slovakia, a.s.
- Place of work: Vrbovská cesta, Piešťany, Slovakia (Job with occasional home office)
- Basic wage component (gross) and other rewards: From 2 000 EUR/monthDepends on candidate´s experience.
- Contract type: full-time
Job description, responsibilities and duties
onsemi is building a new IT team to support and develop a data warehouse solution for its modern, US based factory (new acquisition). Existing solution is going to be migrated to OCI (Oracle Cloud Infrastructure), adapted to support existing onsemi systems and further improved and maintained.
The person in this role will be responsible for the design, implementation, optimization and support of enhancements and deficiency corrections, as well as the coordination of new releases. Responsibilities will also include activities to streamline and further standardize the architecture in the data warehouse space and provide technical consulting to projects with data warehouse related scope. A thorough understanding of Data Warehousing and Software Development Lifecycle concepts, strong communication skills and a process-oriented mindset are required in addition to very good technical and documentation skills.
Main responsibilities:
• Analyze and document existing data warehouse solution. Work with current system owner (external, US based) on daily basis. Some travel to USA might be needed.
• Implement changes to transition the data warehouse solution to the new OCI instance
• Define architecture and design approaches to address customer requirements
• Maintain the DB (both OCI and local Oracle)
• Write SQL, PL/SQL, DB performance tuning
• Develop ETL (Ab Initio, Perl, Pro*C, Java, Bash)
• Setup and maintain the Oracle GoldenGate
• Setup and maintain the MQ
The person in this role will be responsible for the design, implementation, optimization and support of enhancements and deficiency corrections, as well as the coordination of new releases. Responsibilities will also include activities to streamline and further standardize the architecture in the data warehouse space and provide technical consulting to projects with data warehouse related scope. A thorough understanding of Data Warehousing and Software Development Lifecycle concepts, strong communication skills and a process-oriented mindset are required in addition to very good technical and documentation skills.
Main responsibilities:
• Analyze and document existing data warehouse solution. Work with current system owner (external, US based) on daily basis. Some travel to USA might be needed.
• Implement changes to transition the data warehouse solution to the new OCI instance
• Define architecture and design approaches to address customer requirements
• Maintain the DB (both OCI and local Oracle)
• Write SQL, PL/SQL, DB performance tuning
• Develop ETL (Ab Initio, Perl, Pro*C, Java, Bash)
• Setup and maintain the Oracle GoldenGate
• Setup and maintain the MQ
Employee perks, benefits
• Hybrid mode (home office, Piešťany or Bratislava)
• Flexible working hours, Home office
• Annual bonus – 50% from monthly basic salary
• Annual corporate bonus based on the company's results
• Professional training and career opportunities
• Teambuilding and company’s events
• Relocation bonus and travel allowance
• Extra days off – Bridge days
• Volunteering day off
• Sick days and Sick leave contributions
• Company Contribution to Pension System
• Regular salary review
• Working in a dynamic, newly formed team in a challenging international environment
• Multisport card
• Canteen services or meal voucher in Piešťany 5.00 € (Employee pays 1.15€), meal vouchers in Bratislava 6.10 € (Employee pays 1.40€)
• Flexible working hours, Home office
• Annual bonus – 50% from monthly basic salary
• Annual corporate bonus based on the company's results
• Professional training and career opportunities
• Teambuilding and company’s events
• Relocation bonus and travel allowance
• Extra days off – Bridge days
• Volunteering day off
• Sick days and Sick leave contributions
• Company Contribution to Pension System
• Regular salary review
• Working in a dynamic, newly formed team in a challenging international environment
• Multisport card
• Canteen services or meal voucher in Piešťany 5.00 € (Employee pays 1.15€), meal vouchers in Bratislava 6.10 € (Employee pays 1.40€)
Information about the selection process
If you are interested in this position and fulfill all our requirements, send us your motivation letter and your CV in English language by e-mail. Thanks to all applicants, but we will answer only to selected applicants.
Zaslaním Vášho životopisu dávate súčasne súhlas so spracovaním, správou a archiváciou Vašich osobných údajov uvedených v životopise, v zmysle zákona č;. 428/2002 Z.z. O ochrane osobných údajov v znení neskorších predpisov a to pre účely evidencie uchádzačov a pre účely ďalšieho spracovania.
Zaslaním Vášho životopisu dávate súčasne súhlas so spracovaním, správou a archiváciou Vašich osobných údajov uvedených v životopise, v zmysle zákona č;. 428/2002 Z.z. O ochrane osobných údajov v znení neskorších predpisov a to pre účely evidencie uchádzačov a pre účely ďalšieho spracovania.
Requirements for the employee
Candidates with education suit the position
University education (Bachelor's degree)
University education (Master's degree)
University education (Master's degree)
Language skills
English - Upper intermediate (B2)
Other knowledge
SQL - Advanced
Linux - Expert
Programming - Expert
Linux - Expert
Programming - Expert
Personality requirements and skills
• BSc/MSc Degree in information technology, computer science or related fields
• 5+ years of experience
• Proven knowledge of databases technologies, DB modelling and SQL development
• Proven experience with large, complex database projects in environments producing high-volume data
• Proficiency in programing (any language)
• Proficiency in Linux use and scripting
• Experience with cloud technologies, Data Warehouse and ETL would be welcomed
• Team player, ability to work in a multinational environment
• Fluent in English
• 5+ years of experience
• Proven knowledge of databases technologies, DB modelling and SQL development
• Proven experience with large, complex database projects in environments producing high-volume data
• Proficiency in programing (any language)
• Proficiency in Linux use and scripting
• Experience with cloud technologies, Data Warehouse and ETL would be welcomed
• Team player, ability to work in a multinational environment
• Fluent in English
Advertiser
Brief description of the company
onsemi is a leading provider of power efficient semiconductor solutions to customers in the power supply, automotive, communications, computer, consumer, medical, wireless, mobile phone, industrial and aerospace markets.
While the company’s corporate headquarters are located in Phoenix, Arizona, U.S., it operates a worldwide network of manufacturing facilities, sales offices and design centers in key markets throughout North America, the Asia Pacific regions, the Middle East and Europe.
onsemi promotes a mutually rewarding partnership that creates a customer-oriented organization, encourages innovation and teamwork, and rewards achievement. If you are looking for challenges, quality, freedom and empowerment join us today.
While the company’s corporate headquarters are located in Phoenix, Arizona, U.S., it operates a worldwide network of manufacturing facilities, sales offices and design centers in key markets throughout North America, the Asia Pacific regions, the Middle East and Europe.
onsemi promotes a mutually rewarding partnership that creates a customer-oriented organization, encourages innovation and teamwork, and rewards achievement. If you are looking for challenges, quality, freedom and empowerment join us today.
Number of employees
250-499 employees