Informatica ETL

TechDigital Group

Richmond (VA)

On-site

USD 120,000 - 160,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

TechDigital Group in Richmond, VA seeks an experienced Informatica ETL Lead with 10+ years of expertise to design, develop, and implement enterprise ETL solutions. You will lead a team, collaborate with stakeholders, and ensure performance and reliability using Informatica PowerCenter, SQL, and data warehousing principles.

Ideal candidates bring hands-on PowerCenter skills, Snowflake or cloud data experience, and strong leadership to drive data integration strategies across complex environments.

Qualifications

  • 10+ years of IT experience with strong ETL and data warehousing.
  • 8+ years hands-on Informatica PowerCenter.
  • Strong SQL, data warehousing, and performance tuning.
  • Experience with Oracle, SQL Server, Teradata, and Snowflake.
  • Experience with scheduling tools like Control-M.

Responsibilities

  • Lead design, development, and support of ETL solutions using Informatica PowerCenter.
  • Translate business requirements into scalable ETL and data integration designs.
  • Design complex mappings, workflows, sessions, and reusable components.
  • Lead ETL teams, perform code reviews, and enforce best practices.
  • Collaborate with analysts, architects, and stakeholders on data integration strategies.
  • Troubleshoot production issues and support data migration and governance initiatives.

Skills

ETL
Data Warehousing
SQL
Leadership
Stakeholder mgmt

Education

Bachelor's degree in Computer Science, Information Technology, Engineering, or related field

Tools

Informatica PowerCenter
Snowflake
AWS

Job description

Mandatory skills:Informatica ETL, SQL, AWS, Snowflake

We are seeking an experienced Informatica ETL Lead with 10+ years of expertise in designing, developing, and implementing enterprise-scale data integration and ETL solutions. The ideal candidate should possess strong hands-on experience with Informatica PowerCenter, data warehousing, SQL, and ETL architecture, along with the ability to lead a team and collaborate effectively with business and technical stakeholders.

Key Responsibilities
  • Lead the design, development, and support of ETL solutions using Informatica PowerCenter.
  • Analyze business requirements and translate them into scalable ETL and data integration solutions.
  • Design and implement complex mappings, workflows, sessions, and reusable components.
  • Lead ETL development teams and perform code reviews to ensure adherence to best practices.
  • Optimize ETL processes for performance, scalability, and reliability.
  • Work closely with business analysts, data architects, and stakeholders to define data integration strategies.
  • Troubleshoot and resolve ETL production issues while ensuring minimal business impact.
  • Support data migration, data quality, data governance, and modernization initiatives.
  • Collaborate with offshore/onshore teams and provide technical leadership throughout the project lifecycle.
  • Prepare technical design documents, deployment plans, and operational runbooks.
Required Skills
  • 10+ years of IT experience with strong expertise in ETL and Data Warehousing.
  • 8+ years of hands-on experience with Informatica PowerCenter.
  • Strong experience in ETL design, development, and performance tuning.
  • Extensive experience with SQL, query optimization, and database performance tuning.
  • Experience with relational databases such as:
    • Oracle
    • SQL Server
    • Teradata
    • Snowflake (preferred)
  • Strong understanding of Data Warehousing concepts, including:
    • Star Schema
    • Snowflake Schema
    • Fact and Dimension Modeling
    • Slowly Changing Dimensions (SCD)
  • Experience with scheduling tools such as Control-M or equivalent.
  • Excellent troubleshooting and root-cause analysis skills.
  • Strong communication and stakeholder management skills.
Preferred Skills
  • Experience with Informatica IICS (Intelligent Cloud Services).
  • Experience with cloud platforms such as AWS, Azure, or GCP.
  • Exposure to data lake and modern data platform architectures.
  • Experience with Agile/Scrum methodologies.
  • Knowledge of data governance and data quality frameworks.
Leadership Expectations
  • Lead and mentor ETL development teams.
  • Drive technical discussions with customers and business stakeholders.
  • Provide effort estimations and technical solution recommendations.
  • Ensure delivery quality and adherence to project timelines.
Educational Qualification
  • Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
  • Informatica certifications will be an added advantage.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Azure Cloud Infra Engineer — API & FHIR Specialist
Azure Cloud Infra Engineer — API & FHIR Specialist

TechDigital Group • Burbank (CA)

On-site
USD 110,000 - 170,000
ETL Lead
ETL Lead

TechDigital Group • Secaucus (NJ)

On-site
USD 120,000 - 180,000
ETL Engineer
ETL Engineer

Ethereum Technologies LLC • Columbia (SC)

On-site
USD 95,000 - 135,000
ETL Developer
ETL Developer

Valiant Technologies LLC • Charlotte (NC)

On-site
USD 90,000 - 120,000
ETL Developer
ETL Developer

Ethereum Technologies LLC • Charlotte (NC)

On-site
USD 90,000 - 130,000
ETL Engineer
ETL Engineer

Valiant Technologies LLC • Columbia (SC)

On-site
USD 110,000 - 150,000
ETL Tech Lead
ETL Tech Lead

Sarian Solutions • McLean (VA)

On-site
USD 100,000 - 130,000
Informatica Lead - Admin & Development for Data Integration
Informatica Lead - Admin & Development for Data Integration

Compunnel Inc. • Los Angeles (CA)

On-site
USD 120,000 - 150,000
ETL Informatica Developer
ETL Informatica Developer

Envision Technology Solutions • Plano (TX)

On-site
USD 85,000 - 120,000
Informatica Support Admin and Developer Lead
Informatica Support Admin and Developer Lead

Compunnel Inc. • Los Angeles (CA)

On-site
USD 120,000 - 150,000