Search all career opportunities

Data Engineer - Informatica Cloud, Omnia AI

Apply now

Apply for Job

Date Posted: Nov 24, 2021

Reference Code: 84821-en_US

Job Type: Permanent 
Primary Location: Multiple Locations, Canada 
All Available Locations: Toronto; Calgary; Montreal; Ottawa; Vancouver 

Learn from deep subject matter experts through mentoring and on the job coaching
Partner with clients to solve their most complex problems
Be empowered to lead and have impact with clients, our communities and in the office.

Do you have passion for Analytics and advanced Data Management? Do you want to build solutions that will allow customers to go further with the best of the existing Cloud solutions? Are you enthusiastic about all things data, have strong problem-solving and analytical skills and have a solid understanding of software development life cycle, then we have an opportunity waiting for you!

What will your typical day look like?

As a Data Engineer – Informatica Cloud Specialist within our Data Modernization & Analytics team in our Omnia AI practice, you will be a team player to a portfolio of Deloitte’s Omnia AI engagements (projects). You will have the opportunity to be involved in the full software development lifecycle of AI projects requiring IICS solutions, which includes contributing in proposal development and pursuit assistance, project delivery, and internal projects aiming to leverage top data management and data quality applications.

Specifically, you will:

  • Work with cross-functional stakeholders including IT representatives, business leaders and analytics and data management community to understand data quality challenges and identify solutions for remediation.
  • Prepare the plan, lead small development and testing team and mentor junior colleagues to deliver quality and on-time solution in Agile/Hybrid Agile methodology.v

About the team

Omnia AI, Deloitte’s Artificial Intelligence (AI) practice is comprised of a collaborative team of experts who use their hands-on experience with cutting-edge information assets to facilitate successful AI transformations. We develop AI-enabled solutions to address all aspects of a client’s transformative journey with disciplined focus on business outcomes.

Our Data Modernization & Analytics team helps clients design and implement the data platform architectures – be it in the cloud or on-premise – required to enable cutting-edge AI solutions. You will be part of a practice to deliver a breadth of solutions to solve our clients most challenging business problems, with a focus on Big Data, BI/DW, Data Integration, Data Governance, Master Data and Analytics applications. Each of these applications leverages a different mix of traditional and innovative technologies to achieve business outcomes.

Enough about us, let’s talk about you

You are someone with:

  • Expertise in the Data-warehousing concepts
  • Minimum 5 years of relevant hands-on working experience in Informatica IICS (Data Integration / Application Integration)
  • Experience working in at least one RDBMS like Oracle, Teradata, SQL Server, DB2
  • Knowledge of shell scripting in Linux/Unix environment (desirable)
  • Performance Improvement skills on Informatica / RDBMS (desirable)
  • Participated in different kinds of testing like Unit Testing, System Testing, User Acceptance Testing
  • Participated in at least one end-to-end implementation of Data-warehouse / BI solutions
  • Integration knowledge using Application Integration for Pub/Sub model
  • Developed and maintained advanced database systems including data warehouses, data marts, and models needed for business, financial and operational analysis and/or reporting
  • Developed data integration between various source/target systems comprises of Oracle ERP,, Flat files, webservices, REST and SOAP based API’s JSON / Kafka.
  • Experience in Administration / installation of Secure Agents, connection / log reviews
  • Experience to identify and resolve performance bottlenecks and optimize integrations
  • Good communication skills and experience in onsite-offshore model

If you believe you have what it takes to be a successful member of our team, please apply now. We know your career is important to you and it's important to us, too. This role is just the first step of a highly successful career we can help you build.

The time is right for you to join Deloitte. Get your career off to great start. What impact will you make?

Why Deloitte?

Launch your career with The One Firm where you can make an impact that matters in a way that you never thought possible. With endless opportunities at every turn, and a culture built to support and develop our people to be the very best they can be, Deloitte is The One Firm for you to learn, grow, create, connect, and lead. We do this by making three commitments to you:

  • You will lead at every level: We grow the world’s best leaders so you can achieve the impact you seek, faster.
  • You can work your way: We give you the means to be flexible in how you need and want to work, and we have innovative spaces, arrangements and the mindset to help you be wildly successful.
  • You will feel included and inspired: We create a deep sense of belonging where you can bring your whole self to work.

The next step is yours

Sound like The One Firm. For You?

At Deloitte we are all about doing business inclusively – that starts with having diverse colleagues of all abilities!  Deloitte encourages applications from all qualified candidates that represents the full diversity of communities across Canada. This includes candidates from Indigenous communities in support of living our values and our commitments to our Reconciliation Action Plan . We encourage you to connect with us at if you require an accommodation in the recruitment process, or need this job posting in an alternative format. We’d love to hear from you!

By applying to this job you will be assessed against the Deloitte Global Talent Standards. We’ve designed these standards to provide our clients with a consistent and exceptional Deloitte experience globally.


Deloitte Canada has 30 offices with representation across most of the country. We acknowledge our offices reside on traditional, treaty and unceded territories as part of Turtle Island and is still home to many First Nations, Métis, and Inuit peoples. We are all Treaty people.

Apply now

Apply for Job