ETL Software Engineer

Now hiring an ETL Developer for work in the Boston, MA area! Trillium Technical, a leader in the staffing industry is currently seeking an ETL Developer! The ETL Developer (ETL Analyst) shall work closely with the IT Leadership and will be responsible for the proper maintenance, documentation, support and enhancements to the current application environments. The Analyst will be required to develop technical specifications and detailed work plans, ensuring both system and data quality. Data quality management efforts may include: data cleansing, deduplication, error reporting and debugging using the standard ETL tool set. The Analyst shall provide consultation services to clients, technicians and possible other departments. The ETL Data Analyst is responsible for ensuring high availability of all related business applications through the strict adherence to all processes, ensuring proper Confidentiality of data, Security, Quality Assurance, Change Management, Organizational Management and Release Management practices. This position reports directly to Applications Manager and the Bureaus designated IT Program Manager. Req#: ITS63_DataAnal_EHS_FY18_008– DPH If you’re interested in this opportunity, please apply today! • 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 file and file transmission protocols (SFTP, Web Services, XML, Flat File) • Strong knowledge of networking protocols and ODBC, JDBC connectivity as it relates to user based connectivity • Knowledge of Applications Security including Authentication and Role Based Access Control within the DB • Strong Data Modeling and Database Design experience • Strong adherence to source control, version management, or Configuration management practices • Ability to communicate effectively both verbally and in writing (Clearly and Succinctly) • Experienced in providing ongoing maintenance and support of IT systems and User communities • Capable of working independently or as part of a large team. • Experience in maintaining the confidentiality of sensitive information. • SQL Development – ability to write, review and troubleshoot SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints) • T-SQL, sqlcmd, bcp, sqldiag, tablediff and other programing and diagnostics – Expert level knowledge/experience • Understanding of Data encryption, TDE, and key management – Intermediate level knowledge/experience • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc. • Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools. • Strong knowledge of Database server administration and in virtual environments. • Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively. • 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. • 4-8 years of experience developing PL/SQL code and install/implement on production environments. • 5+ years of experience in database administration, SQL tuning, expdp/impdp, SQL loader, Erwin/Data modeler, OEM and ADDM/AWR generation. • 3+ years of experience in database parameter tuning, data guard and golden gate. • 3+ years of experience in working on UNIX database servers.