back to careers

ETL Developer

Full time
Bucharest
Senior
  • Relocation package
  • Flexibile working hours
  • Performance bonuses
  • Attractive projects
  • Medical benefits
  • Trainings
  • competitive compensation package
  • Referral program
  • Job rotation
  • International work experience
Decommission legacy DWH developed on MS SQL 2012, migrate campaign data marts to the client's solution in IPC.

Project:

The migration will imply development of ETL to bring data to the new DataMart. The files will be moved to a local SFTP server from where they will be loaded using SSIS in Campaign
mart. The current DataMart is using MS SQL, new one will be am Oracle data base.

Job Responsibilities:

  • Understand and translate business needs into technology solutions
  • Build complete data Integration solutions working in an Agile environment to provide rapid solutions conforming to best practices and to the client’s ICT Development standards
  • Develop automated data flows, using Visual Studio (dtsx)
  • Create technical documentation
  • Perform code, design and test plan reviews for peers and develop system implementation schedules while working closely with operations/ infrastructure team
  • Perform System testing
  • Analyze and troubleshoot SQL statements, code and model database objects
  • Independently perform problem determination and resolution in the production environment and support production as needed
  • Actively propose improvements in implementation, standards and other work practices.

Requirements:

  • Minimum 2-3 years of experience in:
    • Developing, testing and implementation of ETL processes and reporting solutions using MS SQL Server tools
    • Project life cycle implementation specific to ETL o Full Project life cycle implementation specific to ETL
  • Performance tuning in MS SQL Server
  • Strong foundation of Data Warehouse concepts
  • Experience diagnosing problems and troubleshooting production issues
  • Strong analytic and problem-solving abilities
  • Strong foundation in System Development Lifecycle principles
  • Strong written and verbal communication skills
  • Ability to work independently and collaboratively.