Orcapod Consulting Services Pvt Ltd is Looking for SQL Developer with SSIS Developer exp must position Full Time

Job Description

SQL Developer / Data architecture For Infosys / CTH – Remote4 – 9 yearsHyderabad/Secunderabad, Pune, Chennai, Bangalore/Bengaluru, Trivandrum/Thiruvananthapuram, Mumbai (All Areas)Role: SQL Developer / Data architectureRel Exp: 4+ YearsDetailed Data architecture design and optimizationSQL Query design and optimizationStored Procedure design and optimization (Loops, Dynamic SQL, Information Schema)TSQLQuery Execution PlansData Warehousing Concepts like building Facts, DimensionsTable design, includingProper column definitionsProper indexingAbility to receive a dataset, determine what the primary key should be, and whether the primary key is valid (i.e. metric columns are not part of the key)Proper normalization techniques (third order)Be able to do performance tuning on SQL QueriesBe able to do Sql code validationBe able to convert OLTP tables to OLAP tables.Having Knowledge on creating Tabular Model in SSAS is a plusInterview Mode: Telephonic / Web-Ex/ TeamReporting Locations: Remote Work / WFH / OffshoreNotice Period: immediate joiner within 15 to 20 days(Apply who are interested for Contract to hire) and send CV tohidden_email Let me know if that possible, then please fill in below detailsTotal expRel expCurrent CTCExpected CTCCurrent locationOfficial notice period/ LWDOffer in hand with detailsAre you interested to work in contract Interview availabilityWorking hours: 9:30AM – 6:30PM