FBS Associate Data Engineer
capgemini-insurance · Pune
Job description
About the role
A junior data engineer on the BW SOON Data Team in Pune works on the analysis of data from multiple source systems and helps build data marts based on business requirements, under the guidance of senior team members. The workplace is hybrid and the department is listed as Information Security.
Key responsibilities
- Analyze data from source systems and help develop data marts and data models, including STTMs and technical documentation.
- Develop, monitor and support ETL/ELT pipelines, with intermediate experience using Oracle Data Integrator (ODI).
- Assist in building data warehouse and data mart solutions, including data lineage documentation.
- Analyze and profile data from DB2, Oracle and distributed data platforms.
- Write queries, troubleshoot and perform basic performance tuning.
- Investigate and resolve production issues, data quality concerns and performance bottlenecks, with basic incident support and root cause analysis.
- Support data quality controls, reconciliation processes and metadata management, with awareness of data security, access controls, PII protection and compliance.
- Support cloud modernization and data migration initiatives; exposure to AWS and Azure is a plus.
Required profile
- Solid data analytics and technical fundamentals.
- Good communication skills and the ability to understand design requirements and existing business processes.
- Ability to collaborate with business partners and senior engineers on data product design, development and implementation.
- Willingness to learn and grow technical and stakeholder-facing abilities.
Required skills
- Intermediate experience with Oracle Data Integrator (ODI)
- Intermediate SQL and Oracle PL/SQL, including query writing, troubleshooting and basic performance tuning
- Data modeling: dimensional modeling (Kimball), Third Normal Form, Data Vault and Medallion architecture
- Basic Python for data integration and automation
- Plus: Snowflake, DBT, Fivetran, Airflow, GitHub
What we offer
- Competitive salary and performance-based bonuses
- Comprehensive benefits package, private health insurance and pension plan
- Career development and training opportunities
- Flexible work arrangements (remote and/or office-based)
- Paid time off
Questions fréquentes
Why are you reporting this job?
Explore further
Salaries, guides and searches in India.
Salaries by job title
Apply in 30 seconds
Enter your email to apply. An account will be created automatically.
By continuing, you accept our terms of use.
Already have an account? Login
A question about this job?
Ask it here: you will get the full job summary by e-mail, right away.
Published 21 hours ago
Expires 1 month from now
9 views · 0 interested
Boost your chances
Upload your CV — we will match you with relevant openings.
Analyzing your CV...
capgemini-insurance
Pune