ETL Developer Data Vault

1 week ago

Washington, United States Sylger Corporation Full time
Job Description

Job Description

Sylger Corporation is an administrative and technical support contractor to the federal government. We have immediate openings to provide BI and ETL support to a federal agency located in downtown DC.

The candidate must be able to pass federal security background review.

We are looking for a T-SQL, specialist and data management professional with extensive knowledge of Phython, Pandas and Data Vault 2.0 methodology.

a. The candidate must meet or exceed each of the following requirements:
(1) One or more years of data modeling or data warehouse architecture experience
using the Data Vault 2.0 methodology;
(2) Two or more years of data modeling or data warehouse architecture experience using any
Data Vault methodology;
(3) Three or more years of experience developing ETL or ETL pipelines in an environment
that uses DevOps principles and practices (e.g., automation, infrastructure as code,
containerization, testing); and
(4) Five or more years of experience developing procedural SQL development using the TSQL
dialect.
b. The below elements represent the type of work to be performed by candidates in this
position:
(1) Proposing and designing changes to a physical data model to resolve and articulate
problems;
(2) Developing procedural T-SQL, SQL Server Information Services (SSIS) jobs, or set-based
SQL scripts (i.e., using a SELECT-INTO-FROM pattern) to extract data from a source system
and load it into the data warehouse or transform and load it between logical layers within the
data warehouse;
(3) Writing 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;
(4) Monitoring deployed ETL/ELT jobs and debugging/troubleshooting any errors/issues
encountered;
(5) Amending ETL/ELT scripts to correctly handle exceptional or aberrant records; and
(6) Writing tests to verify the integrity of relations/objects within the data warehouse.

In addition the candidate must have demonstrated capability to perform the following duties:

a. Experience (within the last year) developing schema in Azure, Python and supplemented with expert level of Tableau visualization tools.

b. Experience in dashboard development to support data-driven for information-sharing and decision-making;

c. Shall create dashboards from live data tables, not just data extracts;

d. Shall develop both simple and complex data visualizations;

e. Experience with performance optimization techniques, allowing for efficient data manipulation that does not slow dashboard function for the end user;

f. Experience working collaboratively with data analysts and other end users to gather visualization and reporting needs and requirements;

g. Familiarity with and adherence to basic design principles, including, but not limited to, meaningful use of color;

h. Experience working with a data warehouse;

i. Experience in database systems like SQL Server and PostgreSQL;
j. Experience with data blending or joins to integrate data from multiple data sources;

k. Experience manipulating and visualizing a variety of common data types including, but not limited to, numeric, string, date time, and geographic/geometric;

l. Experience visualizing administrative records from multi-step business process to reflect derived dimensions of interest to process owners, including, but not limited to, timeliness, efficiency, completeness, and effectiveness;

m. Responsive and able to complete projects in a timely manner;

n. Shall innovate while staying within the any imposed agency constraints;

o. Flexible to work well in an environment where things may change frequently or stall for periods of time;

p. Diligent about documentation and knowledge transfer, to include production of clean files;

q. Shall host relevant training on dashboards; and

r. Shall 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

Company Description

Sylger Corporation is a federal government support contractor. We provide administrative, management and technical support to the Federal Government. We offer 1099 full time consulting options.

Company Description

