Senior Informatica ETL Lead for Data Warehousing

Shrive Technologies LLC; Richmond (VA); On-site; USD 140,000 - 170,000; Full time

Job summary

Shrive Technologies LLC is seeking an experienced Informatica ETL Lead with 10+ years of expertise to design, develop, and implement enterprise-scale data integration and ETL solutions. The ideal candidate will lead a team and collaborate with business and technical stakeholders.

You will guide mappings, workflows, and performance tuning in PowerCenter, work with SQL and data warehousing concepts, and drive data governance and modernization initiatives across on/offshore teams.

Qualifications

• 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.

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.

Skills

Informatica PowerCenter

ETL design

SQL

Data Warehousing

Leadership

Stakeholder management

Education

Bachelor's degree in CS/IT/Engineering

Informatica certifications

Tools

Control-M

Snowflake

Informatica PowerCenter

Job description

Shrive Technologies LLC is seeking an experienced Informatica ETL Lead with 10+ years of expertise to design, develop, and implement enterprise-scale data integration and ETL solutions. The ideal candidate will lead a team and collaborate with business and technical stakeholders.

You will guide mappings, workflows, and performance tuning in PowerCenter, work with SQL and data warehousing concepts, and drive data governance and modernization initiatives across on/offshore teams.