ETL Developer

CIT   •  

Livingston, NJ

5 - 7 years

Posted 299 days ago

This job is no longer available.


CIT is seeking an ETL Developer. The ETL Developer is responsible for the use of cutting edge Microsoft technologies to shape our Web, Service, Sales and Marketing data.


Key duties of the position include: implementing technology improvements to our Data Warehouse environment, writing and executing Windows shell scripts; implementing and enhancing ETL programs using SSIS, SSAS and SSRS against our Microsoft SQL Server 2012 Data Warehouse, applying database skills including T-SQL, procedures, indexing and query tuning; contributing to technical architectural planning, data modeling, process flow documentation and the design and development of innovative solutions for the business; create data analytics dashboard using Tableau or QlickView; creating technical designs and mapping specifications; developing and testing extraction, transformation, and load (ETL) processes; defining and capturing metadata and rules associated with ETL processes; adapting ETL processes to accommodate changes in source systems and new business user requirements; working with both technical staff and business partners to translate requirements into technical implementations; performing unit and system test and validation tasks; estimating time to deliver and participating in an Agile team approach; maintaining technical and user documentation; providing on-call support of the Data Warehouse nightly and  monthly processing; and participating in both technology and business initiatives.


Bachelor’s degree in Computer Science or a related technical field, plus 5 years of experience working in IT supporting Data Warehouse environments.