ETL Developer

About the Company

Looking for an ETL Developer with expertise in DataStage, Azure Data Factory (ADF), and Microsoft SQL Server for managing and integrating data within an organization. These roles involve designing, developing, and maintaining data pipelines to extract, transform, and load data from various sources into target systems for analysis and reporting.

Required Skills

- 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+ years Azure 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.