Capco
Capco

Capco is a global technology and management consultancy helping organizations address complex transformation challenges in financial services and energy. Its work combines industry knowledge with technology-led delivery across banking and payments, capital markets, insurance, wealth and asset management, and energy.

For professionals exploring careers in consulting, technology, data, or financial services, Capco offers work centered on business change, digital transformation, and practical solutions for customers and communities. The company’s expertise in data management has also earned recognition as the Best European Consultancy in Data Management.

Remote Data Architect (Informatica IDMC) — Capco, Brazil

Remote data architect designing ETL/ELT pipelines and IDMC/CDI integrations. Capco is a global technology and business consultancy serving financial services and energy.

Description

  • Design and evolve integration solutions with Informatica IDMC/CDI
  • Build scalable ETL/ELT pipelines for enterprise and cloud environments
  • Set standards for development, architecture, naming, parameterization, and reusable components
  • Create and review mappings, tasks, taskflows, and integration frameworks
  • Establish batch, incremental, CDC, and near-real-time data ingestion strategies
  • Design integrations across databases, APIs, files, SaaS applications, data warehouses, data lakes, and lakehouse platforms
  • Build and optimize solutions with advanced SQL and Python
  • Apply and guide performance tuning, including Pushdown Optimization
  • Set standards for error handling, logging, auditing, reconciliation, and observability
  • Advise on data architecture and modeling decisions
  • Organize CI/CD workflows and deployment strategies for IDMC solutions
  • Review code and uphold engineering standards and best practices
  • Investigate and resolve critical production issues
  • Contribute to estimates, technical planning, and implementation approaches
  • Turn business and functional needs into scalable technical solutions
  • Lead technical conversations with clients, architects, and stakeholders
  • Provide technical guidance and mentorship to junior and mid-level colleagues
  • Assess new IDMC capabilities and recommend architectural and process improvements

Requirements

  • Substantial experience with Informatica IDMC/IICS, especially Cloud Data Integration (CDI)
  • Advanced background architecting and developing ETL/ELT solutions
  • Advanced SQL skills, including query optimization and processing large datasets
  • Strong Python skills for automation, integration, and data processing
  • Experience with data warehouse, data lake, and lakehouse architectures
  • Experience with cloud platforms; Microsoft Azure is preferred
  • Experience with Databricks, Snowflake, or other modern data platforms
  • Experience integrating REST and SOAP APIs
  • Understanding of batch, near-real-time, and event-driven integration patterns
  • Experience with Git, CI/CD, and automated deployments
  • Experience tuning performance and troubleshooting complex pipelines
  • Knowledge of data security, governance, and quality
  • Experience setting development standards and best practices
  • Ability to provide technical leadership and mentorship
  • Strong communication and relationship-building skills with clients and stakeholders
  • Ability to work independently in highly complex settings
  • Preferably at least six years in data integration, ETL/ELT, or data engineering, including proven Informatica IDMC/CDI expertise and delivery of medium- to high-complexity solutions
  • Preferred: other IDMC modules; PowerCenter-to-IDMC migrations; advanced Azure; Snowflake; dbt; Spark/PySpark; Delta Lake; Kafka; Terraform; regulated industries; Informatica, Azure, Databricks, or Snowflake certifications; and advanced or fluent English

Benefits

  • An inclusive culture that values diversity
  • Internal inclusion and social responsibility committees, including groups for women, people with disabilities, Black people, LGBTQIAPN+ individuals, parents, and people across generations
  • Opportunities are open to everyone
  • Support for professional growth and career advancement

Related Jobs

Martin & Company

Director of P&C Insurance Consulting

Martin & Company
51 – 200 Employees
ConsultingInsuranceLogistics

Lead client-facing property and casualty insurance consulting engagements at Martin & Company, a technology-enabled insurance advisory firm. Shape project scope, protect delivery quality, grow client accounts, and mentor consultants.

Open
Powered by Search

Head of Growth, Canada (Remote)

Powered by Search
11 – 50 Employees
B2BMarketingSaaS

Lead SEO, generative engine optimization, paid acquisition, and brand advocacy at a B2B demand-generation agency. Build pipeline with AI agent workflows, content, webinars, podcasts, and industry events.

Open