Test description
","short_description":"Established in 1990, Infogain is a human-centered digital platform and software engineering company specializing in digital transformation, experience design, and advanced software engineering services. Headquartered in Los Gatos, California, USA, Infogain serves clients across various industries, including retail, travel, and healthcare, helping them navigate the complexities of the digital landscape.
","about_us":"Established in 1990, Infogain is a human-centered digital platform and software engineering company specializing in digital transformation, experience design, and advanced software engineering services. Headquartered in Los Gatos, California, USA, Infogain serves clients across various industries, including retail, travel, and healthcare, helping them navigate the complexities of the digital landscape.
","video_link":null,"logo_url":"https://talent500-public-prod-cb.s3.ap-south-1.amazonaws.com/company_logos/New_logoWhite_f3828439e996457db7531ecf9769a3ab.png","job_logo":"uploads/company_images/infogain_jobs-logo.jpeg","job_logo_url":"https://talent500-public-prod-cb.s3.ap-south-1.amazonaws.com/company_job_logos/T500_nogoTz6_a4600b31ac8d42be8fc807e2392f2e0d.png","show_powered_by_talent500_logo":true,"website":null,"redirect_logo_url":"https://talent500.com//joblist/?search_term=Infogain","linkedIn":null,"facebook":null,"twitter":null,"instagram":null,"hero_type":"1","nav_bar_color":null,"nav_items_color":"#FFFFFF","gallery_heading":"Gallery","company_image_url":"","meta_title":null,"meta_description":"","hero_h1":"Engineering Business Outcomes","hero_h2":"Specializes in digital transformation- Offers services in cloud, experience design, and analytics- Serves clients in industries like retail, travel, and healthcare","primary_color":"#FF9900","secondary_color":"#333333","cta_text":null,"jobs_subtitle":null,"mission":null,"stack_section_title":null,"stack_section_description":"","powered_by_logo_url":"https://d36dj8u11ystvj.cloudfront.net/Talent500_PoweredBy+(1).png","cta_bg_color":"#FFFFFF","cta_text_color":"#2E3084","cta_border_color":"#FFFFFF","h1_font_size":null,"h2_font_size":null,"h3_font_size":null,"h4_font_size":null,"body_size_1":null,"body_size_2":null,"h1_font_w":null,"h2_font_w":null,"h3_font_w":null,"h4_font_w":null,"body_w_1":null,"body_w_2":null,"public_name":null,"use_public_name":false,"unique_id":"d27e85fb-fb33-11ef-ab86-0a892d3d843c","head_favicon_url":"","head_title":null,"privacy_policy_name":"Privacy Policy","privacy_policy_url":null,"mandate_privacy_policy":null,"ticker_title":null,"publish":true,"company_font_family":"5","use_company_font_on_jobs_page":true,"gallery_section_name":null,"about_section_name":null,"testimonial_section_name":null,"benefits_section_name":null,"culture_section_name":null,"jobs_section_name":"Jobs Openings","is_job_displayable":true,"is_onboarding_skip":false,"company_specific_workflow":0,"third_party_company":true,"is_vendor_third_party_company":true,"priority_order":0,"order_of_about_role":1,"order_of_about_company":2,"whatsapp_company_logo":null,"whatsapp_company_logo_url":null,"whatsapp_job_bg_color":null,"whatsapp_job_text_color":null,"engagement_type":null,"font_family":5},"location":"Noida, Gurgaon, Bengaluru, Mumbai, Pune","primary_skills":["AWS","Data Modeling","Database security","Linux","Memory Management","Oracle","Query Optimization","SQL","bash","databases","python","shell"],"secondary_skills":[],"experience_range":"11 - 15 years","job_qualifications":[""],"screening_questions":[],"title":"SQL Developer (Lead)","description":"Job Description:-Should have Experience- 7-11 yearsMust have Solution/architectural Design and Development experienceReady to work as an individual contributor/developerMust have knowledge and Strong hands on in PL/SQLo Developmento Debuggingo Performance Tuning and OptimizationMust have indepth knowledge of Oracle/PL SQL Packages, Functions, triggers, Collections, Bulk Data loading methods, Data Migration, Materialized Views and Partitioning.Strong Development experience with Packages, Functions, triggers, Collections, Bulk Data loading methods, Data Migration, Materialized Views and Partitioning.Must know advance features of 11g/12c Oracle DB Databaseo Oracle RDBMS architecture.Oracle supplied packageso Data Modeling/Designo Database security models ToolsHaving knowlege on MSSQL/PostGres will be a plusMust have worked ono Oracle OnPrem to AWS migrationso AWS Lambdao AWS RDSMust have experience with creating and supporting large batch jobsMust have experience in shell scripting korn/bash and python on LinuxAbility to pick up business concepts very quicklyMust have Query Optimization and Memory Management ExperienceMust have worked as individual contributorMust have handedled big enterprise grade large databases single handedlyMust have Good communication skills.Must be ready to work in the India Night Shift or Near shore location.","employment_type":null,"industry":"","job_template":false,"country":{"name":"India","country_code":"IN","region":"Asia"},"is_job_displayable":true,"job_url":"https://talent500.com/jobs/infogain/sql-developer-lead-any-infogain-base-location-noida-gurugram-bangalore-mumbai-pune-T500_IG_91156","created_at":"2025-05-05T22:21:13.327381+05:30","updated_at":"2025-05-16T20:00:55.526874+05:30","title_alias_1":null,"slug":"sql-developer-lead-any-infogain-base-location-noida-gurugram-bangalore-mumbai-pune-T500_IG_91156","summary":null,"typical_workday":null,"what_you_offer":null,"what_you_need_to_succeed":null,"responsibilities":"","type":null,"min_experience_years":11,"max_experience_years":15,"ctc_unit":"LPA","is_featured_job":false,"is_active":true,"job_code":"T500_IG_91156","external_id":null,"external_job_code":null,"is_anonymized":false,"mercurial_skills":null,"open_date":"2025-05-05T22:21:13.318559+05:30","published_at":null,"anonymization_needed":null,"anonymized_description":null,"xml_feed_anonymization":null,"unregistered_user_anonymization":null,"registered_user_anonymization":null,"pre_application_email_anonymization":null,"mettl_account":null,"job_table_sub_head":null,"job_table_short_desc":null,"is_remote":false,"job_video":null,"job_video_title":null,"job_video_description":null,"job_image_url":null,"role_summary":null,"syndication_control":true,"syndication_status":"new","syndication_job_title_alias":null,"sourcing_requirements_updated_at":null,"t500_sourcing_control":true,"status":"open","job_redirection_url":"https://www.infogain.com/careers/jobID=TH210325_91156","is_external_job":true,"is_leadership_job":false,"leadership_confidentiality_level":null,"pricing_type":null,"is_auto_apply_eligible":false,"external_apply_url":null,"ats_provider":null,"apply_timeout_seconds":null,"recruiter":"1154daea-f24c-4f7f-aad6-494543ee6112","category":11,"job_sub_category":92,"role":null,"job_function":null,"job_sub_function":null,"naukri_industry":null,"naukri_functional_area":null,"naukri_role":null,"role_category":null,"linkedin_industry":null,"syndication_partners":[],"candidate_job_status":null,"candidate_job_id":null,"mettl_assessment_to_be_taken":false,"company_font_data":{"font-family":"Montserrat","url":"https://fonts.googleapis.com/css2?family=Montserrat:ital,wght@0,100;0,200;0,300;0,400;0,500;0,600;0,700;0,800;0,900;1,100;1,200;1,300;1,400;1,500;1,600;1,700;1,800;1,900&display=swap"}}