ETL Developer

Round 1: Online aptitude test (logical reasoning, quantitative & verbal) → Round 2: Technical interview (ETL concepts, SQL, Informatica tools, scenario‑based questions) → Round 3: HR interview (fitment, communication, career goals)

The Capgemini interview process typically starts with a timed online aptitude test, followed by a technical interview focusing on ETL concepts, SQL queries, and Informatica tool usage. The final HR round assesses cultural fit and communication skills. Candidates report moderate difficulty, with emphasis on practical scenario questions; thorough preparation of data warehousing fundamentals and mock coding sessions is highly recommended.

Capgemini promotes a learning‑first culture where employees are encouraged to upskill through internal academies and certifications. The Bengaluru office offers a balanced work‑life environment with flexible timings, regular tech talks, and opportunities to work on global projects, fostering both personal and professional growth.

Graduates (B.Tech/B.E./MCA) in Computer Science, Information Technology, Electronics & Communication or related streams; minimum 60% aggregate (or CGPA 6.5/10); batch years 2024‑2026; no active backlogs at the time of joining; strong academic record in databases and programming.

Capgemini is a global leader in consulting, technology services and digital transformation. With a presence in over 50 countries, the company helps enterprises re‑imagine their business through innovative solutions and a strong focus on sustainability. In India, Capgemini has built a reputation for nurturing fresh talent, offering structured learning programs, and providing exposure to cutting‑edge technologies across domains such as banking, retail, and healthcare. The Bengaluru office, often referred to as the company’s innovation hub, hosts a vibrant community of engineers, data scientists and solution architects who collaborate on large‑scale data platforms for Fortune‑500 clients. The role of an Informatica Developer at Capgemini Bengaluru is centered on designing, developing, and maintaining robust ETL pipelines that feed enterprise data warehouses and analytical data marts. The candidate will work closely with solution architects, business analysts and quality engineers to translate business requirements into scalable data integration solutions. This position offers a blend of hands‑on technical work and strategic involvement in data‑driven projects, making it ideal for fresh graduates eager to start a career in data engineering. Key Responsibilities: 1. Develop end‑to‑end ETL workflows using Informatica IICS and PowerCenter. 2. Implement performance tuning techniques to optimise data load times and resource utilisation. 3. Design and build fact and dimension tables, applying Slowly Changing Dimension (SCD) Type‑II logic where required. 4. Write, review and optimise complex SQL queries for Oracle, DB2 and Teradata environments. 5. Prepare detailed ETL specification documents and collaborate with testing teams for functional and regression testing. 6. Configure and manage job scheduling using tools such as ESP, Control‑M and Autosys. 7. Participate in requirement‑gathering sessions with business users and IT stakeholders to ensure data solutions meet functional expectations. 8. Provide ongoing support for ODS/EDW environments, troubleshoot production issues and implement corrective actions. 9. Contribute to code reviews, knowledge‑sharing sessions and continuous improvement initiatives. 10. Stay updated with emerging data integration technologies and suggest enhancements to existing pipelines. Tech Stack: Informatica IICS, Informatica PowerCenter, SQL, Oracle, DB2, Teradata, UNIX shell scripting, ESP/Control‑M/Autosys, Business Objects, Tableau. Growth Path: Freshers start as Junior ETL Developers, progress to Senior Developer, then to Data Integration Lead or Solution Architect. Capgemini’s internal learning portals, certifications (e.g., Informatica PowerCenter Specialist) and mentorship programs accelerate career growth. Why Join Capgemini? The company offers a structured onboarding program, exposure to global clients, and a collaborative culture that values continuous learning. Employees benefit from flexible work arrangements, competitive compensation, and a clear path to leadership roles within the data engineering domain.