ETL Developer Data Vault Specialist

4 weeks ago

Washington, Washington, D.C., United States Sylger Corporation Full time

About the Role:

Sylger Corporation is seeking a highly skilled ETL Developer with expertise in Data Vault 2.0 methodology to join our team. As an ETL Developer, you will be responsible for designing and implementing ETL processes to extract, transform, and load data into our data warehouse.

Key Responsibilities:

  • Design and implement ETL processes using Data Vault 2.0 methodology
  • Develop procedural T-SQL, SQL Server Information Services (SSIS) jobs, or set-based SQL scripts to extract data from source systems and load it into the data warehouse
  • Write transformation expressions or functions, tests to ensure edge cases are handled correctly by the transformation, and documentation to explain how and why the transformation works
  • Monitor deployed ETL/ELT jobs and debug/troubleshoot any errors/issues encountered
  • Amend ETL/ELT scripts to correctly handle exceptional or aberrant records
  • Write tests to verify the integrity of relations/objects within the data warehouse

Requirements:

  • Experience with Data Vault 2.0 methodology
  • Proficiency in T-SQL, SQL Server Information Services (SSIS), and set-based SQL scripts
  • Ability to work collaboratively with data analysts and other end users to gather visualization and reporting needs and requirements
  • Familiarity with and adherence to basic design principles, including meaningful use of color
  • Experience working with a data warehouse and database systems like SQL Server and PostgreSQL
  • Experience with data blending or joins to integrate data from multiple data sources
  • Experience manipulating and visualizing a variety of common data types including numeric, string, date time, and geographic/geometric
  • Experience visualizing administrative records from multi-step business process to reflect derived dimensions of interest to process owners
  • Responsive and able to complete projects in a timely manner
  • Innovative while staying within imposed agency constraints
  • Flexible to work well in an environment where things may change frequently or stall for periods of time
  • Diligent about documentation and knowledge transfer, to include production of clean files
  • Host relevant training on dashboards
  • Complete dashboard testing and improvements

About Us:

Sylger Corporation is an equal opportunity employer and does not discriminate against any applicant or employee because of race, color, religion, sex, national origin, disability, age, or military or veteran status in accordance with federal law. In addition, Sylger Corporation complies with applicable state and local laws governing non-discrimination in employment in every jurisdiction in which it maintains facilities. Sylger Corporation also provides reasonable accommodation to qualified individuals with disabilities in accordance with applicable laws.

