Closed listing
ETL Developer (Insurance Domain)
- Markham, ON, Canada
Contract
This opening has closed.
The original listing is kept below for reference.
Job details
- Job type
- Contract
- Closing date
- Experience
- Minimum 5-7 years of experience successfully leading ETL data reconciliation, with expertise working with large-scale enterprise data models
- Posting language
- English
- Posted
Similar jobs hiring now
Search current openingsOriginal job description
Archived listing. The details below describe a past opening.
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
More about this job
Responsibilities
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.
Skills
- 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
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Software
- Finance & Accounting
Keywords
- ETL
- Data Reconciliation
- Informatica PowerCenter
- Informatica PowerExchange
- ANSI SQL
- Advanced SQL
- Hadoop
- Enterprise Data Models
- Data Landing
- Billing Data Mart
- Data Validation
- Relational Data Models
- Dimensional Data Models
- Data Vault
- Business Intelligence
- Insurance
- Data Technology
- Business Processes
- Troubleshooting
- Teamwork
- Communication
- Consultation
- Consensus Building