FBS Associate Data Engineer

Capgemini is hiring a Jr/Associate Data Engineer for the BW SOON Data Team. The role supports analysis of data from multiple source systems and assists in developing data marts and data products under the guidance of senior engineers. Key Responsibilities: Develop, monitor, and support ETL/ELT pipelines using Oracle Data Integrator (ODI). Assist in developing data warehouse and data mart solutions. Create data models, STTMs, technical design documents, and data lineage documentation. Analyze and profile data from DB2, Oracle, and distributed data platforms. Develop and troubleshoot SQL and Oracle PL/SQL queries. Perform basic SQL and database performance tuning. Work with dimensional modeling using Kimball methodologies. Understand Third Normal Form (3NF/TNF), Data Vault, and Medallion Architecture concepts. Investigate production issues, data-quality problems, and performance bottlenecks. Support incident management and root-cause analysis. Collaborate with business partners and senior engineers to understand requirements. Support data-quality controls, reconciliation, and metadata management. Follow data security, access-control, PII protection, and compliance requirements. Support cloud modernization and data migration initiatives. Use Python for data integration and automation tasks. Work with Snowflake, dbt, Fivetran, Airflow, and GitHub where applicable.

REQUIREMENTS Required Skills Oracle Oracle Data Integrator (ODI) SQL Oracle PL/SQL ETL / ELT Data Engineering Data Warehousing Data Marts Data Modeling Kimball Dimensional Modeling Third Normal Form (3NF/TNF) Data Vault Medallion Architecture Data Profiling Data Quality Data Reconciliation Metadata Management Data Lineage Production Support Root Cause Analysis Python GitHub Preferred / Good-to-Have Skills Snowflake dbt Fivetran Apache Airflow AWS Azure Cloud Data Migration Cloud Modernization Distributed Data Platforms DB2 Performance Tuning Data Security PII Protection Compliance