MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

ETL Developer - local to Boston

Location Boston, United States
Posted 17-January-2019
Description

Job Title: ETL Developer

Loc: Boston, MA

Rate: DOE

Employment type: C2C or W2

MUST BE LOCAL to BOSTON, MA

Open for H1B Transfer OR TN Visa

The ETL Developer (ETL Analyst) shall work closely with the DPH IT Leadership and will be responsible for the proper maintenance, documentation, support, and enhancements to the current application environments. Strong verbal, analytical, and written communication skills are required.

The ETL Analyst will be responsible for gathering, analyzing, documenting and maintaining all data requirements related to the business applications, interfaces, and reporting environments. This documentation shall include all logical and physical data models, all required Gap analysis, all source to target specifications & all business logic or rules required to translate the business functional and technical requirements.

The Analyst shall be assigned to daily operations, as well as to ongoing projects, with a focus of meeting the business objectives of quality, on time, and on budget goals. The ETL Analyst shall expertly utilize standard Oracle & SQL Server tools and possibly other third party and data modeling tools to develop and implementing highly efficient, scalable, and automated ETL processes.

This position reports directly to Applications Manager and the Bureaus designated IT Program Manager.

Responsibilities:

Research, analyze, document, and maintain internal Applications and Database architectures

Assist with RICE (Reports, Integrations, Conversions, and Enhancements) through the use of current tools.

Develop work plans, schedules, and manage to target deadlines on short term and long term initiatives

Provide technical assistance and information to technical and non-technical users

Responsible for running monthly reports, managing data extracts/imports, and provide data quality verification

Continually look for opportunities to improve and automate current processes.

Ensure adherence and compliance to department policies, guidelines and objectives.

Collaborate across multiple teams including research, architecture, design, development and support teams..

Analyze, design, implement and maintain the businesses critical systems, maintaining at all times the proper data security standards set forth by the organization.

Provide tier-3 support, which may include problem definition, solution design, business continuity, backup and restore requirements resolve complex system issues and incidents escalated from lower support tiers.

Provide SQL development and coding (PLSQL,TSQL) for internal projects and teach/mentor other team members.

Experience with Oracle and SQL Server databases and their native utilities (Query Analyzer, Analytical Workbench, Etc.)

Advanced SQL query-writing skills, Linux/Unix scripting, and automated job scheduling

Experience in ETL Development using standard tools like SSIS, SSAS, or other ETL Solutions

Knowledge of Database native tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)

Working knowledge of other advanced ETL tools are preferred but not required (Informatica, Pentaho Data Integrator, DataStage, Oracle Data Integrator/Data Warehouse Builder, CloverETL, Talend etc.).

Working knowledge Database Error and Exception Handling.

Knowledge of J2EE/Web/Application server and troubleshooting application/server logs.

If anyone available please drop your resumes at kathy(at)dextroinc(dot)com or reach me 732-737-8354

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url