Informatica Lead Developer

TechDigital Group; Durham (NC); On-site; USD 90,000 - 130,000; Full time

Job summary

An established industry player is looking for a talented Informatica Lead Developer to spearhead data integration initiatives. In this pivotal role, you will design, develop, and implement ETL solutions, leveraging your extensive experience with Informatica PowerCenter and cloud platforms. You will collaborate closely with business analysts and data architects to ensure seamless data workflows while mentoring junior developers and optimizing existing processes for performance. Join a dynamic team where your skills will directly impact data management and integration strategies, driving innovation and efficiency in data handling.

Qualifications

• 7+ years of experience in Informatica PowerCenter and ETL processes.
• Strong knowledge of SQL and relational databases.

Responsibilities

• Lead ETL process design and implementation using Informatica PowerCenter.
• Collaborate with stakeholders to gather requirements for ETL workflows.
• Optimize existing Informatica processes for performance and scalability.

Skills

Informatica PowerCenter

SQL

ETL processes

Data warehousing concepts

Performance tuning

Cloud platforms (AWS, Azure, Google Cloud)

Analytical skills

Problem-solving skills

Communication skills

Team collaboration

Tools

Informatica tools

Oracle

SQL Server

MySQL

DB2

Job description

Minimum Mandatory Skills:

• 7+ years of experience in Informatica PowerCenter development and ETL processes.
• Strong knowledge of SQL and relational databases such as Oracle, SQL Server, MySQL, or DB2.

Desired Skills

• Experience with data warehousing concepts, dimensional modeling, and data marts.
• Proficiency in performance tuning and optimization of complex ETL jobs.
• Hands-on experience with cloud platforms (e.g., AWS, Azure, Google Cloud) is a plus.
• Strong analytical, problem-solving, and debugging skills.
• Excellent communication and team collaboration abilities.

Job Description

We are seeking a highly skilled Informatica Lead Developer to manage our data integration efforts, focusing on the design, development, and implementation of ETL solutions. The ideal candidate will have extensive experience with Informatica PowerCenter, cloud platforms, and a deep understanding of data warehousing concepts.

Key Responsibilities:

• Lead the design, development, and implementation of ETL (Extract, Transform, Load) processes using Informatica PowerCenter or other Informatica tools.
• Collaborate with business analysts, data architects, and stakeholders to gather requirements and design ETL workflows.
• Optimize and tune existing Informatica processes to improve performance and scalability.
• Lead and mentor junior developers, ensuring best practices and coding standards are followed.
• Develop and maintain technical documentation for ETL processes, data flow, and error handling.
• Troubleshoot data integration and transformation issues and provide root cause analysis.
• Collaborate with the Data Warehouse team to integrate new data sources and ensure consistency in data flows.
• Manage and schedule ETL jobs, ensuring successful data load, transformation, and migration activities.
• Work closely with the database administrators and other IT teams to ensure seamless data delivery.
• Support production ETL processes and resolve any data discrepancies or job failures.