Job Title: Data Analyst / Data Developer
Location: Malaysia
Experience Required: 512 Years
Job Description
We are looking for an experienced Data Analyst/Data Developer with strong hands-on expertise in IBM Datastage, MS SQL Server, and shell scripting. The ideal candidate will be responsible for developing ETL processes, managing SQL-based data operations, and ensuring efficient data flow across systems.
Key Responsibilities
- Design, develop, and maintain ETL workflows using IBM Datastage.
- Build and optimize SQL queries, stored procedures, and database scripts in MS SQL Server.
- Use MS SQL Utilities (BCP) for bulk data extraction, loading, and transformation.
- Develop and manage Linux shell scripts for automation of data processes.
- Perform data validation, troubleshooting, and performance tuning.
- Collaborate with cross-functional teams for seamless data operations.
- Maintain high standards for data accuracy, consistency, and security.
Must-Have Skills
- IBM Datastage
- MS SQL Server
- MS SQL Utilities (BCP)
- SQL (Queries, Stored Procedures)
- Linux Shell Scripting
- MS SQL Database experience
Technical Skills
Primary: IBM Datastage
Secondary: MS SQL Server, MS SQL Utilities (BCP)
Good to Have (Optional)
- Knowledge of data warehousing concepts
- Experience with performance tuning and optimization
- Exposure to enterprise-scale data environments
