AI Engineer

Job Description:

• Minimum 7 years of development experience in DataStage (Version V8.5 or higher) with experience in processing high volume jobs

• 7+ years experience in Advanced Infosphere DataStage Design and ADF Development.

• 3+ years in DB2 UDB Administration and Support

• 2+ years Report Solution/Design experiences.

• Experience Datastage 11.3 and 8.7 is a must

• Strong experience with UNIX and shell scripting

• Mastery level on Datastage 8.7 server and parallel versions

• Write ETL Technical Specifications

• 3+yrsAzure Data Factory (ADF)/ Microsoft SQL Server Jobs:

• Using ADF connectors to connect to various data sources and destinations.

• Implementing data flows within ADF for complex transformations.

• Scheduling and monitoring ADF pipelines.

• Creating and managing pipelines in ADF to orchestrate data movement and transformation

• Creating and managing SQL Server Agent jobs for automated tasks, including ETL processes.

• Writing and optimizing SQL queries for data extraction and transformation.

• Using SSIS packages for complex ETL operations within SQL Server.

• Troubleshooting and resolving issues related to SQL Server jobs and SSIS packages.