BI-Informatica Developer
System Canada Technologies
Company Description
SCT resources have a broad range of skills in different technologies. The large skill-set has been made possible by a conscious focus on strengthening our skills base. Every person selected for our team brings something new, something that adds to our offerings. We learn continuously, both on the job and through formal training programs.
Job Description
Job Responsibilities:
Create, tuning and testing complex ETL processes for large and complex OLAP/OLTP data sets
Create and maintain Informatica 8.x/9.x workflows
Create ETL processes from business requirements.
Participate in requirement meetings with end-users to understand and collect requirements.
Validate the accuracy of business rules and transformations
Informatica
Strong knowledge of HealthCare industry, a plus
8.6 and 9.x suite of products
Expertise in the entire PowerCenter suite (Repository Manager, Designer, Workflow Manager, and Workflow Monitor)
Conforming and merging data from multiple data source types (ie MSSQL, Oracle, flat files, etc.)
o Incrementally loading large tables with complex keys
o Using transformations to implement complex business rules
Workflow management
o Designing incremental load logic
o Error handling
o Using Informatica to restart failed jobs
o Tracking performance and job status and job scheduling
Performance tuning
o Workflow optimization
o Mapping optimization
o Transformation optimization
ETL documentation
o Experience using ASG-Rochade is a plus
Oracle
Experience with Oracle 11g preferred
Experience writing complex SQL queries against large data sets
Query optimization (indexing, partitioning, Oracle configuration, etc.)
o Experience capturing and interpreting Oracle performance based statistics is a plus
Creating, modifying and optimizing stored procedures and packages
Familiarity with dimensional models and Operational Data Stores
Experience gathering and implementing business rules
Experience reconciling data output to existing reports and source data
Excellent oral and written communication
Self Starter who takes initiative
- Company Description SCT resources have a broad range of skills in different technologies. The large skill-set has been made possible by a conscious focus on strengthening our skills base. Every person selected for our team brings something new, something that adds to ...SuggestedFull timeWork at office
- ...adds to our offerings. We learn continuously, both on the job and through formal training programs. Job Description SAS BI Report Developer SAS BI Report Developer will be responsible for developing reports. Should have demonstrated experience in using DI...SuggestedFull timeContract work
- ...L'Analyste BI sera responsable de concevoir, développer et optimiser des tableaux de bord et rapports d'affaires dans un environnement combinant SQL, Power BI et SAP BusinessObjects, en contribuant à des projets de transformation touchant les données financières de l'organisation...SuggestedFull time
- ...Java and GCP. Analyze, understand, and modernize legacy applications, including Oracle Stored Procedures and Informatica PowerCenter workflows. Design and develop scalable microservices using Java, Spring Boot, and cloud-native technologies. Build and optimize SQL...SuggestedFull time
- ...wide risk management applications. We are currently looking for a developer to joing Risk 1 - firm's end of day market risk repository. The... ...Have) - Minimum 2+ years of Java. - Minimum 2+ years Informatica. - Database skills: SQL, Stored procedures - Data structures...SuggestedFull timeWork at office
- ...utilities modernize the way they serve their communities. As a Data Developer, you’ll play an important role in turning data into meaningful... ...Experience with data visualization tools like Metabase, Tableau, or Power BI Strong understanding of database design, data modelling, and...Remote jobFull timeFlexible hours
- ...Description • Primary Skills: Cognos Series 7 (Power Play, Impromptu and Transformer), VBA, Oracle, MS SQL. • Secondary Skills: SAS BI Reporting, MS Sharepoint, Understand AS400 environment. • Good to have: Experience on FRSGlobal Report Generator or similar tools. •...Full time
$76k - $104.5k per year
...orchestrate high-impact campaigns across programmatic advertising and marketing channels. What You'll Be Doing: Design, develop, and maintain high-quality, modular integrations and automation solutions between internal systems and third-party platforms, including...Full timeLocal areaRemote workWork from homeHome office- ...Responsibilities Design and develop custom applications and APIs using Microsoft Dynamics GP Integrate Dynamics GP with third-party systems... ...Dynamics GP and Power Platform (Power Apps, Power Automate, Power BI) ~ Proven experience customizing Dynamics GP modules ~ Strong...Remote jobFull time
- ...of our multi-billion-dollar parent company. Role Overview Experience Required: 5-6 years Key Responsibilities Design, develop, and maintain business workflows using workflow automation platforms Build reusable workflow components and services Develop...Full time
$90k - $150k per year
...business. Sophos is headquartered in Oxford, U.K. More information is available at Role Summary We are seeking an Anaplan Developer to design, build, and improve planning systems across Sophos’ Sales and Finance Organizations. This role will partner closely with...Long term contractFull timeLocal areaRemote work- ...Title :: .Net Developer Location :: Canada Mode :: Remote Responsibilities Create and maintain ASP.NET web applications with a microservice backend. Collaborate with team members and other groups as part of a multi-disciplinary agile team (Product, Delivery...Full timeRemote work
- ...exposure in java and j2ee Maximo table structure, schemas and relationships, TADDM Installation & DB Configuration on any platform Developing applications using Maximo Application designer Understanding of IBM Websphere application server and Db2/SQL/Oracle Ability to...Full time
- ...the autonomy and flexibility to tackle your role in a way that is right for you. We foster a learning culture that will allow you to develop new skills and progress in your career. Who We Are Flexspring is an iPaaS (Integration Platform as a Service) company specializing...Remote jobFull timeWork from homeFlexible hours
- ...A client in the financial sector is seeking a senior developer to contribute to providing software solutions, delivering stable products, and continuously improving their quality. The role involves analyzing, designing, configuring, developing, maintaining, and evolving...Full time
- ...analysis… Creating data pipelines, versioning and change management Manage the complexity inherent in versioned data pipelines Develop ETL/ELT processes to help extract and manipulate data from multiple sources. Design, build and maintain batch or real-time data...Full timeRemote work
$128k - $200k per year
...functional teams and communicating clearly about tradeoffs, risks, and progress ~ A track record of mentoring or supporting other developers and contributing to a positive, growth-oriented team environment If you don’t meet every single qualification but are excited...Full timeInternshipRemote work- MWDN is a global IT outstaffing company with 23+ years of experience that connects exceptional tech talent with leading companies across Israel, the USA, Great Britain, and Western Europe. We offer opportunities to work on international products in a stable and professional...Full timeFor contractorsFlexible hours
$101.7k - $132k per year
...Implementation Developer, LIMS Remote or Hybrid in Victoria, BC Overview We are seeking an experienced Solution Developer to join Semaphore’s Implementations team, where you will play an important role supporting the technical implementation and customization of Labbit...Full timeRemote workFlexible hoursShift work$158.4k - $247.5k per year
..., Senior Manager of Onboarding product development team at Jane. I've been here for about a year, currently leading a team of eight developers working on a mission that's genuinely different from typical product work. The Onboarding team sits at a critical moment in a clinic...Full timeInternshipRemote work$191.62k - $239.86k per year
...fully distributed, we're backed by Accel, CRV, Insight, Heavybit, and Uncork Capital. Job Description Tailscale is looking for a Developer Relations Engineer to own and improve the developer experience across Tailscale’s expanding product portfolio. You’ll help...Full timeInternshipWork at officeLocal areaRemote workHome officeFlexible hours- Company Description System Canada resources have a broad range of skills in different technologies. The large skill-set has been made possible by a conscious focus on strengthening our skills base. Every person selected for our team brings something new, something that...Full time
- ...backed by the secure infrastructure and scale of our multi-billion-dollar parent company. The Opportunity As a Senior Software Developer , we are looking for the following: Role Overview TELUS Digital is seeking a Senior Software Developer to join our Digital...RemplacementPermanent employmentFull time
- Company Description System Canada resources have a broad range of skills in different technologies. The large skill-set has been made possible by a conscious focus on strengthening our skills base. Every person selected for our team brings something new, something that...Full time
$80k - $90k per year
...What You’ll Do Create engaging training videos using After Effects, Premiere Pro, Camtasia, Audition, and Adobe Creative Suite Develop animations and motion graphics to simplify complex technical topics Collaborate with Instructional Designers and SMEs to translate...Full time- ...Partner - IBM End Customer - TD Bank Role - Java Developer No of Positions - 3 Location - GTA (Hybrid 1s or twice a week as per client's requirement) Price - Find the best possible price Experience - 5+ Yrs Duration - 1 Year contract / full time Timing EST hours JD: experience...Full timeContract work
- ...operators, technicians, and production teams — all building the future of homebuilding together. We’re looking for a Software Developer to join our team and contribute to developing cutting-edge solutions for our core robotic manufacturing technologies. The ideal...Full timeInternshipRelocation packageFlexible hours
- ...continuously, both on the job and through formal training programs. Job Description ~ TV, mobile phone, tablet and other markets. Developed applications will be used as a basis for verifying architecture performance and for providing reference design concepts to handset...Full time
$80k - $100k per year
...manage it with a strong emphasis on architectural discipline, governance, and long-term sustainability. We are hiring a Salesforce Developer who will work closely with our existing platform team and business stakeholders to ensure the platform remains scalable, secure, and...Remote jobOngoing contractLong term contractPermanent employmentFull timeContract workCasual work- ...Description About the Role Our client is seeking a Senior AWS DataHub Developer to design and build real-time, event-driven data services on AWS. This role is developer-first (application-side) rather than infrastructure-led. You will architect and deliver Kafka-based...Full time
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to BI-Informatica Developer. Be the first to apply!
