ETL & Data Warehouse Engineer

PRIMARY DUTIES / RESPONSIBILITIES :

• Maintain and provide enhancements to data architecture within new / existing systems including Data Warehouse.
• Recommend and implement processes to improve data quality, data reliability, and database performance.
• Employ variety of ETL and integration tools for system and data integrations.
• Architect solutions that support data scientist and business stakeholders.
• Conduct ETL testing and data transformation testing.
• Develop data models for data science team that can be utilized for data mining.
• Maintain source to target documentation and process flow documentation.
• Take on DBMS responsibilities and wear multiple hats such as : ETLs, serve as SQL Server DBA Processes / Job / Error Handling / Troubleshooting / Scheduling, etc.
• Proactively monitor ETL Processes / :
• Relevant hands-on work experience in a Datawarehouse testing role.
• ETL (Extract Transform Load) / ODS (Operational Data Store) experience.
• MS SQL Server
• Commercial Real Estate experience :
• Bachelors degree in Computer Science or Information Technology from an accredited :
• ETL Tools : SSIS 5+ years, Azure Data Factory (ADF) 3+ year, ZappySys 1yr, APIs 2+ years.
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. (4+ years of SQL), and working knowledge of Azure.
• Proficient in MS SQL Server database including setting indexes, database security, and backups.
• Data Testing : 3+ years
• Fundamental knowledge of data warehouse concepts
• Data Warehouse testing : 2+ year.
• Javascript 1+ years, C# 2+ Years
• Experience in data duality, source systems analysis, and business rules validation.
• Ability to write and understand Source to Target documentation.
• Detail oriented and meticulous approach to duties.
• Keep our data separated and secure. Familiarity with data and cybersecurity.
• Good analytical skills.
• A knack for independent and group work.
• Capacity to successfully manage a pipeline of duties with minimal supervision.

(ref : hirist.tech)