Data Engineer
Posted Updated
Summary
Senior data engineer (10-12 yrs) leading data migration for a Life Insurance Core Policy Administration System: designing migration rules, building ODI 12c/Oracle PL-SQL ETL (plus Spark/Python), ensuring data quality, and managing a delivery team.
Job Purpose
Key Responsibilities
Major Challenges
Required Skills & Experience
Educational Qualifications
Work Experience
Preferred Technical Skills
The candidate will be responsible for managing data migration activities for the Core Policy Administration System. The role requires expertise in rule-based data transformation, Life Insurance domain knowledge, ODI, and Oracle PL/SQL. The candidate should be capable of independently handling migration activities, understanding business rules, coordinating with product and business teams, identifying migration risks, and ensuring data quality and consistency.
Key Responsibilities
- Project Management
- Participate in discussions with functional owners to understand requirements and execute milestone-based project plans.
- Prepare solution designs based on business requirements and conduct design reviews.
- Perform performance tuning and code reviews.
- Allocate projects to Team Leads based on workload and skill sets.
- Ensure timely completion of development, unit testing, and code reviews.
- Coordinate with testing teams for UAT and smoke testing.
- Verify development and testing completion before deployment approvals.
- Maintain project trackers and conduct periodic reviews for successful delivery.
- Data Migration Support
- Design data structures, facts, and dimensions.
- Understand source systems and reporting data requirements.
- Perform data mining and descriptive analytics for reporting.
- Ensure compliance with financial reporting checklists.
- Ensure accurate data integration from multiple data sources.
- Redesign data replication processes from source systems to EDW.
- Perform data transformation using ODI ETL, Oracle PL/SQL, Spark, and Python.
- Develop reusable and scalable migration solutions.
- Manage ticket delivery within agreed timelines.
- Ensure quality delivery across migration activities.
- Team Development
- Allocate and review daily tasks with team members.
- Conduct knowledge transfer and training sessions.
- Participate in recruitment and talent identification.
- Define and review individual performance metrics.
- Identify growth and development opportunities for team members.
- Ensure delivery quality and team productivity.
Major Challenges
- Managing migration across changing target platform versions.
- Defining migration rules with business SMEs.
- Handling replication across heterogeneous data sources.
- Ensuring 100% data consistency.
Required Skills & Experience
Educational Qualifications
- Graduate and above.
- Hands-on experience in ODI 12C or Oracle PL/SQL transformations.
- Experience in Life Insurance data migration projects.
- Strong knowledge of Oracle SQL/PLSQL and data transformation techniques.
Work Experience
- 10 to 12 years of relevant experience.
- Mandatory experience in Life Insurance data migration.
- Knowledge of Life Insurance Policy / Contract Administration Systems.
- Experience working with multiple databases.
- Expertise in rule-based data transformation for migration.
- Strong experience in ODI12C and Oracle SQL/PLSQL.
Preferred Technical Skills
- ODI 12C
- Oracle SQL
- PL/SQL
- Spark
- Python
- ETL Development
- Data Modeling
- Data Warehousing
- Performance Tuning
