Published date Posted on Indeed on Jun 21, 2022 (13 d ago)
Tetra Tech AMT is looking for a Sr. ETL Developer to support ETL and Data Migration

This is for a ground-up, software development program for the Federal government. This person will report to the Data Team Manager and will work with developers, testers and analysts working in an agile environment.

Primary job duties and responsibilities may include, but are not limited to the following:
  • Perform source system analysis, profiling, data mappings, develop ETL and flows, and if needed, data modelling as needed for data migration
  • Develop ETL scripts using best practices to migrate data from legacy systems to the target system considering efficiency, performance, and compliance
  • Build ETL scripts (70 to 80% of the time) using SSIS and MS SQL Server, and other tasks (20 to 30% of the time)
  • Periodically walkthrough the data model and ETL processes with the application team and business stakeholders
  • Maintain in-depth and up-to-date knowledge of standards, guidelines, and industry trends for Data Migration and Architecture
  • Design, implement and maintain security during data migration for PHI/PII data.
  • Perform tests and evaluations regularly to ensure the design, data security, and integrity of the data is maintained.

The successful candidate will have:
  • BS degree in a computer discipline or equivalent technical degree (Math, Physics, Engineering, etc.)
  • 10+ years proven working experience as a Data Warehouse or Migration developer
  • Hands-on experience with implementing data migration standards
  • Must be able to integrate and create ETL scripts with MS SQL Server and Oracle databases
  • Working experience designing data models (Conceptual, Logical, and Physical)
  • Advanced data modeling concepts, RDBMS concepts, and data warehouse concepts.
  • Capable of understanding large-scale normalized (3NF) operation database model.
  • Extensive experience with data modeling tools (ER Studio or similar).
  • Excellent knowledge of security, integrity as it related to SQL
  • Familiarity with database design, documentation, and coding
  • Familiarity with programming languages API
  • Problem-solving skills and ability to think algorithmically

Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Error on reporting

Related jobs

Zimmer Biomet Zimmer Biomet |
4 d ago

As a member of the Connected Health software development team, the Senior Data Analyst is responsible for developing curated data models and reporting solutions for the mymobility/ZBEdge platform. This includes responsibility for analyzing, designing.

Technical Support EngineerDo you have a passion for solving complex, technical issues for customers? Are you customer and result-oriented and a good communicator? Do you have extensive knowledge of the hosting and data center landscape? Are you persuasive,.

Senior Project ManagerWe are a leading solutions provider of Microsoft ERP solutions for the Enterprise Construction market. SIS has immediate openings for Dynamics 365 FO Senior Project Managers. We currently have a significant pipeline of new business..

Job Description Summary:The Senior IT Project Manager will provide project management oversight of larger or more complex technology projects. This position will define, implement, and manage scope, schedule, and resources so that all project milestones.

Piper Companies Piper Companies |
2 d ago

Piper Companies is looking for a Technical Business Analyst for a leading mortgage insurance company for a 100% remote position.Responsibilities of the Technical BA Build out some identity management modules with data analytics group Collaborates with.

Boston Medical Center Boston Medical Center |
2 d ago

Under the direction of the Director of Business Intelligence, the Encounter Operations Analyst position is responsible for ensuring that Boston Medical Center Health System's Encounter Data is prepared and submitted in accordance with State and CMS contractual.

More jobs by this company

Sky Solutions Sky Solutions |
13 d ago

NextGen HealthSenior SSIS/SSRS DeveloperVisa – USC/GC/ EAD's /TN (No H1B, OPT ,CPT )Rate - $65 PH on C2C100% REMOTEJob Responsibilities:· Define, implement and maintain a common technology platform· Responsible for hands on development using SSIS, SSRS.

Sky Solutions Sky Solutions |
13 d ago

Only W2 (No H1B)Rate $40 PH on W2Open - USC/GC/GCEAD / Opt/cpt/H4 EADSkillset: Oracle, PL/SQL(AT&T) /IBM Experience: 6+ yearsJob Description:1. Experience in PL/SQL programming2. Golden gate replication, Data migration, Data replication, Data import.

Sky Solutions Sky Solutions |
13 d ago

Below is a Senior Java Developer role we have with Comcast.Visa – open (no h1b)Required Skills Set:Years of Experience: 7 – 10+Required: Bachelors Degree Java (Java 1.7/Java 1.8), Spring Framework, Jenkins, Gradle, and Github.Experience with RESTful.

Senior Python/AWS API DeveloperClient - CHSFully remoteNo H1BNotes from ManagerHe's looking for a Lead or Senior API Developer who is skilled with Python. We have a mid-level/senior resource on the team now, but he needs someone more skilled in Python.