Senior Informatica ETL SME - Remote

NTT DATA Services; Toronto; Remote; CAD 90,000 - 130,000; Full time

Job summary

A leading company in business and technology services is seeking a Senior Informatica ETL SME to join their remote team. This role involves analyzing data integration needs, developing ETL solutions, and collaborating with other teams to enhance data management processes. The ideal candidate will have over 10 years of ETL experience, strong proficiency in Informatica and SQL, and a Bachelor's degree in a related field, offering an attractive salary package in a dynamic work environment.

Qualifications

• 10+ years in data integration (ETL), with 8+ years in solution development using Informatica.
• Strong SQL skills, capable of writing complex queries.
• Recent experience in an ETL/Data Engineering lead developer role.

Responsibilities

• Perform data analysis, collect business requirements and identify business rules.
• Analyze, develop and support Data Integration, EDW and Data Management using Informatica.
• Automate the ETL processes and pipelines using scripting.

Skills

ETL / Data Engineering

Informatica

SQL

Linux shell scripting

Data integration/ETL specifications

Effective communication

Education

Bachelor’s degree in Computer Engineering, Computer Science, or related field

Tools

MS Visio

PowerPoint

Job description

Req ID:
#

NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.

We are currently seeking a Senior Informatica ETL SME - Remote to join our team in Canada (EST Working Hours).

Job Overview:

• Perform Data analysis, collect business requirements and identify business rules.
• Analyze, develop and support Data Integration, EDW and Data Management using Informatica, SQL, Oracle, etc.
• Collaborate with data modelling team to define data integration logic.
• Create data mappings necessary to fulfill the requirements.
• Build and test new ETL programs to fulfill the service requests.
• Automate the ETL processes and pipelines using scripting and schedulers.
• Participate in Unit Testing, assist QA team in Integration Testing, and support Business team for UAT.
• Participate in code deployment and coordinate with infrastructure teams during go-live, post-production, and support.
• Debug data quality issues by analyzing upstream sources and guide data integration team resolutions.
• Work closely with DBAs to fix performance bottlenecks.

Skills:

• Recent experience in an ETL / Data Engineering lead developer role.
• 10+ years in data integration (ETL), with 8+ years in solution development using Informatica.
• 8+ years in RDBMS / Data Warehousing platforms on Oracle.
• Expertise in Linux shell scripting for automation.
• Strong SQL skills, capable of writing complex queries.
• Understanding of logical and physical data modelling; experience is a plus.
• Ability to develop and maintain data integration/ETL specifications.
• Proficiency with documentation tools like MS Visio and PowerPoint.
• Effective communication skills with technical and business teams.

Desired Skills:

• ETL and Data Warehouse platform certifications.
• Healthcare domain experience.
• Data profiling and automated data quality solutions.

Education:

• Bachelor’s degree in Computer Engineering, Computer Science, or related field.

About NTT DATA:

NTT DATA is a $30 billion global innovator in business and technology services, serving 75% of the Fortune Global 100. We focus on innovation, optimization, and transformation, with a presence in over 50 countries. Our offerings include consulting, data and AI, industry solutions, and application development and management. As part of NTT Group, we invest heavily in R&D to advance digital and AI infrastructure. Visit us at us.nttdata.

We are committed to accessibility and equal opportunity employment. For accommodations or application assistance, contact us at us.nttdata/en/contact-us. Qualified applicants will be considered without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.