SQL ETL Developer Job at Cayzen Technologies, Lacey, WA

cEprZFB5R0R6emZTdDVwR2pTcnFxeWwvblE9PQ==
  • Cayzen Technologies
  • Lacey, WA

Job Description

Cayzen Technologies immediately has a need for at least one SQL ETL Developer to complete work for one SaaS solution supporting Foster Care Parent Applications with a WA State government agency. This initial engagement is expected to last 12 months. Technical milestones for this work include prototyping the technical approach of using ETL to manipulate the legacy application data; developing ETL processes to perform bi-directional synchronization for data elements that exist in both repositories; integrating data that exists only in the interim database with the legacy data; testing related downstream processes across the legacy FamLink application that use this data to confirm no bugs were introduced by this work. The work to synchronize data for the SaaS solution. We anticipate the work during the remainder of the engagement involving stabilization and testing of any required changes as full integration of the SaaS solution is completed. Assigned work activities include the following duties and tasks:

  • Working with application developers and DevOps to ensure regular, controlled deployment of updates to existing database-driven applications across various platforms including but not limited to development, QA, and production environments - including cloud-based resources.
  • Performs design, development, quality assurance, verification, testing, performance profiling, optimization, migration and maintenance tasks for mission-critical database, business intelligence, API, data integrations, SSIS packages, ETL processes and reporting solutions.
  • Perform data translation, transformation, and data cleansing procedures.
  • Assist in the preparation of data migration plans including migration risks and project milestones.
  • Develop and maintain business metadata.
  • Define, capture, and maintain technical metadata.
  • Use established change management practices.
  • Resolve data quality issues, which may include cross-system dependencies.
  • Assist in determining enterprise data distribution and reporting requirements and priorities.
  • Perform quality assurance review, data migration audit, reconciliation and exception reporting.
  • Creates and maintains data models and data dictionaries.
  • Work collaboratively with subject matter experts and project team to define, organize, document, and communicate requirements.
Why work for Cayzen Technologies We have a great crew of incredible professionals from different walks of life performing at the highest level. Our staff is enjoyable to work with, and there is quite often a bunch of laughter in the office, not yelling or mean-spirited folks that don't want to be bothered. Those type of people won't be tolerated here. We only work with good-natured, kind-hearted people that strive for excellence. We have fun! If you are hired, you will soon learn about outings to painted plates, baseball games, running/biking clubs, Sci-Fri, potlucks and other fun things to enjoy as well! We want our employees to enjoy working here and get to know the people they work with. We believe that every single employee is incredibly important to our success as a company, and we understand that. Come work where you are genuinely appreciated. As a small agile company, we pride ourselves on providing not only exceptional technical solutions but a team-oriented, responsive & innovative approach toward sustainable solutions in solving today's development challenges. We recognize communication as a key factor in the success of any project. We recognize that our employees (The Team) are what makes us so successful in providing exceptional services and satisfied clients. As such we offer competitive compensation and full medical benefits package, educational opportunities, and fun in the office as well as out of the office. EEO Statement Cayzen Technologies is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, veteran status, disability, sexual orientation, gender identity, or any other protected status. Cayzen Technologies

Job Tags

Interim role, Immediate start, Gangs,

Similar Jobs

Yakima Valley Farm Workers Clinic

Expanded Function Dental Assistant Job at Yakima Valley Farm Workers Clinic

 ...Join our team as an Expanded Functions Dental Assistant at Lancaster Family Health Center in Salem, OR, with relocation assistance up to $5,000 and a $4,000 sign-on bonus. Enjoy upgraded pay ($25.51-$32.49/hour DOE) and generous benefits, including 100% employer-paid... 

Bestica

Travel Nurse RN - Labor and Delivery - $2,038 per week Job at Bestica

 ...Catching Experience About Bestica We are a trusted provider of solutions in Information Technology and Healthcare sectors to the DoD, Federal and Commercial markets. Our guiding principle and core values help us care for our people and the community; and build a... 

Thriveworks

LCSW Candidate Job at Thriveworks

 ...current DSM under a licensed supervisor. What We Need: Full-time availability (30 hours/week 25 client visits with 5 hours administrative...  ...period and then work a hybrid model (50% in office and 50% remote). Flexibility in your work schedule What We Give:... 

Take It Easy Group

Senior Executive Assistant (REMOTE) Job at Take It Easy Group

 ...Salary: $80K / Year and up *This is a remote position* Who Are We? Take It Easy...  ...world. We are more than just fractional assistants for hire; we are strategic thinkers who...  ...reservations, confirming appointments, personal travel, etc. Other ad hoc duties to keep... 

Market District

Experienced Butcher Job at Market District

Job Summary $1000 New Hire Bonus! Ask Human Resource Representative for details. "Together, we improve people's everyday lives and well-being." As a Giant Eagle Team Member, you will be part of a team that emphasizes building lifelong relationships with our customers...