ALTEN Romania, a subsidiary of ALTEN Group – with a unique position as a European Leader in IT & Engineering Consulting, was established in 2006 in Bucharest, with the aim to provide technical consulting for the customers of this specific market. Since its inception, the company grew and now has offices in Bucharest, Timisoara, Sibiu and Cluj-Napoca.
Through its team of over 300 specialists in software development, business analysis, business intelligence, PMO, Project Management, testing, technical support, automotive and aerospace engineering, ALTEN Romania is providing specialized services, both on the local and international markets in business sectors such as: aerospace, automotive, finances, pharmaceutics and telecom.
ALTEN Romania has a technical team of consultants and experts in engineering specialized in CATIA V5, NewPDM, SolidWorks, Matlab/Simulink, HIL, Autosar and others, while the IT Division has precise specializations like: Java, .NET, PHP, C#, C++, SIEBEL, Informatica PowerCenter, Cognos, MS BI and Oracle BI, BSCS and more.
Good knowledge of relational database systems. Experience on working with Teradata databases represents an advantage.
Good knowledge of SQL. Teradata specific stored procedures language and BTEQ (Basic Teradata Query) represent an advantage.
Good knowledge of ETL Tools. Experience on working with IBM InfoSphere DataStage represents an advantage.
Business Analysis/System Analysis experience. Knowledge of modelling languages represents an advantage.
Analyze business requirements and create the functional specifications.
Map business terms from the source systems to the DWH core data model.
Develop ETL scripts and jobs – extract data from the Teradata DWH core data model, calculate measures and KPIs, load them into data marts.
Design and implement new tables and relationships in the data marts.