ETL DEVELOPER INFORMATICA

Overview

Remote
Full Time
Accepts corp to corp applications
Contract - W2

Skills

Mapping Designer
Transformation Developer Database & SQL Strong skills in SQL and PL/SQL Experience with RDBMS like Oracle
SQL Server
Teradata
or MySQL Data Warehousing Concepts Dimensional modeling (Star & Snowflake schema) Data normalization and denormalization ETL performance tuning Scripting & Automation Unix/Linux Shell Scripting for job automation Basic knowledge of Python or P
transformation
and validation techniques Scheduling Tools Tools like Control-M
Autosys
or Tivoli Version Control & DevOps (optional) Git
SVN for source code management Jenkins or other CI/CD tools

Job Details

Job Title: ETL Developer Informatica
Location: [Remote] or OPEN TO RELOCATE
Department: Data Engineering / IT

Job Summary:

We are seeking a highly skilled ETL Developer with strong expertise in Informatica to design, develop, and maintain robust ETL workflows and data integration solutions. You will work closely with data analysts, business stakeholders, and IT teams to ensure data accuracy, performance, and reliability across our enterprise data platforms.

Key Responsibilities:

  • Design, develop, test, and deploy ETL processes using Informatica PowerCenter/IDQ/Cloud.

  • Extract data from various sources (RDBMS, APIs, flat files), transform it to meet business needs, and load it into data warehouses or data lakes.

  • Optimize ETL workflows for performance, scalability, and maintainability.

  • Collaborate with data architects and analysts to design robust data models and pipelines.

  • Develop and maintain data quality checks, error handling, and recovery mechanisms.

  • Ensure compliance with data governance, security policies, and best practices.

  • Document ETL processes, metadata, and data flow diagrams.

  • Perform root cause analysis on data issues and recommend solutions.

  • Monitor production jobs and provide L2/L3 support as needed.

Required Qualifications:

  • Bachelor's degree in Computer Science, Information Systems, or a related field.

  • 3+ years of hands-on experience with Informatica (PowerCenter, Informatica Cloud, or similar).

  • Proficient in SQL and working with relational databases like Oracle, SQL Server, or PostgreSQL.

  • Strong understanding of data warehousing concepts, ETL best practices, and data modeling.

  • Experience with scheduling tools (e.g., Autosys, Control-M) and version control systems (e.g., Git).

  • Familiarity with cloud data platforms (AWS, Azure, Google Cloud Platform) is a plus.

  • Strong problem-solving, analytical, and communication skills.

Preferred Qualifications:

  • Informatica certifications (e.g., Informatica Developer Certified Professional).

  • Experience with Agile/Scrum methodologies.

  • Knowledge of big data technologies (Spark, Hive, Hadoop) is an advantage.

  • Experience integrating data from ERP, CRM, or third-party platforms.

Let me know if you need a version tailored to a specific industry, experience level, or cloud platform (e.g., Informatica on AWS or Azure).

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Grand Software Solutions