Data Engineer ETL

Project for : Mining Industry  and Banking Job Responsibility: Develops, tests, and integrates ETL routines (including those for geospatial data) using ETL tools and external programming/scripting languages as necessary. Automates GIS analysis tasks using Python, ModelBuilder, FME, T-SQL and/or SSIS. Creates and maintains the organization data dictionary as well as technical documentation for source-to-target mapping. Assists in production support by resolving source data issues and refining transformation rules to align with center objectives. Ensures accuracy and integrity of data through analysis of application coding deliverables, ensuring adequate documentation and problem resolution. Reviews and approves analysis and translation of functional specifications and change requests into technical specifications. Oversees project document management of ETL technical system specifications, processes flows, unit tests and results. Ensures staffs support of all ETL jobs for schedules and maintains compliance in development for effective project life cycle. Manages internal resources to ensure that individuals assigned to projects have the specific skills necessary to run established workflows. Assists in the design of data collection and analysis efforts with a focus on preventing redundancies, improving quality, and developing systems to support longitudinal data collection and analysis Requirement: 3 years of data management, engineering, or a related experiences Advanced Talend Advanced Pentaho Strong quantitative and geospatial data manipulation skills, cleansing data Advanced SQL coding skills for data transformations, profiling, and query tasks Develops, tests, and integrates ETL routines (including those for geospatial data) using ETL tools and external programming/scripting languages as necessary