> Markdown version of [/jobs/ext/4505831-it-specialist](https://www.wearedevelopers.com/jobs/ext/4505831-it-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).

---

# IT SPecialist

- **Company:** JSM Consulting
- **Location:** Albany, NY, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** IBM AIX, Data Analysis, Unit Testing, Software Documentation, Information Systems, Computer Programming, Databases, Extract Transform Load (ETL), Data Security, Data Warehousing, IBM InfoSphere DataStage, Software Debugging, IBM Cognos Business Intelligence, Unix Shell, Oracle (Applications), PL-SQL, SQL Databases, Information Technology, Data Analytics, Code Migration
- **Published:** November 2, 2026
- **Apply:** https://www.careerbuilder.com/job-details/it-specialist-albany-ny--51d118d8-21e0-4269-ab6f-c095da8a87cf

## About the Role

Information Technology & Information Systems, SQL (Structured Query Language), Oracle PL-SQL, Database Extract Transform and Load (ETL), Oracle, Time Management, Unix Shell Programming, Unit Test, Mentoring, Documentation, 72 Months ETL development experience in Oracle environment with IBM DataStage
84 Months ETL design/Data Warehouse development experience using SQL and PL/SQL programming
84 Months experience tuning SQL within an Oracle environment to improve timely and efficient execution of queries
84 Months UNIX Shell Scripting experience
60 months experience in programming and unit testing.
60 months experience in program code documentation, mentoring and assisting other developers.
60 months experience working with PPI and SSA data security requirements (working with data contained in Employee Records in a State Agency, Federal Agency or Private Organization) for production system error diagnosis, debugging, and code modification
84 Months experience developing dimensional data models for Cognos data analytics
84 Months experience developing data analysis and metrics queries for operational oversight.
84 Months DataStage Administrator experience on AIX environments that includes implementing and maintaining business and technical rules; automating ETL code migration process and standards for
Stop/start services; monitor logs; setting up security; assigning roles; project permissions; Create/Delete projects; create/modify environmental parameters; Platform Issue resolution; troubleshooting and root cause analysis; Configuration and tuning of production and lower-level environments; and capacity planning.