Job Types: Full-time, Temporary, Contract

  • Databricks ETL Developer

    4 weeks ago

    Washington, Washington, D.C., United States Expedite Technology Solutions LLC Full time

    Job Summary:Expedite Technology Solutions LLC is seeking a highly skilled Databricks ETL Developer to join our team. As a key player in our cloud migration project, you will be responsible for developing automated data pipelines from heterogeneous sources, including file and data validation, exception handling, and reporting. You will work closely with...

  • Senior ETL Developer

    4 weeks ago

    Washington, Washington, D.C., United States SynOpt LLC Full time

    Job Title: Senior ETL DeveloperJob Summary:We are seeking a highly skilled Senior ETL Developer to join our team at SynOpt LLC. As a Senior ETL Developer, you will be responsible for designing, implementing, and maintaining Extract Transform Load (ETL) solutions using SAP Data Services.Key Responsibilities:Design, document, and implement SAP Data Service...

  • Senior ETL Data Architect

    4 weeks ago

    Washington, Washington, D.C., United States Educology Solutions Full time

    Educology Solutions is seeking a highly skilled ETL Senior Professional Application Designer to join our team. This role will be responsible for designing and developing processes that translate data from various sources to destinations and present findings to appropriate team members, clients, and vendors.Key Responsibilities:Design and develop ETL...

  • ETL Informatica Developer

    4 weeks ago

    Washington, Washington, D.C., United States ViedTech Full time

    Job SummaryViedtech is seeking a highly skilled ETL Informatica Developer to join our team. As a key member of our data warehousing team, you will be responsible for designing, developing, and implementing end-to-end data warehousing solutions using Informatica.Key ResponsibilitiesDesign and develop ETL processes and architectures using Informatica Power...

  • Senior Informatica ETL Developer

    4 weeks ago

    Washington, Washington, D.C., United States AHU Technologies Inc Full time

    Job Title: Senior Informatica ETL DeveloperJob Summary:We are seeking a highly skilled Senior Informatica ETL Developer to join our team at AHU Technologies Inc. The ideal candidate will have a strong background in data integration and a proven track record of designing, developing, and implementing Informatica PowerCenter workflows and mappings.Key...

  • SQL/Informatica ETL Developer

    4 weeks ago

    Washington, Washington, D.C., United States Fusion Technology LLC Full time

    Job DescriptionSQL/Informatica ETL DeveloperFusion Technology LLC is seeking a skilled SQL/Informatica ETL Developer to support the execution of IT management and execution functions across units and systems. The ideal candidate will have at least 5 years of experience with the SQL format/data modeling, as well as the necessary developer skills to gather,...

  • SQL/Informatica ETL Developer

    1 month ago

    Washington, Washington, D.C., United States Fusion Technology Full time

    Job SummaryFusion Technology is seeking a highly skilled SQL/Informatica ETL Developer to support the execution of IT management and execution functions across units and systems. The ideal candidate will have at least 5 years of experience with the SQL format/data modeling and the latest versions of Informatica ETL.Key Responsibilities- Support the execution...

  • Data Integration Specialist

    4 weeks ago

    Washington, Washington, D.C., United States Educology Solutions Full time

    At Educology Solutions, we are seeking a highly skilled Data Integration Specialist to join our team. As a key member of our data team, you will be responsible for designing and developing processes that translate data from various sources to destinations and present findings to appropriate team members, clients, and vendors.The ideal candidate will have a...

  • SQL/Informatica ETL Developer

    4 weeks ago

    Washington, Washington, D.C., United States Fusion Technology Full time

    Fusion Technology is seeking a skilled SQL/Informatica ETL Developer to support the execution of IT management and execution functions across units and systems.The ideal candidate will possess at least 5 years of experience with the SQL format/data modeling, experience with the latest versions, and the necessary developer skills to gather, define, document,...

  • Data Steward with ETL Healthcare Expertise

    4 weeks ago

    Washington, Washington, D.C., United States AHU Technologies Inc Full time

    Job Title: Data Steward with ETL Healthcare ExpertiseJob Summary:A Data Steward with ETL healthcare expertise is sought by AHU Technologies Inc to support the work of the DCAS Program Administration, Executive Steering Committee, and DCAS Stakeholders. The successful candidate will play a critical role in defining and implementing policies and procedures for...

  • Data Analytics Platform Management Specialist

    4 weeks ago

    Washington, Washington, D.C., United States Apex Systems Full time

    Job Title: Data Analytics Platform Management SpecialistJob Summary:Alex Systems is seeking a Data Analytics Platform Management Specialist to design, configure, test, and deploy a new case management system and CRM. The ideal candidate will have experience with Salesforce data integration and development, using ETL tools to migrate data into...

  • Senior Data Testing Specialist

    4 weeks ago

    Washington, Washington, D.C., United States Diverse Lynx Full time

    Job Summary:As a Senior Data Testing Specialist at Diverse Lynx LLC, you will be responsible for developing and executing comprehensive test plans and test cases for ETL processes. You will validate data transformations, extraction, and loading processes to ensure data integrity and accuracy. Your expertise in testing data validation scenarios and data...

  • Data Warehouse Developer-III

    1 month ago

    Washington, Washington, D.C., United States Serigor Inc. Full time

    Job DescriptionWe are seeking a highly skilled Data Warehouse Developer-III to join our team at Serigor Inc. The ideal candidate will have a strong background in data engineering and experience with ETL tools such as Alteryx, SSIS, and SQL Server.Key Responsibilities:Gathering requirements and developing technical specifications for ETLDesigning and...

  • Data Warehouse Developer

    1 month ago

    Washington, Washington, D.C., United States LinTech Global Full time

    Job DescriptionWe are seeking a highly skilled Data Warehouse Developer to join our team at LinTech Global. As a key member of our Business Solutions Development team, you will be responsible for designing, implementing, and maintaining our data warehouse systems.Key Responsibilities:Design and implement data warehouse solutions using various...

  • Senior Data Developer

    4 weeks ago

    Washington, Washington, D.C., United States SynOpt LLC Full time

    Job Summary: We are seeking a highly skilled Senior Data Developer to join our team at SynOpt LLC. As a Senior Data Developer, you will be responsible for designing, developing, and implementing ETL processes for Data Warehousing and Data Migration projects using SAP Data Services.Key Responsibilities:Design, document, and implement SAP Data Service jobs to...

  • Data Migration Specialist

    4 weeks ago

    Washington, Washington, D.C., United States Tilo Dynamics Full time

    Job Title: Data Migration SpecialistJob DescriptionTilo Dynamics is seeking a highly skilled Data Migration Specialist to join our team. As a Data Migration Specialist, you will be responsible for testing data migrated from historic enterprise data sources into a cloud-based enterprise data platform.Key Responsibilities:Test data migrated from historic...

  • Data Transformation Specialist

    4 weeks ago

    Washington, Washington, D.C., United States Educology Solutions Full time

    Job Title: Professional Application DesignerJob Summary:Educology Solutions is seeking a skilled Professional Application Designer to join our team. The ideal candidate will have experience in designing and developing processes that translate data from various sources to destinations and present findings to appropriate team members, clients, and vendors.Key...

  • Data Transformation Specialist

    4 weeks ago

    Washington, Washington, D.C., United States Educology Solutions Full time

    Job Title: ETL Data AnalystJob Summary:We are seeking an ETL Data Analyst to join our team at Educology Solutions. The successful candidate will be responsible for performing research and requirement analysis, creating and designing mapping documents, and presenting findings to team members, clients, and vendors.Key Responsibilities:Develop program...

  • Senior Data Engineer

    4 weeks ago

    Washington, Washington, D.C., United States Mindlance Full time

    Job SummaryThe Senior Data Engineer will be responsible for implementing business intelligence solutions across all divisions of the organization. This individual will guide the team in designing and implementing each solution, improving technical standards, development processes, governance, and technologies.Key Responsibilities Serve as a technical lead in...

  • Senior Data Engineer

    4 weeks ago

    Washington, Washington, D.C., United States Mindlance Full time

    Job Summary:The Senior Data Engineer will be responsible for implementing business intelligence solutions across all divisions of the organization. This individual will guide the team in the design and implementation of each solution and will implement improvements of technical standards, development processes, governance, and technologies.Key...