Senior Data Engineer (ITSO) – BW SOON Data Team
capgemini-insurance · Pune
Job description
About the role
A Senior Data Engineer on the BW SOON Data Team analyzes data from multiple source systems and designs and models data marts according to business requirements. The role sits in the Information Security department, works in a hybrid workplace and calls for strong data analytics and technical skills, good communication and the ability to partner with business partners and data scientists.
Key responsibilities
- Analyze data from multiple source systems and design and model data marts
- Create data models, STTMs and other technical documentation
- Design, develop, monitor and support ETL/ELT pipelines for large volumes of enterprise data
- Build enterprise data warehouse and data mart solutions, including data lineage documentation
- Analyze and profile data from DB2, Oracle and distributed data platforms
- Investigate and resolve production issues, data quality concerns, performance bottlenecks and SLA risks
- Collaborate with business partners to turn requirements into scalable data solutions and guide data architecture and integration strategies
- Implement data quality controls, reconciliation, metadata management and governance standards, and support cloud modernization and data migration
Required profile
- Experience in production support, incident management and root cause analysis
- Strong communication, documentation, stakeholder management and cross-team collaboration skills
- Intermediate Python skills for data integration, automation and analytics
- Preferred: hands-on experience with AWS and Azure, and intermediate Snowflake, DBT and orchestration/version-control tools such as Fivetran, Airflow and GitHub
Required skills
- Oracle, ODI (Oracle Data Integrator) and PL/SQL
- Advanced SQL and Oracle PL/SQL, including performance tuning
- Data modeling: dimensional modeling (Kimball), 3NF, Data Vault and Medallion Architecture
- Data quality controls, metadata management and data security and compliance
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 19 hours ago
Expires 1 month from now
8 views · 0 interested
Boost your chances
Upload your CV — we will match you with relevant openings.
Analyzing your CV...
capgemini-insurance
Pune