{"id":"0ae107b5-41c3-4981-bb4e-0498ad3b9a6f","company":{"id":"1771a46a-13f8-40da-83d0-a747322a09c7","company_stack":[],"company_gallery":[],"company_stats":[],"company_about_section":null,"company_benefit_section":[],"company_testimonial_section":[],"company_culture_section":[],"onboarding_process":null,"ticker_logos":[],"gtn_companies":[],"role_category":[],"cta_color":"#333333","name":"Capgemini","short_name":"CMP954","slug":"capgemini","description":null,"short_description":null,"about_us":null,"video_link":null,"logo_url":"https://talent500-public-prod-cb.s3.ap-south-1.amazonaws.com/company_logos/New_logoWhite_f3828439e996457db7531ecf9769a3ab.png","job_logo":null,"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":false,"website":null,"redirect_logo_url":"https://talent500.com//joblist/?search_term=Capgemini","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":null,"hero_h1":null,"hero_h2":null,"primary_color":"#FF9900","secondary_color":"#333333","cta_text":null,"jobs_subtitle":null,"mission":null,"stack_section_title":null,"stack_section_description":null,"powered_by_logo_url":"https://d36dj8u11ystvj.cloudfront.net/Talent500_PoweredBy+(1).png","cta_bg_color":"#FFFFFF","cta_text_color":"#FFA000","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":"1aad1fa0-6107-4d79-a7d9-ee24a395c8d2","head_favicon_url":"","head_title":null,"privacy_policy_name":"Privacy Policy","privacy_policy_url":null,"mandate_privacy_policy":null,"ticker_title":null,"publish":false,"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":null,"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":"","whatsapp_job_bg_color":null,"whatsapp_job_text_color":null,"engagement_type":null,"font_family":5},"location":"Bengaluru","primary_skills":["Informatica IICS","PowerCenter","data warehousing concepts","performance tuning","SQL","scheduling tools","agile methodologies","SCD Type-II","Oracle","DB2","Teradata","UNIX shell scripting","Business Objects","Tableau","SDLC"],"secondary_skills":[],"experience_range":"","job_qualifications":[],"screening_questions":[],"title":"Informatica Developer","description":"<p>We are seeking an experienced <strong>ETL Developer</strong> with strong expertise in <strong>Informatica IICS (Intelligent Cloud Services)</strong> and <strong>PowerCenter</strong> to design, develop, and optimize data integration solutions. The ideal candidate will have a solid understanding of <strong>data warehousing concepts</strong>, performance tuning, and SQL, along with experience in scheduling tools and agile methodologies.</p><p><br></p><p><strong>Key Responsibilities:</strong></p><p><br></p><ul><li>Develop ETL workflows using <strong>Informatica IICS</strong> and <strong>PowerCenter</strong></li><li>Implement <strong>performance tuning</strong> strategies for ETL processes</li><li>Design and develop ETLs for <strong>fact and dimension tables</strong> using <strong>SCD Type-II</strong></li><li>Write and optimize <strong>SQL queries</strong> for Oracle, DB2, Teradata</li><li>Prepare <strong>ETL specification documents</strong> and collaborate with testers and PMO</li><li>Work with <strong>scheduling tools</strong> like ESP, Control-M, Autosys</li><li>Participate in discussions with business users and IT stakeholders</li><li>Provide support for <strong>ODS/EDW environments</strong> and troubleshoot issues</li></ul><p><br></p><p><strong>Essential Technical Skills:</strong></p><p><br></p><ul><li>Strong <strong>ETL background</strong>, preferably with <strong>IICS experience</strong></li><li>Proficient in <strong>SQL</strong> and database concepts</li><li>Knowledge of <strong>Informatica transformations</strong> and <strong>performance tuning</strong></li><li>Experience with <strong>Oracle</strong>, <strong>DB2</strong>, <strong>Teradata</strong></li><li>Familiarity with <strong>UNIX shell scripting</strong> and utilities</li><li>Exposure to <strong>Business Objects</strong>, <strong>Tableau</strong> (preferred)</li><li>Understanding of <strong>data warehousing concepts</strong> and SDLC</li></ul><p></p>","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/capgemini/informatica-developer-bengaluru-T500_CMP954_15820_4395565651","created_at":"2026-04-03T00:40:00.496887+05:30","updated_at":"2026-04-20T15:00:30.146925+05:30","title_alias_1":null,"slug":"informatica-developer-bengaluru-T500_CMP954_15820_4395565651","summary":null,"typical_workday":null,"what_you_offer":null,"what_you_need_to_succeed":null,"responsibilities":null,"type":null,"min_experience_years":0,"max_experience_years":0,"ctc_unit":"LPA","is_featured_job":false,"is_active":true,"job_code":"T500_CMP954_15820_4395565651","external_id":null,"external_job_code":"15820_4395565651","is_anonymized":false,"mercurial_skills":null,"open_date":"2026-04-03T00:40:00.489456+05:30","published_at":"2026-04-16T05:30:00+05:30","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://click.appcast.io/t/AjzqmsvFnQzK9tKic_ekqQcfEuDTFd5j4tWYsSKDjs62zOyEhRluSo0QAwcyY07iByMh6T4J59c86ituQHd71Q==","is_external_job":true,"is_leadership_job":false,"leadership_confidentiality_level":null,"pricing_type":"cpc","recruiter":"1154daea-f24c-4f7f-aad6-494543ee6112","category":5,"job_sub_category":97,"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"}}