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