> Markdown version of [/jobs/ext/539295-etl-specialist](https://www.wearedevelopers.com/jobs/ext/539295-etl-specialist). 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). --- # ETL Specialist - **Company:** IBA InfoTech Inc. - **Location:** Kansas City, MO, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Unit Testing, Batch Processing, Big Data, Unix, Cloudera Impala, Computer Programming, Extract Transform Load (ETL), Data Warehousing, Relational Databases, IBM InfoSphere DataStage, Dimensional Modeling, Apache Hadoop, Hadoop Distributed File System, Apache HBase, Apache Hive, Microsoft SQL Server, Networking Basics, SQL Databases, Sqoop, Extensible Markup Language (XML), Freeform SQL, File Transfer Protocol (FTP), Netezza, Xml Files, Information Technology - **Published:** June 14, 2026 - **Apply:** https://ibainfotech.com/etl-specialist ## About the Role * Bachelor's degree in Computer Science, Business Administration, Engineering, or related discipline with an information technology focus (necessary to develop self-direction, writing ability, critical thinking, and foundations of programming and software delivery fundamentals) or commensurate experience * Minimum 5+ years of hands on experience with IBM InfoSphere DataStage Enterprise Parallel Edition. (Version 11.3 or above). * Strong knowledge of Datastage parallel frame work, Partitioning, Parameters/Sets and best practices for optimized coding. * 3+ years of experience in handling large XML files using XML stages/Pack to read and create XML files on a real time and batch processing mode. * 5+ Years of Experience on SQL against relational databases preferably with MS SQL Server 2014 and above. Must be able to understand complex SQL queries and transform into optimized ETL Coding. * 5+ years of demonstrated knowledge in Data warehousing concepts, architectures, design and dimensional modelling. * Proven understanding of Hadoop Ecosystem * Working knowledge of Hadoop components like HDFS, Hive, Pig, Sqoop, Hbase, and Impala. * 3+ years in UNIX scripting, understanding of FTP standards/process and basic network principles. * 2+ years of automation experience using scheduling software. * Ability to interpret DataModel & mapping document, understand technical requirements, prepares Technical Design Document, develop ETL Code, create unit test cases/data, perform unit testing and solves defects in a timely manner. * Supports for a successful project implementation and resolves production issues during project warranty period. * Effectively communicate Oral & Written. Work across teams within and outside of IT including DAs, DBAs, QAs, PM and Business Users as necessary. * Under minimal supervision, takes ownership and responsibility on the assigned tasks and strive for completion within the timeline. * Must be a quick learner to adapt to Enterprise standards and best practices. * Datastage QualityStage is desired but not required * IBM Information Services Director is an advantage * Working knowledge of Netezza is a plus ## Related Videos - [WeAreDevelopers LIVE - Node and Package Security](https://www.wearedevelopers.com/videos/2138-wearedevelopers-live-node-and-package-security) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [The Time Paradox: Building Timezone-Safe Python/Django Applications](https://www.wearedevelopers.com/videos/1915-the-time-paradox-building-timezone-safe-python-django-applications) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Coffee with Developers - Robby Russell](https://www.wearedevelopers.com/videos/917-coffee-with-developers-robby-russell) ## Related Articles - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)