ETL Snowflake Engineer

Job Tile: ETL Developer Location: Baltimore, MD (5 days onsite) Experience : 10+ years Final Round Should be Face - to - Face Skills Required: ETL, Snowflake, Azure data factory and Python Job Description seeking an experienced ETL/ELT Developer for a fixed term engagement in support of our Information Technology team. Alongside a team, the ETL/ELT Developer will be responsible for the development of integrations employing industry standard tools for data extraction, transformation and loading (ETL) to / from core critical enterprise systems. The ETL developer should specialize in designing, building, and maintaining data pipelines that move data to / from various sources and to / from cloud-based data warehouses or data lakes. They will focus on ensuring data is extracted, transformed, and loaded efficiently and reliably for analytics and other downstream systems uses. The ETL/ELT Developer 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.