Data Management Consultant

Posted:
12/8/2025, 9:34:41 PM

Location(s):
Mississauga, Ontario, Canada ⋅ Quebec, Canada ⋅ Ontario, Canada ⋅ Montreal, Quebec, Canada

Experience Level(s):
Junior ⋅ Mid Level ⋅ Senior

Field(s):
Consulting ⋅ Data & Analytics

We are:

The Advanced Technology Centers (ATCs) is the engine for reinvention in our clients’ transformation journey. Powered by more than 255,000* people across 24 countries, ATCs will provide our clients with seamless access to industry insights and innovative technology solutions.

Stronger together!

The Advanced Technology Centers (ATCs) make tremendous impact in solving our clients’ business problems leveraging Innovation, Intelligence, Industry insights, new IT and new technology skills. Now, with the global environment changing at a faster pace, our clients are facing unprecedented challenges, and they need us more than ever before. As a Network, ATCs are positioned to unlock greater opportunities and exponential value for our clients.

The value for our clients and our people

For our clients, the Network provides the strength of our geographic diversity, greater resilience, and seamless access to the deepest industry knowledge, the latest in Gen AI solutions, and tech expertise from around the world.

For our people, it brings an opportunity to shape truly boundaryless career paths in a highly collaborative team of experts where they can learn from each other and solve the world’s most complex client challenges.

You are:

An experienced, hands-on Data Management professional with hands-on expertise in Informatica PowerCenter.  You excel at translating complex data into clear, actionable insights through compelling dashboards and visual storytelling.

The Work:

There will never be a typical day and that’s why people love it here. The opportunities to make a difference within exciting client initiatives are unlimited in the ever-changing technology landscape. You will be part of a highly collaborative and growing network of technology and data experts, who are taking on today’s biggest, most complex business challenges using the latest data and analytics technologies.  We will nurture your talent in an inclusive culture that values diversity.  You will have an opportunity to work in all aspects of Data Engineering including Data Ingestion, Storage & Modelling, Transformation, Governance, Quality and Security.

Come grow your career in Technology at Accenture!

Key Responsibilities:

  • Extract data from various source systems — relational databases (Oracle, SQL Server, DB2), flat files, APIs, and cloud platforms.

  • Develop and maintain ETL mappings, sessions, and workflows in Informatica PowerCenter.

  • Implement data mapping specifications and business rules defined by analysts or stakeholders.

  • Collaborate with business analysts, data architects, and DBAs to align ETL solutions with requirements.

  • Ensure data consistency, performance, and scalability of ETL processes.

  • Use Informatica transformations or scripts to handle data cleansing and standardization.

  • Monitor and tune ETL jobs for performance (e.g., optimizing lookups, joins, partitioning).

  • Apply data access controls and ensure compliance with company and regulatory standards.

  • This role will require 3 days per week at the local offices or a client site

What you need:

  • 3-5 years of experience with Informatica PowerCenter ETL Development – hands-on experience building, debugging, and optimizing mappings, sessions, and workflows for large-scale data integration projects.

  • Strong SQL and Database Skills – ability to write complex SQL queries, perform data validation, and work with relational databases

  • Experience with Data Warehousing Concepts – solid understanding of ETL design patterns, star/snowflake schemas, and data modeling principles.

  • Performance Tuning and Optimization Expertise – experience improving mapping performance through partitioning, pushdown optimization, caching, and efficient transformations.

  • Knowledge of Scheduling, Automation, and Version Control Tools – e.g. exposure to Git or SVN for code management.

  • Strong Analytical, Documentation, and Communication skills

English is required for this position as this role will regularly interact with English-speaking stakeholders across Canada. Due to the significant high volume of interactions with these English-speaking stakeholders, which is inherent to this position, it is not possible to reorganize the company's activities to avoid this requirement

Bonus points if you have experience with:

  • Cloud Data Integration experience

  • Scripting and Automation Skills

  • Data Visualization or Reporting Tools – exposure to Power BI, Tableau, or Qlik

About Accenture

Accenture is a leading global professional services company that helps the world’s leading businesses, governments and other organizations build their digital core, optimize their operations, accelerate revenue growth and enhance citizen services—creating tangible value at speed and scale. We are a talent- and innovation-led company with approximately 791,000 people serving clients in more than 120 countries. Technology is at the core of change today, and we are one of the world’s leaders in helping drive that change, with strong ecosystem relationships. We combine our strength in technology and leadership in cloud, data and AI with unmatched industry experience, functional expertise and global delivery capability. Our broad range of services, solutions and assets across Strategy & Consulting, Technology, Operations, Industry X and Song, together with our culture of shared success and commitment to creating 360° value, enable us to help our clients reinvent and build trusted, lasting relationships. We measure our success by the 360° value we create for our clients, each other, our shareholders, partners and communities.

Visit us at www.accenture.com 

Equal Employment Opportunity Statement

We believe that no one should be discriminated against because of their differences. All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, military veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by applicable law. Our rich diversity makes us more innovative, more competitive, and more creative, which helps us better serve our clients and our communities.

Accenture

Website: https://accenture.com/

Headquarter Location: Dublin, Dublin, Ireland

Employee Count: 10001+

Year Founded: 1989

IPO Status: Public

Last Funding Type: Grant

Industries: Business Information Systems ⋅ Construction ⋅ Consulting ⋅ Information Services ⋅ Information Technology ⋅ Infrastructure ⋅ Management Consulting ⋅ Outsourcing