Full-Time
Data Engineer
Bitful Consulting
No salary listed
Remote in USA
Remote
Category
 Data & Analytics (1) |
|---|
Required Skills
Microsoft Azure
Oracle Hyperion
Data Structures & Algorithms
SQL
ETL
Informatica
Data Modeling
Oracle
Database Administration
Requirements
- Two to three or more years of proven experience performing large data migration and transformation efforts.
- Strong hands-on experience with Microsoft Azure data and analytics, including Azure Synapse, Azure Data Factory, and Azure Data Lake Storage.
- Experience writing complex SQL queries and creating data models.
- Experience or exposure to T-SQL, SQL Server, and PL/SQL.
- Experience or exposure to Informatica PowerCenter, star schema, and snowflake schema.
- Experience with database performance tuning.
- Experience with data warehouses and data marts.
- Strong knowledge of various data structures and the ability to extract data from various data sources, such as Cognos, Informatica, and Hyperion.
Responsibilities
- Work in an Azure data warehouse environment, including developing database designs and architecture, data modeling, and metadata repository creation.
- Work with architects, technical leads, and business teams and contribute to the development of technical designs.
- Secure data migrations and transformations to and from clients, customers, and vendors.
- Provide technical database consultation on application development, global infrastructure, and other database administration efforts related to specific database management systems.
- Conduct data profiling, cataloging, and mapping for the technical design and construction of technical data flows.
- Migrate current extract, transform, and load and SQL Server Integration Services packages to Azure Synapse.