Job description

ETL Consultant (ADF & Snowflake) job at Cloud Analytics Technologies LLC. Baltimore, MD. Job Details ETL Developer - Baltimore, MD - Onsite Responsibilities: • Data Transformation: Develop and optimize data transformations using cloud-based tools and technologies to cleanse, enrich, aggregate, and reshape data according to business requirements. • Load transformed data into cloud data warehouses (like Snowflake, Azure Synapse, or BigQuery) or data lakes for storage and further analysis. • Performance Optimization: Ensue efficient data processing and pipeline performance within on-premises and cloud environments by leveraging cloud-native services and optimizing resource utilization. • Utilizing cloud-specific tools and services (e.g., FiveTran, Snowpipe, Streams and Tasks, Azure Data Factory) for ETL processes. • Orchestration and Automation: Automate ETL workflows using orchestration tools or cloud-based workflow services. • Data Integration: Design and implement ETL pipelines that extract data from diverse cloud and on-premises sources (databases, APIs, files, etc.). • Collaborate with data analysts, systems analysts, developers and other stakeholders to understand data requirements and ensure the successful delivery of data for analytics and other business needs. • Create and/or update knowledge base articles regarding procedures, workflows, user guides, process run books, etc. • Participate within the change management process. Job Requirements • BS in Information Systems, Information Technology, or a related field is required. Work experience in lieu of degree or concentration is acceptable. • Minimum of 5 7 years of similar work experience as a ETL Developer in a comparable environment and industry. • Snowflake - Intermediate level knowledge required. • Proficiency in Python and/or R is a plus • Excellent analytical and troubleshooting skills. • Excellent organizational, teamwork and time management skills. • Excellent oral and written communication skills. • Ability to handle multiple parallel tasks.

Requirements