Adastra Bulgaria EOODData Engineer
May. 2016 - Aug. 2018Sofia, BulgariaInformatica:
Analyze Database Models and Requirementss;
Design and development of analytic data sets;
Data extract, transform, and load (ETL) from relational databases;
Implementation of Informatica processes to deliver data into Data mart and maintenance and tuning of ETL processes;
Getting involved in requirement gathering, analysis, and design and development process.
Create mappings, sessions & workflows using ETL tool Informatica Power Center to transform data from multiple sources including flat files, Teradata, DB2, Oracle and relational sources;
Represent the ETL group in technical discussions and evaluations;
Root Cause analysis for ETL job failures/Data issues raised by business;
Provide day-to-day support for operational data needs;
Oversees offshore development team to oversee requirements and development efforts; Teradata:
Develop SQL scripts using Teradata utilities such as BTEQ, MLOAD, FASTLOAD, FAST EXPORT, TPT etc. Design and build data structures and processes to populate data warehouse tables using knowledge of relational and dimensional data modeling techniques, Integration with legacy data and applications, Experience in UNIX systems, writing Shell Scripts that control Job Execution;, Develop and test new ETL processes, Code clean-up, optimization, and versioning, Create Stored Procedures and optimization scripts; Tools of the trade:
Informatica PowerCenter tools (workflow manager, workflow monitor, designer, repository manager, admin web);
Programming languages (SQL, ksh);
Data platforms (Oracle, Teradata, DB2);
Teradata;
Unix.