• Work closely with IT and Business Analysts to understand business requirements.
• To provide expert knowledge and solutions on IBM Datastage ETL, Unix Shell scripting in MSSQL, DB2 and Oracle database environments. Experience and knowledge in MSSQL Stored Procedure is an advantage.
• Strong development skills in IBM Datastage and Unix Shell scripting.
• To ensure delivery of business needs in a timely cost-effective manner.
• Prepare technical specification to ensure proper documentation of the system to be developed/changed for review by the supervisor, for audit checks and for future references.
• Provides reviews of deliverables and identifies gaps/areas for improvement.
• Provides end-users supports including business queries and requests.
• Create, execute, and document unit test plans for Data Stage ETL and data integration processes and programs.
• Identify opportunities to optimize the programming environment, quality and validation processes to ensure data accuracy and integrity.
• Analyze & translate functional specifications & change requests into technical specifications.
• Provides on the job training for team member to ensure proper understanding of the job responsibility and proper skills are obtained for the job assigned.


Source link