Informatica Administrator / ETL Developer

Veriipro; United States; On-site; USD 90,000 - 120,000; Full time

Job summary

Veriipro is seeking an Informatica Administrator / ETL Developer to design, build, and optimize data integration pipelines across enterprise systems. The role emphasizes reliability and performance of ETL processes using Informatica tools and strong SQL expertise.

The ideal candidate will manage data flow into data warehouses, implement best practices, and troubleshoot data issues. Collaboration with data engineers and business teams is essential to meet evolving data requirements.

Qualifications

• Bachelor’s degree or equivalent experience in CS or related field.
• 3+ years of ETL/data integration development experience.
• Hands-on experience with Informatica PowerCenter or IICS.
• Strong SQL skills including complex queries and performance tuning.
• Experience with SQL Server, Oracle, PostgreSQL, or Snowflake.
• Knowledge of data warehousing concepts such as star schemas.
• Experience integrating data from multiple sources (flat files, APIs, ERP/CRM).
• Strong problem-solving and troubleshooting skills.
• Excellent communication and collaboration skills.

Responsibilities

• Design, develop, and maintain ETL workflows using Informatica tools.
• Build and support data integration pipelines across source systems.
• Develop and optimize SQL queries, stored procedures, and transformation logic.
• Monitor ETL jobs, troubleshoot failures, and resolve data issues.
• Perform performance tuning of ETL processes and queries.
• Ensure accurate and timely data movement into data warehouse environments.
• Support data warehousing structures including fact and dimension models.
• Integrate data from APIs, flat files, ERP/CRM systems, and databases.
• Collaborate with data engineers, analysts, and business teams to meet data requirements.
• Ensure data quality, integrity, and consistency across all integration processes.

Skills

ETL / data integration

SQL

Communication

Problem solving

Education

Bachelor’s degree in Computer Science or related field

Tools

Informatica PowerCenter

Informatica IICS

Job description

Overview

We are seeking an Informatica Administrator / ETL Developer with strong experience in data integration, ETL development, and data warehousing. The ideal candidate will be responsible for building, maintaining, and optimizing ETL processes using Informatica tools while ensuring efficient and reliable data flow across enterprise systems.

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related field, or equivalent experience


• 3+ years of experience in ETL/data integration development


• Hands-on experience with Informatica PowerCenter, IICS, or other Informatica tools


• Strong SQL skills including complex queries, stored procedures, and performance tuning


• Experience with relational databases such as SQL Server, Oracle, PostgreSQL, or Snowflake


• Strong understanding of data warehousing concepts (star schema, fact/dimension models, ETL best practices)


• Experience integrating data from multiple sources including flat files, APIs, ERP/CRM systems, and databases


• Strong problem-solving and troubleshooting skills


• Excellent communication and collaboration skills

Roles and Responsibilities

• Design, develop, and maintain ETL workflows using Informatica tools


• Build and support data integration pipelines across multiple source systems


• Develop and optimize SQL queries, stored procedures, and transformation logic


• Monitor ETL jobs, troubleshoot failures, and resolve data issues


• Perform performance tuning of ETL processes and database queries


• Ensure accurate and timely data movement into data warehouse environments


• Support data warehousing structures including fact and dimension models


• Integrate data from APIs, flat files, ERP/CRM systems, and databases


• Collaborate with data engineers, analysts, and business teams to meet data requirements


• Ensure data quality, integrity, and consistency across all integration processes


• Follow ETL standards, documentation practices, and deployment procedures