About the role
Role: Senior Informatica IICS / IDMC Developer Location: Brampton, ON (Hybrid) Hiring Mode: Contract
Pay: CAD 50/Hr.
Job Summary We are seeking an experienced Senior Informatica IICS / IDMC Developer to design, develop, and implement enterprise-grade ETL and data integration solutions using Informatica Intelligent Cloud Services (IICS) and Informatica Intelligent Data Management Cloud (IDMC). The ideal candidate will have extensive experience in Informatica development, SQL, and Agile delivery, with the ability to collaborate with business stakeholders to deliver scalable, high-quality data integration solutions.
Key Responsibilities Design, develop, and maintain ETL solutions using Informatica PowerCenter, IICS, and IDMC to meet business and technical requirements. Analyze business requirements and translate detailed functional specifications into robust ETL designs. Design and develop data integration workflows following industry best practices and coding standards. Perform data analysis using measurement techniques, define KPIs, and develop data sources, reports, and dashboards to support business decision-making. Collaborate with Subject Matter Experts (SMEs), business stakeholders, architects, and developers to understand business challenges and deliver effective data integration solutions. Develop, test, document, and deploy ETL processes with a strong focus on performance, scalability, and data quality. Write and optimize complex SQL queries for Oracle and Microsoft SQL Server databases. Develop automation and supporting scripts using Shell, VB, or Perl where required. Conduct unit testing and support System Integration Testing (SIT), User Acceptance Testing (UAT), and production deployments. Troubleshoot and resolve ETL issues across QA, SIT, and Production environments. Prepare technical design documents, implementation documentation, user guides, and training materials. Participate in Agile ceremonies and work closely with cross-functional teams using Scrum, SAFe, or similar Agile methodologies. Communicate effectively with technical teams, business users, and client stakeholders, including presenting technical solutions and project updates.
Required Qualifications Bachelor's degree in Computer Science, Engineering, Information Technology, or a related discipline. 10+ years of overall ETL development experience within large enterprise environments. 5+ years of hands-on experience with Informatica PowerCenter. 3+ years of hands-on experience with Informatica Intelligent Cloud Services (IICS) / Informatica Intelligent Data Management Cloud (IDMC). Strong expertise in ETL design, development, testing, and deployment. Extensive experience writing and optimizing complex SQL queries using Oracle and Microsoft SQL Server. Strong understanding of relational databases and data integration best practices. Experience working within Agile delivery teams (Scrum, SAFe, etc.). Hands-on experience with source control and project management tools such as Bitbucket and Jira. Excellent analytical, problem-solving, organizational, and communication skills. Proven ability to build trusted relationships with clients and stakeholders. Strong consulting and client-facing communication skills with the ability to explain technical concepts in business terms. Self-motivated, performance-driven, and capable of working independently as well as collaboratively.
Mandatory Requirement Eligibility for Canadian Reliability Status Clearance, which requires residing in Canada for the last five (5) consecutive years.
Preferred Skills Experience with Informatica Cloud Data Integration (CDI). Knowledge of data warehousing concepts and enterprise data integration architecture. Experience supporting reporting and visualization initiatives. Familiarity with scripting languages such as Shell, VB, or Perl. Experience with enterprise ETL performance tuning and optimization.
Required Technical Skills Informatica PowerCenter Informatica Intelligent Cloud Services (IICS) Informatica Intelligent Data Management Cloud (IDMC) Informatica Cloud Data Integration (CDI) Oracle SQL Microsoft SQL Server ETL Development SQL Bitbucket Jira Agile (Scrum / SAFe) Shell Scripting / VB Scripting / Perl
Experience 10+ years
About LanceSoft, Inc.
Established in 2000, LanceSoft is a pioneer in delivering top-notch Global Workforce Solutions and IT Services to a diverse clientele. As a Certified MBE and Woman-Owned organization, we pride ourselves on fostering global cross-cultural connections that advance both the careers of our employees and the success of our clients' businesses.
At LanceSoft, our mission is clear: to leverage our global network to seamlessly connect businesses with the right talent and individuals with the right opportunities, all without bias. We believe in providing Global Workforce Solutions with a personalized, human touch.
Our comprehensive range of services spans various domains, encompassing temporary and permanent staffing, Statement of Work (SOW) arrangements, payrolling, Recruitment Process Outsourcing (RPO), application design and development, program/project management, and engineering solutions.
Currently, our team of over 5,000 professionals caters to 110+ enterprise clients worldwide, including Fortune companies. Our client base represents a diverse spectrum of industries, including Banking & Financial Services, Semiconductor/VLSI, Technology, Healthcare & Life Sciences, Government, Telecom & Media, Retail & Distribution, Oil & Gas, and Energy & Utilities.
Headquartered in Herndon, VA, LanceSoft operates 32+ regional offices across the North America, Europe, Asia, and Australia. We also have nine delivery centers strategically located in India in Bangalore, Indore, Noida, Baroda, Hyderabad, Bhubaneshwar, Dehradun, Goa, and Aligarh to further enhance our client service capabilities.
Similar Jobs
About the role
Role: Senior Informatica IICS / IDMC Developer Location: Brampton, ON (Hybrid) Hiring Mode: Contract
Pay: CAD 50/Hr.
Job Summary We are seeking an experienced Senior Informatica IICS / IDMC Developer to design, develop, and implement enterprise-grade ETL and data integration solutions using Informatica Intelligent Cloud Services (IICS) and Informatica Intelligent Data Management Cloud (IDMC). The ideal candidate will have extensive experience in Informatica development, SQL, and Agile delivery, with the ability to collaborate with business stakeholders to deliver scalable, high-quality data integration solutions.
Key Responsibilities Design, develop, and maintain ETL solutions using Informatica PowerCenter, IICS, and IDMC to meet business and technical requirements. Analyze business requirements and translate detailed functional specifications into robust ETL designs. Design and develop data integration workflows following industry best practices and coding standards. Perform data analysis using measurement techniques, define KPIs, and develop data sources, reports, and dashboards to support business decision-making. Collaborate with Subject Matter Experts (SMEs), business stakeholders, architects, and developers to understand business challenges and deliver effective data integration solutions. Develop, test, document, and deploy ETL processes with a strong focus on performance, scalability, and data quality. Write and optimize complex SQL queries for Oracle and Microsoft SQL Server databases. Develop automation and supporting scripts using Shell, VB, or Perl where required. Conduct unit testing and support System Integration Testing (SIT), User Acceptance Testing (UAT), and production deployments. Troubleshoot and resolve ETL issues across QA, SIT, and Production environments. Prepare technical design documents, implementation documentation, user guides, and training materials. Participate in Agile ceremonies and work closely with cross-functional teams using Scrum, SAFe, or similar Agile methodologies. Communicate effectively with technical teams, business users, and client stakeholders, including presenting technical solutions and project updates.
Required Qualifications Bachelor's degree in Computer Science, Engineering, Information Technology, or a related discipline. 10+ years of overall ETL development experience within large enterprise environments. 5+ years of hands-on experience with Informatica PowerCenter. 3+ years of hands-on experience with Informatica Intelligent Cloud Services (IICS) / Informatica Intelligent Data Management Cloud (IDMC). Strong expertise in ETL design, development, testing, and deployment. Extensive experience writing and optimizing complex SQL queries using Oracle and Microsoft SQL Server. Strong understanding of relational databases and data integration best practices. Experience working within Agile delivery teams (Scrum, SAFe, etc.). Hands-on experience with source control and project management tools such as Bitbucket and Jira. Excellent analytical, problem-solving, organizational, and communication skills. Proven ability to build trusted relationships with clients and stakeholders. Strong consulting and client-facing communication skills with the ability to explain technical concepts in business terms. Self-motivated, performance-driven, and capable of working independently as well as collaboratively.
Mandatory Requirement Eligibility for Canadian Reliability Status Clearance, which requires residing in Canada for the last five (5) consecutive years.
Preferred Skills Experience with Informatica Cloud Data Integration (CDI). Knowledge of data warehousing concepts and enterprise data integration architecture. Experience supporting reporting and visualization initiatives. Familiarity with scripting languages such as Shell, VB, or Perl. Experience with enterprise ETL performance tuning and optimization.
Required Technical Skills Informatica PowerCenter Informatica Intelligent Cloud Services (IICS) Informatica Intelligent Data Management Cloud (IDMC) Informatica Cloud Data Integration (CDI) Oracle SQL Microsoft SQL Server ETL Development SQL Bitbucket Jira Agile (Scrum / SAFe) Shell Scripting / VB Scripting / Perl
Experience 10+ years
About LanceSoft, Inc.
Established in 2000, LanceSoft is a pioneer in delivering top-notch Global Workforce Solutions and IT Services to a diverse clientele. As a Certified MBE and Woman-Owned organization, we pride ourselves on fostering global cross-cultural connections that advance both the careers of our employees and the success of our clients' businesses.
At LanceSoft, our mission is clear: to leverage our global network to seamlessly connect businesses with the right talent and individuals with the right opportunities, all without bias. We believe in providing Global Workforce Solutions with a personalized, human touch.
Our comprehensive range of services spans various domains, encompassing temporary and permanent staffing, Statement of Work (SOW) arrangements, payrolling, Recruitment Process Outsourcing (RPO), application design and development, program/project management, and engineering solutions.
Currently, our team of over 5,000 professionals caters to 110+ enterprise clients worldwide, including Fortune companies. Our client base represents a diverse spectrum of industries, including Banking & Financial Services, Semiconductor/VLSI, Technology, Healthcare & Life Sciences, Government, Telecom & Media, Retail & Distribution, Oil & Gas, and Energy & Utilities.
Headquartered in Herndon, VA, LanceSoft operates 32+ regional offices across the North America, Europe, Asia, and Australia. We also have nine delivery centers strategically located in India in Bangalore, Indore, Noida, Baroda, Hyderabad, Bhubaneshwar, Dehradun, Goa, and Aligarh to further enhance our client service capabilities.