ETL Developer (Insurance Domain)

Job summary

Lead ETL data reconciliation and build ETL workflows using Informatica PowerCenter. Troubleshoot data landing issues affecting the billing data mart and validate data across complex enterprise models and business processes.

Job details

Job Title: ETL Developer Location: Markham, ON (Hybrid) Type: Contract Job description Primary Skills Minimum 5-7 years of experience successfully leading ETL data reconciliation, with expertise working with large-scale enterprise data models Experience in building ETL workflows using Informatica PC Advanced SQL knowledge Troubleshoot issues in data landing to billing data mart Solid grasp and experience with data technology tools: Informatica, Hadoop, SQL, etc Experience working with relational, dimensional, and data vault data models Proven expertise in data validation Ability to foundationally understand complex business processes driving technical systems Ability to work in a fast-paced environment Ability to work both independently and as part of a team Secondary Skills Knowledge of Business Intelligence products Insurance knowledge an asset Soft Skills Excellent teamwork and communication abilities Excellent oral and written communication abilities Excellent consultative facilitative and consensus-building abilities Skills Mandatory Skills: ANSI-SQL, Informatica PowerCenter, Informatica Power Exchange We are an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees

What you’ll do

Lead ETL data reconciliation and build ETL workflows using Informatica PowerCenter. Troubleshoot data landing issues affecting the billing data mart and validate data across complex enterprise models and business processes.

Requirements

Requires 5–7 years of experience leading ETL data reconciliation, advanced SQL skills, and experience with Informatica PowerCenter and large-scale enterprise data models. Candidates should understand relational, dimensional, and data vault models, demonstrate strong data validation and communication skills, and be able to work independently and collaboratively; insurance knowledge is an asset.

Listed skills

• Teamwork · Preferred
• Data Validation · Preferred
• Communication · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• ANSI SQL
• Informatica PowerCenter
• Informatica PowerExchange
• ETL Data Reconciliation
• ETL Workflow Development
• Advanced SQL
• Data Validation
• Data Troubleshooting
• Hadoop
• Relational Data Modeling
• Dimensional Data Modeling
• Data Vault Modeling
• Business Intelligence
• Insurance Domain Knowledge
• Communication
• Teamwork

Job areas

• Technology
• Data & Analytics
• Software
• Finance & Accounting

More jobs from Enterprise Solutions Inc.