Datawarehouse Development Contract using IICS or Redshift (100% Remote) || Madison, WI at Madison, Minnesota, USA |
Email: [email protected] |
From: Himanshu, DMS Visions INC [email protected] Reply to: [email protected] Hi, Hope you are doing well. Please find the job description given below and let me know your interest Title: Datawarehouse Development Contract using IICS/Redshift (100% Remote) Location: 100% Remote Duration: 6 Months This role is 100% remote but candidate must be in WI resident or willing to relocate. Job Description: DW ETL/Integration Roles Cloud Data Storage (Redshift) Informatica Intelligent Cloud Services (IICS) Data Integration Informatica Power Center Data Virtualization (Denodo) DBT (Data Build Tool) DW Modeling ETL/ELT Patterns Structured/Unstructured DataDETAILS: The Data Warehouse Developer will assist in the initial setup, configuration, and modeling of a new data warehouse in Redshift or Snowflake for the School of Medicine and Public Health. The person in this role will work closely with our data warehouse team, BI developers, software engineers, and external partners to build our new academic and administrative data warehouse (AADW) as part of the client. The Data Warehouse Developer will report to the Director for Data Analytics. REQUIRED SKILLS: Experience in multi-system data integration Experience with data integration through extract, transform, load (ETL) & ELT patterns Experience with data modeling and relational database design Experience with data warehouse development, maintenance, and auditing/logging NICE TO HAVE SKILLS: Experience with enterprise data integration tools (e.g., Informatica Intelligent Cloud Services ( IICS) Data Integration, Informatica PowerCenter, dbt), preferably IICS Data Integration Experience with structured and unstructured data Experience with cloud data storage (e.g., Snowflake, Redshift) Experience with data virtualization platforms (e.g., Denodo) Clear & effective written and verbal communication KEY RESPONSIBILITIES: 50% Perform data warehouse design and testing, including data design, database architecture, metadata, and repository creation 30% Design, develop, and maintain relational databases for data storage and mining. 15% Assist the internal database team with initial data transfers into a new warehouse. 5% Seek continuous improvement in the data warehouse's performance and ensure data security. If you are interested, please share your updated resume and suggest the best number & time to connect with you. Thanks & Regards Himanshu Gupta US IT RECRUITER, DMS VISIONS INC | (972) 433-0229 Ext-104 | ( 470) 467-9946 | dmsvisions.com | [email protected] LinkedIn: linkedin.com/in/himanshu-gupta-1888a1207 | 4645 Avon Lane, Suite 210, Frisco, TX 75033 | | Keywords: business intelligence information technology Texas Wisconsin Datawarehouse Development Contract using IICS or Redshift (100% Remote) || Madison, WI [email protected] |
[email protected] View all |
Thu Dec 19 05:25:00 UTC 2024 |