Sylger Corporation is a federal government support contractor. We provide administrative, management and technical support to the Federal Government. We offer 1099 full time consulting options.

  • ETL Developer Data Vault

    2 months ago

    Washington, United States Sylger Corporation Full time

    Job DescriptionJob DescriptionSylger Corporation is an administrative and technical support contractor to the federal government. We have immediate openings to provide BI and ETL support to a federal agency located in downtown DC.The candidate must be able to pass federal security background review. We are looking for a T-SQL, specialist and data management...

  • Business Intelligence Developer Data Warehouse Architect

    3 days ago

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

    Job DescriptionWe are seeking a highly skilled Business Intelligence Developer to join our team at Sylger Corporation. The successful candidate will have extensive experience in data modeling, data warehouse architecture, and ETL development using the Data Vault 2.0 methodology.The ideal candidate will possess strong analytical skills, with the ability to...

  • Technical Data Warehouse Specialist

    4 days ago

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

    About the JobWe are seeking a skilled Technical Data Warehouse Specialist to join our team at Sylger Corporation. This is an exciting opportunity to work on high-profile projects with a federal government client located in downtown DC.Job SummaryThe successful candidate will be responsible for designing and implementing data warehouses using the Data Vault...

  • ETL Developer

    2 months ago

    Washington, United States SynOpt LLC Full time

    Job DescriptionJob DescriptionThe right candidate will apply their technical knowledge in designing, implementing and maintaining Extract Transform Load (ETL) solutions. Responsibilities may include converting specifications into design and converting design into deliverables; design, documentation, development, modification, testing, installation,...

  • ETL Developer

    5 months ago

    Washington, United States SynOpt LLC Full time

    Job Description Job Description The right candidate will apply their technical knowledge in designing, implementing and maintaining Extract Transform Load (ETL) solutions. Responsibilities may include converting specifications into design and converting design into deliverables; design, documentation, development, modification, testing, installation,...

  • ETL Developer

    1 week ago

    Washington, United States Alpha Staffing Agency Full time

    Job Description Job Description Expert Informatica ETL Developer with at least 10+ years of proven professional experience in the design, development, testing and administration of Informatica PowerCenter workflows and mappings. We are looking for a Expert Informatica ETL Developer who will be responsible for designing, implementing, and testing Informatica...

  • ETL Developer

    2 weeks ago

    Washington, United States Alpha Staffing Agency Full time

    Job DescriptionJob DescriptionExpert Informatica ETL Developer with at least 10+ years of proven professional experience in the design, development, testing and administration of Informatica PowerCenter workflows and mappings.We are looking for a Expert Informatica ETL Developer who will be responsible for designing, implementing, and testing Informatica...

  • ETL Developer

    1 week ago

    Washington, United States InterSources Full time

    ETL Developer Address: Washington, DC (Remote) 12-24 Months Contract Position Job Description: Expert Informatica ETL Developer with at least 10+ years of proven professional experience in the design, development, testing and administration of Informatica PowerCenter workflows and mappings. Responsibilities: The Core duties associated with the role...

  • IT Developer

    2 months ago

    Washington, United States Sylger Corporation Full time

    Job DescriptionJob DescriptionSylger Corporation is an administrative and technical support contractor to the federal government. We have an immediate opening to provide support a federal client located in downtown DC.  The candidate must be able to pass public trust security background review. This is an onsite, contract support position currently funded...

  • ETL Informatica Developer

    4 weeks ago

    Washington, United States Vied Technologies, Inc. Full time

    Incorporated in 2006; Headquartered in Chantilly, VA. Viedtech has established itself globally with its services and solution excellence. Viedtech offers fast, reliable, cost effective and value added IT and Staffing Services.We constantly strive hard to refine our quality, expand our capabilities, increase our efficiency, and elevate the superior level of...

  • ETL Informatica Developer

    5 months ago

    Washington, United States ViedTech Full time

    Company Description Incorporated in 2006; Headquartered in Chantilly, VA. Viedtech has established itself globally with its services and solution excellence. Viedtech offers fast, reliable, cost effective and value added IT and Staffing Services. We constantly strive hard to refine our quality, expand our capabilities, increase our efficiency, and elevate...

  • ETL Data Engineer

    2 months ago

    washington, United States Serigor Inc Full time

    Job Title: ETL Data Engineer (ONSITE)Location: Washington, DCDuration:12 Months+Job Description:The Enterprise Data team at client requires an ETL data engineer to support data operations for its Cloud Data Exchange. The resource will utilize native Azure tools to perform ETL, data loading and data transformation tasks.The ETL data engineer will support the...

  • ETL Data Engineer

    2 months ago

    Washington, United States Serigor Inc Full time

    Job Title: ETL Data Engineer (ONSITE)Location: Washington, DCDuration:12 Months+Job Description:The Enterprise Data team at client requires an ETL data engineer to support data operations for its Cloud Data Exchange. The resource will utilize native Azure tools to perform ETL, data loading and data transformation tasks.The ETL data engineer will support the...

  • Senior ETL Developer

    4 weeks ago

    Washington, United States 9th Way Insignia Full time

    Job DescriptionJob Description9th Way Insignia is a service-disabled, veteran-owned small business bringing transformative technology to our government customers so they can achieve their missions. Our specialties include cybersecurity, cloud modernization, software development, data analytics, enterprise architecture, enterprise IT, analytics, process...

  • Senior ETL Informatica Developer

    7 days ago

    Washington, United States Vied Technologies, Inc. Full time

    About this role:Vied Technologies, Inc. is seeking a skilled Senior ETL Informatica Developer to join our team.In this role, you will be responsible for managing complex ETL requirements and designing end-to-end data warehousing solutions using Informatica.You will have good experience with Informatica cloud migration projects and a strong understanding of...

  • Junior SQL/ETL Developer

    3 months ago

    Washington, United States Arena Technical Resources Full time

    Junior SQL/ETL Developer Location: Washington, DC, US Job ID: 16213 Job Description Job Description: Job Title: Junior SQL/Informatica ETL Developer Job Location: Washington, DC (1 day telework) clearance: Top Secret What you’ll do: You will support the execution of IT management and execution functions across units and systems, to build on the...

  • ETL Developer

    1 week ago

    Washington, United States System One Full time

    ALTA IT has a Long-Term Contract position open for a ETL Developer. Washington DC 20006 - Remote with one day a week onsite Per Federal Govt Sector U.S Citizenship is required Ability to pass Federal background check is required for Level 4 Public Trust Clearance Looking for a mid-level to senior ETL developer with proven experience in designing,...

  • Expert Informatica ETL Developer

    1 week ago

    Washington, Washington, D.C., United States Volitiion IIT Full time

    Job OverviewWe are seeking a highly skilled Expert Informatica ETL Developer to join our team as a Data Integration Specialist. This individual will be responsible for designing, implementing, and testing Informatica Powercenter Workflows and Mappings.

  • ETL Informatica Developer

    21 hours ago

    Washington, DC, United States Vied Technologies, Inc. Full time

    Incorporated in 2006; Headquartered in Chantilly, VA. Viedtech has established itself globally with its services and solution excellence. Viedtech offers fast, reliable, cost effective and value added IT and Staffing Services. We constantly strive hard to refine our quality, expand our capabilities, increase our efficiency, and elevate the superior level of...

  • ETL Developer: Informatica Expert with Leadership Skills

    1 week ago

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

    Expert ETL Developer Wanted for AHU Technologies IncWe are seeking an experienced ETL developer to join our team at AHU Technologies Inc.About the RoleThis is a remote position that requires exceptional skills in Informatica PowerCenter 9.X, Oracle Database, and SQL. As an expert ETL developer, you will design, implement, and test workflows and mappings to...