Our goal is to solve problems and deliver results for our clients. At Cloud and Things, you can be a part of transforming the public sector’s IT environment. Our team is on the forefront of helping to solve the government's most complex IT challenges. If you are seeking a role that offers the opportunity to work on rewarding projects, consider a career with Cloud and Things. Overview
We are seeking a ETL Developer – Transactional Database for a large-scale modernization project. The Worker’s Compensation Board (WCB) is going through a large-scale modernization of many of its core application systems. These applications and data are being consolidated and will be hosted as one application system in the Microsoft Azure cloud. The modernization effort (OnBoard) and the associated software delivery will occur incrementally. The OnBoard program roadmap will consist of multiple, discrete projects leading to the final, to-be WCB enterprise-wide software solution hosted in Azure, resulting in the sunsetting of all legacy systems.
Responsibilities
- Reviewing and analyzing existing systems, data and business requirements; Meeting with business units and SMEs to refine and clarify requirements.
- Profile existing and migrated data.
- Develop ETL workflow, procedures, translating business rules and functional requirements into ETL procedures.
- Develop data migration audit, verification and fallout reports.
- Performance tuning ETL processes
- Documenting migration processes
- Responsible for designing, testing, deploying, and documenting the data quality procedures and their outputs.
- DQ Developer provides relevant outputs and results from the data quality procedures, including any ongoing procedures that will run after project end.
- Perform data load and mappings from source systems as the scope of quality information increase across the enterprise.
- Partners with business data stewards to provide summary results of data quality analysis, which will be used to make decisions regarding how to measure business rules and quality of the data.
- Provide Data Quality Scorecards, Dashboards and Ad-Hoc reporting.
- Providing recommendations for modification or creation of business rules based on data results.
- Support data cleansing activities.
Mandatory Skills/ Qualifications
- Must have between four (4) and seven (7) years of experience as a Developer.
- Proven experience reviewing and analyzing existing systems, data, and business requirements.
- Experience meeting with business units and SMEs to refine and clarify requirements.
- Hands-on experience profiling existing and migrated data.
- Experience developing ETL workflows and procedures, translating business rules and functional requirements into ETL procedures.
- Experience developing data migration audit, verification, and fallout reports.
Desirable Skills/ Qualifications
- Experience with Sybase DBMS, SQLServer MI, T-SQL/ Stored Procedures, Informatica.
Cloud and Things complies with all applicable federal, state, and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other category protected by applicable federal, state, or local laws. Cloud and Things complies with all applicable federal, state, and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other category protected by applicable federal, state, or local laws.