Data Integration Engineer

Rapsys Technologies
Dallas, United States of America
3 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Dallas, United States of America

Tech stack

Sql Data Warehouse
Amazon Web Services (AWS)
JIRA
Unit Testing
Cloud Engineering
Code Review
Data Integration
Data Systems
Data Warehousing
Information Lifecycle Management
Meta-Data Management
Performance Tuning
Scrum
PL-SQL
SQL Databases
Snowflake
Data Lineage
Performance Monitor
Data Management
Data Pipelines
Sql Tuning

Requirements

Role - Data Integration Engineer | Location - Primary - Dallas | Secondary - Tampa Job Description Minimum 8 years of experience in Data Management| with strong expertise in analytical datawarehousing and enterprisescale data platforms| contributing to the delivery of complex datasolutions. Minimum 3 years of hands-on experience with Snowflake Cloud Data Warehouse| includinguse of advanced features and performance optimization for large| concurrent analytics workloads. Strong experience with AWS cloud architecture| designing and supporting scalable| secure| andcostefficient data solutions using core AWS services. Design| develop| and maintain complex SQL and PLSQL procedures to supporthighperformance data integration and transformation processes. Experience developing data integration solutions using Snowflake services such as Snowpark|Streams| Tasks| and Snowpipe to implement both realtime and batch data pipelines within anAWS ecosystem. Strong knowledge of logical and physical data modeling| enabling effective analytics|reporting| and business intelligence solutions. Hands-on experience developing dimensional data models| including slowly changingdimensions (SCDs) and multiple fact table designs| aligned with analytics best practices. Solid experience across data lifecycle management| including data lineage| profiling|mapping| integration| validation| cleansing| masking| subsetting| archiving| purging|virtualization| and metadata management. Implement and adhere to data quality and testing standards| supporting unit testing| systemintegration testing| and UAT| to ensure productionready data solutions. Perform SQL performance tuning| proactive monitoring| and root cause analysis of datapipeline and platform issues| driving timely and effective resolution. Actively participate in Agile delivery teams| contributing to sprint planning| story implementation|estimation| and documentation using Jira. Collaborate closely with peers| architects| and stakeholders| and provide guidance to juniorengineers through code reviews and knowledge sharing. Demonstrate strong verbal and written communication Essential Skills: Role - Data Integration Engineer | Location - Primary - Dallas | Secondary - Tampa Job Description Minimum 8 years of experience in Data Management| with strong expertise in analytical datawarehousing and enterprisescale data platforms| contributing to the delivery of complex datasolutions. Minimum 3 years of hands-on experience with Snowflake Cloud Data Warehouse| includinguse of advanced features and performance optimization for large| concurrent analytics workloads. Strong experience with AWS cloud architecture| designing and supporting scalable| secure| andcostefficient data solutions using core AWS services. Design| develop| and maintain complex SQL and PLSQL procedures to supporthighperformance data integration and transformation processes. Experience developing data integration solutions using Snowflake services such as Snowpark|Streams| Tasks| and Snowpipe to implement both realtime and batch data pipelines within anAWS ecosystem. Strong knowledge of logical and physical data modeling| enabling effective analytics|reporting| and business intelligence solutions. Hands-on experience developing dimensional data models| including slowly changingdimensions (SCDs) and multiple fact table designs| aligned with analytics best practices. Solid experience across data lifecycle management| including data lineage| profiling|mapping| integration| validation| cleansing| masking| subsetting| archiving| purging|virtualization| and metadata management. Implement and adhere to data quality and testing standards| supporting unit testing| systemintegration testing| and UAT| to ensure productionready data solutions. Perform SQL performance tuning| proactive monitoring| and root cause analysis of datapipeline and platform issues| driving timely and effective resolution. Actively participate in Agile delivery teams| con Data Integration Engineer

Apply for this position