| DataWarehouseConsultant || Remote at Remote, Remote, USA |
| Email: [email protected] |
| From: Naveen, Smart IT Frame [email protected] Reply to: [email protected] Hi, Greetings from Smart IT Frame, Hope you are doing well!!! Smart IT Frame specializes in enabling you with your most critical line of resources. Whether its for permanent staffing, contract staffing, contract-to-hire or executive search, we understand the importance of delivering the most suitable talent; on time and within budget. With our Core focus in emerging technologies, we have provided global technology workforce solutions in North America, Canada & India. We take pride in delivering specialized talent, superior performance, and seamless execution to meet the challenging business needs of customers worldwide. Role: Data Warehouse Consultant Location: Remote Type: Contract Shift Day 9AM TO 6PM EST Candidates having 8 to 15 years experience. In depth knowledge in Snowflake and Data Modelling + Tableau/Power BI, DW Concepts development Should be good in developing models using open source (DBT or any open source) or with modelling tools. Data Warehousing In-and-Out clear understanding with Hands On experience in DW, Should worked on below mentioned features at least, Different Constraints, Referential Integrity, Denormalization. Dimensional Modelling, Different types of Schema, Fact & Dimensions, Different types of Keys SCD types. SQL Knowledge, InDepth SQL knowledge / SnowSQL is a must . Azure Cloud & Agile method Designing, Developing, and maintaining the data architecture, data models in snowflake Able to gather end user requirements and writing technical documentation Hands on experience with multiple Snowflake objects implementation, SnowSQL, SnowPipe, Views and Snowflake Procedures Strong experience write complex SQL query stored procedure etc Work with Project Manager and Project Lead to get his Client user accounts created Worked on AVRO, PARQUET files loading to snowflake Knowledge of SQL, Unix & advanced Unix Shell Scripting Hands on file transfer mechanism FTP etc Knowledge of Schedulers like TWS Thanks & Regards Navaneetha Krishnan Senior Technical Recruiter Smart IT Frame LLC [email protected] www.smartitframe.com Keywords: business intelligence information technology |
| [email protected] View all |
| Fri Jan 26 05:34:00 UTC 2024 |