> Markdown version of [/jobs/ext/726748-sr-data-warehouse-specialist-etl-developer](https://www.wearedevelopers.com/jobs/ext/726748-sr-data-warehouse-specialist-etl-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Sr. Data Warehouse Specialist / ETL Developer - **Company:** ITCON Services - **Location:** United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Agile Methodology, Big Data, Information Systems, Information Engineering, Data Infrastructure, Data Integration, Extract Transform Load (ETL), Data Mart, Data Migration, Data Systems, Data Warehousing, IBM InfoSphere DataStage, Operational Databases, Performance Tuning, Systems Development Life Cycle, Query Optimization, SQL Databases, Enterprise Data Management, Information Technology, Integration Frameworks, Real Time Data, Data Pipelines, Legacy Systems - **Published:** June 29, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=1ce58a37e91c1242 ## About the Role Do you have experience in Workflow management (operations management method)?, Do you have a Bachelor's degree?, * Bachelor's degree in Computer Science, Information Systems, or related field. * Experience designing and developing ETL/ELT pipelines for large-scale data integration and data warehouse environments. * Strong SQL expertise, including query optimization and performance tuning. * Experience with enterprise data integration tools (e.g., IBM DataStage or similar ETL platforms). * Experience supporting data warehousing and data mart development efforts in complex environments. * Knowledge of data integration patterns, including ETL, ELT, and data migration across platforms. * Experience ensuring data quality, validation, and reliability within production data pipelines. * Ability to support full SDLC activities, including testing, deployment, and operational maintenance. * Eligibility for Public Trust clearance., * Experience in federal data environments (e.g., USDA FPAC or similar agencies). * Experience working with large-scale data sets and complex transformation logic. * Familiarity with real-time or near real-time data integration approaches and data federation techniques. * Experience supporting enterprise data warehouse modernization or migration initiatives. * Ability to work in Agile or hybrid SDLC environments supporting federal programs. ## Description * Design, build, and maintain complex ETL/ELT data pipelines that extract, transform, and load data from multiple source systems into enterprise data warehouses and data marts. * Develop scalable data integration workflows to migrate and transform data across platforms and support target systems (e.g., MRT and enterprise data environments). [B02 123144...FQ Package | PDF] * Optimize SQL queries and ETL processes to improve performance, efficiency, and execution reliability. * Ensure data accuracy, quality, and reliability across all data integration processes and data pipelines. * Support full systems development lifecycle (SDLC) activities, including requirements gathering, design, development, testing, deployment, troubleshooting, and maintenance. * Execute data migration and transformation activities, including converting data formats and integrating legacy systems into modern data platforms. * Develop and maintain automated data integration processes using ETL/ELT patterns and emerging approaches such as real-time or near real-time integration when required. * Provide technical leadership and mentorship to junior team members and enforce best practices across data engineering activities. * Collaborate with cross-functional teams, including data architects, analysts, and QA personnel, to align data solutions with business requirements. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [The Data Mesh as the end of the Datalake as we know it](https://www.wearedevelopers.com/videos/156-the-data-mesh-as-the-end-of-the-datalake-as-we-know-it) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [System change: restart as developer?](https://www.wearedevelopers.com/magazine/39-system-change-restart-as-developer) - [A Guide to Green Tech and Green IT Careers](https://www.wearedevelopers.com/magazine/374-a-guide-to-green-tech-and-green-it-careers)