Job description

21Tech is looking for a Data Cleansing and Migration Analyst to support our Client in San Francisco, CA (Position is remote but may be asked to work on-site to support certain project activities). This is a great opportunity to be part of a successful, growing, entrepreneurial international business and a chance to work with many different applications and data networks.

Duration:

12 Months with possibility of extension

Location:

Position is mostly remote but may be asked to work on-site to support certain project activities.

Project Summary:

Our Client uses a central property assessment system, EZ Access, that has been in place for more than fifteen (15) years. EZ Access is a COBOL, DB2 database AS400 system that is maintained by the original developer. EZ Access is the system of record for the Client’s property and assessment information, interfacing with the property tax system of the Offices of the Controller and Treasurer & Tax Collector. Although EZ Access supports department operations, the system is past its useful life and is being replaced with a more modern system currently under development. The new system went live in summer 2020. The new Property Assessment System will interface with the new Property Tax Billing and Collection System.

Key Requirements:

• Analyze, design, build and execute the method of transforming existing data into a format for the new environment and the load of this data into other database structures.
• Use Talend to perform data profiling on a DB2 data base.
• Use Extract Transform Load (ETL) tool (such as Talend, SSIS) to perform data cleaning and data migration.
• Provide necessary change and support documentation.
• Report and provide status updates to the SMART Data Migration and Integration Track Lead.

About 21Tech:
21Tech services Public Sector agencies at State and Local levels across the USA and in Canada and Fortune 100 companies. We specialize in managing large-scale application implementations, project management, business processes and provide system integration services for Infor products such as EAM, CSF, WFM, d/EPM, Birst, etc. Our Clients and Partners include: Oracle, the City and County of San Francisco, the Judicial Council of California, the City of Oakland, the City of Santa Barbara, the City of San Diego, Infor, and Thompson Reuters. Outside California some of the Clients we work with are San Antonio Transit (VIA), Kansas City Transit, NY DOCCS, City of Chicago, the City of Indianapolis, Salt Lake City, New York/New Jersey Port Authority, Vancouver bus and Transit, NY MTA, Accenture, Deloitte and KPMG.

Job Type: Contract

Schedule:

• 8 hour shift

Work Location: One location

arclintfl.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, arclintfl.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, arclintfl.com is the ideal place to find your next job.