Expertise and hands-on experience on one of the EDW Teradata/Netezza/Oracle – Must Have Expertise in writing SQL queries - Must Have
Expertise in fine tune queries to meet SLA - Must Have
Good knowledge of database migration – Good to Have
Good knowledge of Shell script – Good to Have
Good knowledge of HiveQL & SparkQL – Good to Have Knowledge of data import and export – Good to Have
Knowledge of backup & restoration – Good to Have Passionate about exploring new technologies – Good to Have Automation approach - – Good to Have
Good Communication Skills – Must Have
","jobTitle":"SQL Engineer","jobUpdatedDate":"2021-10-25T04:56:21.825Z","logo":"https://shenzyn-uploads.s3.ap-south-1.amazonaws.com/ProfilePics/impetusshenzyn%40gmail.com_impetus-social-logo.png","maxannualCTC":"1600000","minannualCTC":"600000","otherMonetoryBenefits":"","travelRequired":false,"vacancies":"2","extractedSkills":["expertise","amp","query","meet","approach","automation","backup","data","database","edw","explore","export","fine","hand","hiveql","import","write","tune","netezza","oracle","passionate","restoration","script","shell","skill","sla","sparkql","sql","technology","teradata","migration"],"maxexperience":5,"minexperience":2,"noticePeriod":"30","jobPostApprovedDate":"2021-10-12T11:07:49.796Z","jobPostingApprovedBy":"impetusshenzyn@gmail.com"}},"companyData":{"status":true,"message":"Company found","data":{"emailIdVerified":true,"womenCentricPolicies":["Transportation","Paternal Leaves","Social Activities","Work from Home"],"jobsPosted":["71463528","89652150","83617347","44230448","94978509","57474915"],"promotedJobs":false,"profileStatus":true,"accountStatus":true,"landingPagePublish":true,"testCompany":false,"profileCompletionPercentage":"100%","contractAttachedStatus":false,"permissions":[],"contract":[],"emailId":"impetusshenzyn@gmail.com","username":"impetusshenzyn@gmail.com","companyName":"Impetus","logo":"https://shenzyn-uploads.s3.ap-south-1.amazonaws.com/ProfilePics/impetusshenzyn%40gmail.com_impetus-social-logo.png","coverPhoto":"https://shenzyn-uploads.s3.ap-south-1.amazonaws.com/Assets/defaultCoverPicture.png","wrongPasswordCount":0,"address":"Tower 14 B, SEZ Pritech Park, Bengaluru - 560103 (Karnataka) India","contactNo":"8049316000","country":"India","countryCode":"+91","gstin":"29AAACI7445L1Z4","industry":"Information Technology & Services","location":"Bangalore Urban, Karnataka","pincode":"560103","sacorhac":null,"website":"http://www.impetus.com","aboutus":"Impetus Technologies is focused on enabling a unified, clear, and present view for the intelligent enterprise by enabling data warehouse modernization, unification of data sources, self-service ETL, advanced analytics, and BI consumption. For more than a decade, Impetus has been the 'Partner of Choice' for several Fortune 500 enterprises in transforming their data and analytics lifecycle. The company brings together a unique mix of software products, consulting services, and technology expertise. Our products include industry’s only platform for the automated transformation of legacy systems to the any modern or cloud-native stack and Gathr – a self-service ETL and machine learning platform.","additionalMaternityBenefits":null,"companyType":"Large","culture":"It is an awesome place where we work,enjoy, and grow together, give's us enough material to achieve better in career always makes us up to date with current market pays handsomely, they make us feel at home it's like a family","employeeStrength":"2500","genderDiversity":null,"otherBenefits":null}},"recommendedJobs":[{"jobId":17541474,"jobDet":{"element":{"contentModerationStatus":false,"jobLocation":[],"dniCategory":[],"employementType":["FullTime"],"salaryHide":false,"industries":[],"functionalArea":[],"languagesKnown":[],"certificationRequired":[],"skills":[],"recepientEmailAddress":["princeprabhakar1985@gmail.com"],"forwardApplication":["princeprabhakar1985@gmail.com"],"status":"PendingApproval","listofApplicants":[],"selected":[],"offered":[],"rejected":[],"joined":[],"jobPostingApproved":false,"jobPostingCompletionPercent":"100%","testJobPost":false,"_id":"5edf75332513cd2641e9e7b7","shortListed":[],"educationalDetails":[{"degree":["","MBA"],"_id":"5edf767be9b4562637a861ae","qualification":"Post Graduation","specialization":"Marketing"}],"shortlistedProfiles":[],"jobId":17541474,"companyName":"XYZ India","jobPostedBy":"princeprabhakar1985@gmail.com","jobPostedDate":"2020-06-09T11:40:35.533Z","__v":0,"companyType":null,"jdVideo":"","jobDescription":"We required sales Manager for our company\nMBA with Reputed university\nMust have 5+ Years of experience","jobTitle":"Sales Manager","jobUpdatedDate":"2020-06-09T11:46:36.592Z","logo":"https://shenzyn-uploads.s3.ap-south-1.amazonaws.com/Assets/defaultLogo.png","maxannualCTC":"200000","minannualCTC":"100000","otherMonetoryBenefits":"","travelRequired":true,"vacancies":"10","extractedSkills":["year","sale","require","repute","mba","manager"],"jobPostApprovedDate":"2020-06-09T11:40:35.533Z","profilesByPartner":[],"discussionThread":[]},"matchPct":0.5414777398109436}},{"jobId":43742209,"jobDet":{"element":{"contentModerationStatus":false,"jobLocation":["Pune, Maharashtra"],"dniCategory":[],"employementType":["FullTime"],"salaryHide":false,"industries":["Others"],"functionalArea":["Others"],"languagesKnown":["English"],"certificationRequired":[],"skills":["ORMB ","Transaction Feed Management","SQL "],"recepientEmailAddress":["Ashwin.n@shenzyn.com"],"forwardApplication":["Shraddha.a@shenzyn.com"],"status":"Active","listofApplicants":[],"selected":[],"offered":[],"rejected":[],"joined":[],"jobPostingApproved":true,"jobPostingCompletionPercent":"100%","testJobPost":false,"_id":"5f48d7c446dcc04b989e4795","educationalDetails":[{"degree":["","B.C.A"],"_id":"5f48deca46dcc04b989e4799","qualification":"Graduation","specialization":"Any relevant "}],"profilesByPartner":[],"shortlistedProfiles":[],"jobId":43742209,"companyName":"Hexaware","jobPostedBy":"hexaware@gmail.com","jobPostedDate":"2020-08-28T10:09:08.745Z","__v":0,"companyType":"Large","jdVideo":"","jobDescription":"Hexaware Technologies is looking for ORMB Developer\nThe candidate will play a pivotal role in design, development, configuring and testing of applications to improve the effectiveness and efficiency of the Finance business functions. In this mission critical role the candidate will design, develop, implement and test solutions, and will be responsible for getting them into production with very high quality, completing all test phases\nKey Responsibilities and Requirements\n \n• Experience in design, configuration and testing of ORMB (Oracle Revenue Management and Billing) solutions for finance and banking application\n• Solid understanding of ORMB/CC&B functionalities and data models (Transaction Feed Management, Rules Engine, Billing, Rating, Pricing, GL, Payments, Credit/Collections, Accounts Payable and Accounts Receivables).\n• ORMB Configuration experience with setting up Customer Information, Rate Schedules, Approval Workflow, Pricing, TFM (Transaction Feed Management) Rules, service scripts and User interfaces like portals, zones and UI maps is a big plus.\n• Experience in evaluating business requirements, creating functional, and solution designs.\n• Experience working with business to clarify and elaborate the requirements and turning them into comprehensive test scenarios.\n• Experience preparing test data based on the business scenarios and writing tools to prepare test data.\n• Demonstrated knowledge of RDBMs and SQL with experience in building database queries based on the understanding of the data model.\n• Need to have hands on experience in analyzing large volume data to validate test results, find problem trends and do root cause analysis.\n• Must have experience in debugging and troubleshooting problems in functionally complex Java based applications.\n• Strong experience in production support related activities is a MUST.\n• Business domain knowledge in the areas of financial applications, billing, general ledger and accounting practices.\n• Must have proactive and strong communications to work well across teams.\n• Ability to work with teams in multiple geographical locations and time zones is a must.\n• Engage in collaboration activities with business partners and internal teams on configuration and testing requirements (both functional and non-functional) and come up with functional/solution designs and comprehensive test scenarios.\n• Collaborate with business partners on user acceptance testing including data readiness, triaging the defects and ensuring that issues are handled in a timely manner.\n• Work with limited direction, usually within a complex environment, to drive delivery of solutions and meet service levels.\n• Experience with multiple test phases like functional testing, integration testing, performance testing, user acceptance testing and regression testing.\n• This is a hands on and user facing position.\n• Must be self-motivated with ability to work in a fast-paced delivery model.","jobTitle":" ORMB Developer","jobUpdatedDate":"2020-08-28T10:39:08.047Z","logo":"https://shenzyn-uploads.s3.ap-south-1.amazonaws.com/ProfilePics/hexaware%40gmail.com_hexaware-technologies-vector-logo.png","maxannualCTC":"2000000","minannualCTC":"1500000","otherMonetoryBenefits":"","travelRequired":false,"vacancies":"1","maxexperience":10,"minexperience":7,"noticePeriod":"30","jobPostingApprovedBy":"hexaware@gmail.com","extractedSkills":["test","business","data","functional","solution","design","ormb","requirement","management","configuration","scenario","billing","base","application","model","prepare","phase","partner","pricing","problem","zone","multiple","hand","finance","delivery","comprehensive","complex","activity","account","production","acceptance","understanding","testing","transaction","rule","effectiveness","database","debug","defect","trend"],"jobPostApprovedDate":"2020-08-28T10:09:08.745Z","discussionThread":[]},"matchPct":0.6018915176391602}}]}