Programmer Analyst IV - ADSD

Transfer | Location: Civic Center

contact information

Wai Hon Jung

job description

Responsible for supporting the Department's data integration and data warehousing programs. 

Duties include but not limited to analyze data in critical software systems such as Training Evaluation and Management Systems, Crime Analysis Mapping System, Deployment Planning System, Consolidated Crime Analysis Database, and Comprehensive Human Resource Information System, deep comprehending the data model in various databases such as Oracle, SQL Server, DB2, and Microsoft. Access either on-premises or in the Cloud, develop Extract-Transform-Load (ETL) processes using Microsoft SSIS and/or Informatica PowerCenter, migrate ETL processes from the legacy software tool to Informatica PowerCenter, automates the data collection processes by using Windows task scheduler or Control-M, monitor daily ETL jobs and resume failed processes to ensure timely data deliver.  Support Microsoft Dataverse, Common Data Service, Azure DAta Factory, and Data Lake. 

Provide training to other developers in the team as needed.

How to apply

Please email Departmental Application and last two ratings to