Software Mind logo
Software Mind

Software House focused on results since 1999

ETL Data Engineer, Informatica, IICS

Analytics EngineerAnalytics EngineerContractRemoteSeniorTeam 1,001-5,000Since 1999H1B No SponsorCompany SiteLinkedIn

Location

Costa Rica

Posted

7 days ago

Salary

0

Seniority

Senior

Bachelor Degree6 yrs expEnglishCloudETLInformaticaOracleSOAPSQL

Job Description

ETL Data Engineer, Informatica, IICS

Software Mind

• Design, develop, test and deploy data integration solutions using IICS (Cloud Data Integration, Application Integration, Data Quality, Data Synchronization). • Build ETL/ELT pipelines to ingest, transform, and deliver data between cloud and onprem systems (SaaS, databases, data lakes, data warehouses). • Implement secure and performant integration patterns using IICS mapping tasks, mappings, tasks, and parameterization. • Develop and maintain reusable templates, mappings, and components to accelerate delivery. • Collaborate with architects, data engineers, analytics teams, and business stakeholders to define integration requirements and data contracts. • Troubleshoot and resolve production incidents; perform root cause analysis and implement fixes. • Automate deployments and CI/CD for IICS artifacts (Dev → Test → Prod), including versioning, changelogs, and release notes. • Implement monitoring, alerting, and operational runbooks for integrations. • Enforce data quality rules and profiling; work with business to remediate data quality issues. • Prepare technical documentation: design documents, runbooks, data flow diagrams, and support guides. • Support platform governance: connectivity, security, access controls, best practices, and cost optimization.

Job Requirements

  • 6-8+ years of hands-on experience in data integration/ETL roles
  • Strong hands-on experience with Informatica Intelligent Cloud Services (IICS) — Cloud Data Integration and Application Integration strongly preferred.
  • Strong experience in SQL with the ability to read and enhance medium to high complexity SQL code.
  • Deep understanding of data modelling concepts (Star Schema, Medallion architecture) ETL/ELT concepts, mapping designs, pushdown optimization, and performance tuning.
  • Experience integrating with relational databases (Oracle, SQL Server), cloud data stores (Databricks), and SaaS APIs (Salesforce, Workday, etc.).
  • Familiarity with JSON, XML, REST/SOAP APIs, and data serialization formats.
  • SQL expertise for transformation, validation, and performance tuning.
  • Experience with source control (Git), CI/CD pipelines, and deployment automation.
  • Strong troubleshooting and debugging skills in production environments.
  • Excellent communication skills and ability to work across cross-functional teams.

Benefits

  • Remote work options

Related Categories

Related Job Pages

More Analytics Engineer Jobs

Full TimeRemoteTeam 5,001-10,000Since 1995H1B No Sponsor

• Azure Data Engineering: Design and maintain data pipelines and solutions using Azure Data Factory, Azure Synapse Analytics, Azure Databricks, and Azure Data Lake, ensuring end-to-end reliability, scalability, and performance. • Analytics & Visualization: Build dashboards and analytical reports in Power BI and Tableau, translating infrastructure metrics, application performance data, and business KPIs into concrete, actionable recommendations. • Data Modeling & Integration: Develop data modeling, data mining, and integration processes across on-premises and cloud sources, creating reliable datasets to support analytical models and dashboards. • Queries & Large-Scale Processing: Write complex SQL and Kusto queries, as well as scripts and REST API calls for large-scale data collection and processing. • Cloud Cost Management: Operate with cost awareness in managing cloud compute and storage resources, proposing optimizations that balance performance and efficiency. • Technical Reference: Guide application and business teams on data usage and interpretation, proactively promoting best practices in data engineering, modeling, and BI tooling. • Agile Collaboration: Work within Agile/Scrum methodologies using project management tools such as Jira, with the ability to prioritize deliverables and manage tasks autonomously across onsite and offshore teams.

Brazil
Grupo Boticário logo

Data and Analytics Specialist, I

Grupo Boticário

Criamos oportunidades para a beleza transformar a vida das pessoas, e assim transformar o mundo ao nosso redor.

Full TimeRemoteTeam 10,001+Since 2010H1B No Sponsor

• Lead the migration and structuring of data from the Credit, Collections and Fraud Prevention areas to Google Cloud Platform (GCP) • Build refined tables and automate processes using the various tools available in GCP • Oversee system integration projects focused on process automation and data structuring • Generate new insights from data analysis and communicate findings clearly to business stakeholders • Monitor the performance of Collections & Fraud (C&F) ML models through automated data processes • Create innovative processes using GenAI and Predictive AI within the Directorate

Brazil
PatientPoint logo

Senior Analytics Engineer

PatientPoint

The patient engagement platform more providers trust.

Full TimeRemoteTeam 501-1,000Since 1987H1B Sponsor

• Design, build, and own end-to-end data solutions for Core products. • Establish and scale analytics foundations by implementing data pipelines. • Oversee the design and development of interactive analytical experiences. • Mentor and support the growth of junior team members through coaching.

United States
$73.5K - $165K / year
Paddle logo

Senior Analytics Engineer – Marketing

Paddle

We’re the only complete payments infrastructure provider for SaaS companies.

Full TimeRemoteTeam 201-500H1B Sponsor

• drive significant business impact by shaping our data infrastructure • developing robust data models • promoting best practices in analytics engineering • collaborate closely with the Marketing team • ensure that funnels are being tracked and surfaced in our data models • evaluate Marketing campaigns using accurate data • create trusted, self-serve datasets • proactively identify and resolve data quality issues • add comprehensive metadata to datasets • partner with Marketing stakeholders to translate business questions into robust data products • enable Marketing teams to confidently use Omni and core GTM datasets • activate data from Snowflake into operational tools

United Kingdom