Apply Now

Informatica ETL Lead - W2 Consultants Only

Richmond, VA, US • Posted 9 hours ago • Updated 9 hours ago

Contract W2

Contract Corp To Corp

Contract Independent

6 Months

No Travel Required

On-site

Depends on Experience

Fitment

Dice Job Match Score™

To see how well you match this job, please log in or create an account.

Once logged in, be sure to complete your profile to get the most accurate match score.

🔢 Crunching numbers...

Job Details

Skills

Informatica ETL Lead

Summary

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 Google Cloud Platform.
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.

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.

Skill Requirements

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.

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.

Dice Id: 91098872
Position Id: 6058-10115-1791305679
Posted 9 hours ago

Contact the job poster

Pooja Agarwal

Recruiter @ Shrive Technologies LLC

View Profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Data engineer

Hybrid in Richmond, Virginia

•

14d ago

Job Title: Data Engineer Primary location of assignment: Richmond, VA, 23219 Schedule : Alternate weeks in Richmond VA office; other week remote. (5 days in office, 5 days remote, repeating). No 100% remote Duration: 12 months contract, with possibility of extension Role Summary The Senior Data Engineer is a hands-on expert and technical leader, actively engaged in designing, building, and optimizing scalable, reliable data pipelines at an enterprise level.This role not only guides architectural

Easy Apply

Contract

60 - 65

Informatica ETL Developer

Remote

•

18d ago

Job Summary: We are seeking a highly experienced Informatica Extract Transform Load (ETL) Developer to join our Enterprise Data Warehouse (EDW) team. This role is responsible for designing, developing, and maintaining robust ETL processes using Informatica PowerCenter and Teradata. The ideal candidate will have a deep understanding of data integration, performance tuning, and data warehousing best practices, with a focus on supporting healthcare-related data systems. Required Qualifications:

Easy Apply

Third Party, Contract

$60 - $65

Informatica Consultant with IICS and Migration Exp

Remote or Texas

•

Yesterday

Role: Informatica Consultant with IICS and Migration Experience Duration:12 Months Location: Remote Description: ETL Informatica Consultant to lead the design, development, and deployment of enterprise-scale data integration solutions. The ideal candidate will have strong hands-on expertise with Informatica PowerCenter, Informatica Intelligent Cloud Services, Informatica Intelligent Data Management Cloud (IDMC), Unix, Autosys, and Oracle, and will play a key role in requirements analysis, techn

Easy Apply

Third Party, Contract

Informatica ETL lead(W2 only-only locals to VA)

Virginia

•

Today

Mandatory skills: Informatica ETL, SQL, AWS, Snowflake Skill Requirements 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 Warehou

Easy Apply

Contract

Search all similar jobs

More jobs at Shrive Technologies LLC in Richmond, VA