ETL DeveloperWe are seeking a skilled ETL Developer to join our dynamic team. The ideal candidate will be responsible for designing and developing high-quality data integration solutions that extract data from various sources, apply transformation logic, and load it into our data warehouse databases. This role involves creating and enhancing databases, tables, and other database objects using T-SQL, as well as developing, tuning, and maintaining complex ETL processes using a variety of tools and scripting languages.Key Responsibilities:Design and develop DataStage jobs to efficiently extract data from heterogeneous sources.Implement transformation logics to clean, validate, and format data according to business requirements.Load transformed data into data warehouse databases, ensuring data integrity and availability.Create, develop, and manage databases, tables, stored procedures, DDL/DML triggers, views, user-defined data types, cursors, and indexes using T-SQL.Support the development and implementation of new ETL processes, with a focus on transitioning to ETL environment maintenance over time.Design, develop, and optimize complex ETL processes using tools and technologies such as Oracle, SQL, PL/SQL, Netezza, NZSQL, Linux, and Python scripting.Utilize a variety of DataStage stages (e.g., Transformer, Aggregator, Sort, Join, Merge) to create efficient data integration workflows.Willingness to travel to client sites to set up systems, conduct feasibility studies, and gather user requirements.Collaborate with cross-functional teams to ensure the seamless integration of ETL processes with business operations.Required Qualifications:Proven experience in designing, developing, and optimizing ETL processes and data integration solutions.Strong proficiency in SQL, PL/SQL, T-SQL, and scripting languages such as Python and Linux shell scripting.Experience with DataStage and its various stages (Transformer, Aggregator, Sort, etc.).Familiarity with database technologies (Oracle, Netezza) and data modeling principles.Ability to travel as needed to client sites across the nation.Excellent problem-solving skills and the ability to perform feasibility studies and evaluate user requirements.Interested candidates should submit their resume and cover letter to Euclid Innovations LLC outlining their qualifications and experience related to this role.
Please include examples of past projects or achievements that demonstrate your expertise in ETL development and data integration.We are an equal opportunity employer and welcome candidates from all backgrounds to apply.