Note: The job is a remote job and is open to candidates in USA. Zyxware Technologies is seeking a Senior ETL Developer / Data Warehouse Engineer to support federal clients by designing, developing, and maintaining secure data integration and warehousing solutions. The role involves the end-to-end delivery of enterprise ETL pipelines and ensuring data quality across systems.
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
Skills
• 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 Overview
• Zyxware is one of the largest exclusive Drupal companies based out of India It was founded in 2006, and is headquartered in Trivandrum, Kerala, IND, with a workforce of 51-200 employees. Its website is http://www.zyxware.com.