Position Details: ELT – Data Migration

Description:

Position : ETL – Data Migration.

Job Description

Role: Informatica Consultant (ELT – Data Migration)

Location: Remote

Experience: 5+ Years

Employment Type: Contract

Job Summary

We are looking for an experienced Informatica Consultant to support a large-scale data migration initiative.

The role will focus on designing and implementing ELT processes using Informatica to migrate and transform data across systems while ensuring data quality, integrity, and performance.

The consultant will also work on database scripting and query optimization to support data transformation and migration activities.

Key Responsibilities

• Design, develop, and implement ELT workflows using Informatica (PowerCenter / IICS / IDMC).

• Support data migration activities including data extraction, transformation, validation, and loading.

• Build scalable data integration pipelines to migrate data from legacy systems to the target platform.

• Develop data mappings, transformation logic, and workflow orchestration.

• Write and optimize database scripts (SQL, stored procedures, functions, and queries) to support ETL/ELT processes and data transformations.

• Perform data quality checks, validation, and reconciliation to ensure migration accuracy.

• Optimize ETL/ELT jobs and database queries for performance and scalability.

• Collaborate with data architects, DBAs, and business stakeholders during migration phases.

• Troubleshoot issues in data pipelines, workflows, database scripts, and mappings.

• Maintain proper documentation of migration processes, mapping documents, database scripts, and technical specifications.

Required Skills

• Strong experience in Informatica PowerCenter / IICS / Informatica Cloud.

• Hands-on experience with ELT / ETL development in data migration projects.

• Strong knowledge of SQL and database scripting, including stored procedures, triggers, and query optimization.

• Experience working with relational databases such as Oracle, SQL Server, PostgreSQL, or MySQL.

• Experience working with large-scale data migration and transformation processes.

• Familiarity with data validation, reconciliation, and data quality frameworks.

• Understanding of data warehouse concepts and dimensional modeling.

• Ability to troubleshoot and optimize Informatica workflows, mappings, and database scripts.

Preferred Skills

• Experience with cloud data platforms (Snowflake, Azure, AWS, GCP).

• Exposure to Informatica IDMC / Informatica Data Quality.

• Knowledge of data governance and metadata management.

• Experience working in Agile or enterprise data transformation programs.

Education

Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field.

Perform an action: