Senior Software Engineer/Informatica
Core
Designing, developing, and optimizing ETL workflows and data pipelines to power reporting, analytics, and business operations for a reinsurance team.
Role type
Senior Software Engineer (Data Engineering/ETL)
Builds
Robust data solutions, ETL workflows, and data pipelines for reinsurance analytics.
Domain
Insurance / Reinsurance / Data Engineering
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Informatica PowerCenter, Oracle PL/SQL, complex SQL development, query optimization, data integration, job scheduling tools, data mapping, transformation logic design, data validation, performance tuning
Preferred skills
Reinsurance domain knowledge, ProCede or similar reinsurance systems, financial data/policy/claims data, AWS cloud services, AI/ML tools for data quality, Python/Shell scripting
Technologies
Informatica PowerCenter, Oracle, Autosys, AWS, Python, Shell
Responsibilities
Design, develop, and maintain ETL workflows in Informatica; Write, optimize, and troubleshoot complex Oracle PL/SQL procedures, functions, and packages; Analyze business and data requirements and translate them into scalable technical data solutions; Perform data mapping, transformation logic design, and data validation to ensure high data quality; Tune ETL jobs and database queries for performance, scalability, and reliability; Monitor and support ETL jobs, perform root cause analysis, and resolve data issues quickly.
Seniority
Senior, hands-on IC
