The junior analyst specializes in designing the processes and integration of these processes for extract, cleanse, transform, and load. Must have the ability to understand the overall requirements and integrate them into the design. This individual may have design skills in one particular area, such as designing the extract of data from the source system, or may be proficient in designing the load routine, or may have the skills to design all areas of data integration. In cases where a data integration tool is used, must be knowledgeable in these tools to match the design with the features the tool has to offer.
The junior analyst provides efficient design and construction of systems and subsystems to extract, condition, and load data from operational systems and other sources into a defined physical data model according to business and technical requirements. The job may also provide input to the database designer to optimize the data loading of the physical database.
This person is charged with all the design efforts that concern the extraction of data from the source systems and any data conditioning performed on the host. This is a very technical effort and is heavily involved in the project as soon as data mapping is complete and stays involved, but to a lesser degree, to the end of the project. This person could also be very useful in the planning phase of the project, contributing expertise to the evaluation of the best alternatives for data integration based on expected row counts, file sizes, and other source data parameters.
key areas of responsibility: