ETL/Data Warehouse Engineer (Federal Government Project) jobs in United States
cer-icon
Apply on Employer Site
company-logo

Zyxware Technologies · 1 day ago

ETL/Data Warehouse Engineer (Federal Government Project)

positionUnited States
timeFull-time
remoteRemote
senioritySenior Level, Lead/Staff
date12+ years exp

Zyxware Technologies is seeking a Senior ETL Developer / Data Warehouse Engineer to support federal clients by designing, developing, and maintaining secure and scalable data solutions. The role involves end-to-end delivery of enterprise ETL pipelines and ensuring data quality across various systems.

Digital MarketingEnterprise Resource Planning (ERP)InternetSaaSSoftwareWeb DesignWeb DevelopmentWeb Hosting
Hiring Manager
Naga Sri Sai
linkedin

Responsibilities

Determine enterprise data storage and data integration requirements in support of federal mission needs
Design, build, and maintain data warehouses, operational data stores (ODS), and data marts to support internal departments and analytics use cases
Lead logical and physical data model design, implementation, and optimization
Develop, automate, and support robust ETL processes to extract, transform, and load data from multiple structured and unstructured data sources
Ensure data accuracy, completeness, consistency, and overall data quality across all data pipelines
Design and implement ETL workflows using the Talend ETL platform, including logical and physical data flow models
Translate data access, transformation, and data mobility requirements into functional specifications and mapping designs
Integrate data from a variety of interfaces, including REST APIs, SOAP services, custom APIs, SQL-based sources, and NoSQL platforms
Perform advanced SQL development and tuning, including stored procedures, views, and performance optimization
Troubleshoot complex data issues and work collaboratively with stakeholders to ensure reliable and compliant data delivery

Qualification

ETL developmentData warehousingSQL expertiseTalend ETL toolsData modelingData integrationSnowflakeAnalytical skillsCommunication skillsTime managementCritical thinking

Required

Bachelor's degree in Computer Science, Information Technology, or a closely related discipline (or equivalent experience)
Minimum of 12 years work experience with, 5 years of experience in ETL development and data warehousing in enterprise environments
Demonstrated experience designing and supporting large-scale ETL pipelines and data integration solutions
Strong SQL expertise, including query optimization, stored procedures, views, and database performance tuning
Solid understanding of data modeling concepts and data warehouse design patterns
Hands-on experience with Talend ETL tools
Experience with relational and non-relational (SQL/NoSQL) data platforms, including Snowflake
Working knowledge of integrating data using REST, SOAP, custom APIs, and direct database access
Strong analytical and problem-solving abilities with the capacity to troubleshoot complex data issues
Excellent verbal and written communication skills, including the ability to work effectively with technical and non-technical stakeholders
Strong time management, multitasking, and prioritization skills in a deadline-driven environment
Demonstrated critical thinking, attention to detail, and sound judgment
Ability to work independently while collaborating effectively within a cross-functional team

Company

Zyxware Technologies

twittertwittertwitter
company-logo
Zyxware is one of the largest exclusive Drupal companies based out of India
dateFounded in 2006
location
Trivandrum, Kerala, IND
people-size51-200 employees
web-link
http://www.zyxware.com

Funding

Current Stage
Growth Stage

Leadership Team

leader-logo
Thomas P Thomas
C.E.O.
linkedin
Company data provided by crunchbase