Informatica ETL Lead

Shrive Technologies LLC

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.

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.

Apply

Vacancy posted 2 days ago

Similar jobs that could be interesting for youBased on the Informatica ETL Lead in Richmond, VA vacancy

Lead First Line Supervisor
Position Summary: The Lead First Line Supervisor works to achieve operational targets and standards by directing hourly employees to complete tasks that have a direct impact on overall results within assigned job area(s).Duties and Responsibilities:· Ensure assigned tasks...
Suggested
Hourly pay
Work at office
Shift work
Rotating shift
AdvanSix
Richmond, VA
a month ago
Lead First Line Supervisor
$86.4k - $129.6k
...and innovative company, meeting passionate colleagues and partners with diverse backgrounds and experiences Position Summary: The Lead First Line Supervisor works to achieve operational targets and standards by directing hourly employees to complete tasks that have a...
Suggested
Hourly pay
Temporary work
Work experience placement
Work at office
Flexible hours
Shift work
Rotating shift
AdvanSix
Richmond, VA
2 days ago
Lead Cyber Security Architect
$143k - $238.4k
...of health for patients, our communities, and our people. If you want to be part of tomorrow’s health today, we want to hear from you.Lead Cyber Security ArchitectLocation: Richmond, VA, USA - 9954 Mayland Drive (on-site)The OpportunityThe Lead Cyber Security Architect...
Suggested
Full time
McKesson
Richmond, VA
a month ago
Lead Data Architect
$120.9k - $187k
At Genworth, we empower families to navigate the aging journey with confidence. We are compassionate, experienced allies for those navigating care with guidance, products, and services that meet families where they are. Further, we are the spouses, children, siblings, ...
Suggested
Full time
Work at office
Local area
Remote work
Genworth Financial
Richmond, VA
a month ago
Lead Data Architect
$120k
...better. We create fulfilling purpose-driven careers by learning from the world and each other. **POSITION TITLE** Analytics Data Modeler Lead **LOCATION** This position is available to Virginia residents as Richmond or Lynchburg, VA Hybrid in-office applicants or remote...
Suggested
Work at office
Local area
Remote work
Flexible hours
Genworth Financial, Inc.
Richmond, VA
3 days ago
Lead Data Architect
$185.4k - $344.4k
Standard Job Description Join Lockheed?Martin's Data & AI Enablement organization and accelerate the company's AI transformation. As a lead data architect, you will drive the creation of logical data models that underpin our next-generation data products and enterprise...
Full time
Temporary work
Work experience placement
Flexible hours
Lockheed Martin Corporation
Richmond, VA
3 days ago
Lead Construction Superintendent
...KBS is seeking an experienced Commercial Construction Superintendent to lead onsite operations for large, complex projects over $30M. Our superintendents play a key leadership role—managing field teams, upholding the highest standards in safety and quality, and ensuring...
For contractors
For subcontractor
Local area
KBS
Richmond, VA
1 day ago
Site Security Automation Cluster Lead
$122k - $167.75k
Job DescriptionAre You Ready to Make It Happen at Mondelēz International?Join our Mission to Lead the Future of Snacking. Make It With Pride.As the local expert in automation, digital transformation, and cybersecurity, you plan and organize cross-functional project teams...
Full time
Local area
Relocation package
Monday to Friday
Mondelēz International
Richmond, VA
15 days ago
Estimating & Benchmarking Lead
...Title: Estimating & Benchmarking Lead KBR Sustainable Technology Solutions (STS) provides holistic and value-added solutions across the entire asset life cycle. These include world-class licensed process technologies, differentiated advisory services, deep technical...
Full time
For contractors
Local area
Flexible hours
KBR
Richmond, VA
12 days ago
Campus Integration & Multi-EPC Coordination Lead - Pharmaceutical Manufacturing
$170k - $200k
...Job Description Overview We are seeking a Campus Integration & Multi-EPC Coordination Lead - Pharmaceutical Manufacturing to join our team in TX, AL, VA, PA, OH, IN, and WI . Our Pharmaceutical team is growing! The Campus Integration Director/Multi-EPC Coordination...
Full time
Contract work
Temporary work
For contractors
Flexible hours
AtkinsRéalis
Richmond, VA
a month ago
Site Security Automation Cluster Lead
...Job Description Job Description Benefits: ~401(k) ~ Health insurance ~ Paid time off Site Security Automation Cluster Lead Richmond, Virginia Full Time Summary: This role will lead the automation and digitalization agenda across a cluster of manufacturing...
Full time
Local area
Veracity Ventures Inc.
Richmond, VA
18 days ago
Downtown Richmond - (N. 9th St. Area) - Cleaning Team Lead - Part-Time
$15 per hour
...Job Description Job Description Janitorial Team Lead – Downtown Richmond (N. 9th St.) ServiceMaster Services | Part-Time, Evenings | $15/hr Lead a small cleaning crew in Downtown Richmond and help keep a busy building running smoothly. This is a hands-on supervisory...
Part time
Monday to Friday
Shift work
Night shift
Afternoon shift
SVM Services
Richmond, VA
13 days ago
Manufacturing Team Lead
$25 - $30 per hour
...Manufacturing Team Lead Lead the Build. Drive Continuous Improvement. Grow Your Career. Are you an experienced electro-mechanical assembler ready to take the next step in your career? We're looking for a Manufacturing Team Lead who thrives in a hands-on environment...
Weekly pay
Contract work
Temporary work
Work at office
Monday to Friday
Flexible hours
Richmond, VA
a month ago
Licensed Mental Health Professional (Crisis Lead)
$35 - $60 per hour
...dedicated and skilled Licensed Mental Health Professional (or licensure-track clinician) to serve Mobile Crisis division as a Crisis Lead which is a vital role. This position is central to our mission, and it is an opportunity to assist our clinical leadership with...
Hourly pay
Full time
Remote work
Trial period
Weekday work
L.E.V.E.L.S Mental Health
Richmond, VA
a month ago
Team Lead
$17.5 per hour
...enjoy serving others, and want to be active and work outside, then join us in become the most admired car wash business! As a Team Lead at GO Car Wash, you’ll help site managers with the daily operations of our car wash, while also contributing to the overall success...
Work experience placement
GO Car Wash Management Corp
Richmond, VA
a month ago
Shift Lead
...Red Robin Urgent Hiring: Immediate Opening for a Highly Skilled Shift Lead Are you looking for a fun and dynamic work environment where your leadership skills can shine? Do you enjoy working in a lively, team-oriented setting that values enthusiasm and excellent service...
Full time
Casual work
Immediate start
Shift work
Red Robin
Richmond, VA
17 days ago
Media Team Lead- Part-time
...Job Description Job Description The Part-time Media Director leads and oversees the church’s media operations to support excellent, engaging, and distraction-free worship experiences, Bible study, special services, and ministry events. This person will provide spiritual...
Part time
Night shift
Weekday work
First Baptist Church of South Richmond
Richmond, VA
13 days ago
Right-of-Way (ROW) Program Lead
$92k - $143.57k
...abstract ideas into realities that transform the world for good. Your impact Jacobs is seeking an experienced Right-of-Way (ROW) Program Lead to support a strategic delivery partner program for a major electric utility serving the Midwest and Eastern United States. As a key...
Full time
Contract work
For contractors
For subcontractor
Work at office
Local area
Remote work
Jacobs
Richmond, VA
3 days ago
Full-Time Program Lead Positions CDA or Certified great pay is negoti
$16 per hour
...Health insurance ~ Opportunity for advancement ~ Paid time off ~ Training & development ~ Vision insurance Classroom Program Lead – Foundations Learning Academy Inspire. Lead. Shape the Future. Locations: Multiple Locations (Richmond Area) Schedule:...
Full time
Part time
Monday to Friday
FLA Midlo
Richmond, VA
a month ago
Hourly Shift Lead
...Summary: We are seeking an experienced and dedicated Restaurant "Shift Lead" to join our team at WOB Bar & Kitchen. This Key employee will be responsible for leading a shift for WOB ( World of Beer ) location, the ability to meet or exceed established shift goals...
Hourly pay
Permanent employment
Contract work
Local area
Flexible hours
Shift work
WOB Bar & Kitchen
Richmond, VA
2 days ago
Produce Lead
...people, and food. Values: Customer-centered. Community-focused. Team-oriented. Partnership-driven. Position Summary The Produce Lead is responsible for the overall daily success of the Produce and Floral departments. This includes ordering, merchandising, inventory...
Full time
Temporary work
Weekend work
Afternoon shift
The Market at 25th
Richmond, VA
15 hours ago
Automation Lead
...Automation Lead Exact work location Richmond VA / McLean VA. Mandatory skills: Automation Lead w Selenium, Java, Cucumber. Nice to have: Windows Powershell automation scripting and Protractor (not mandatory). Able to design and build automation frameworks. Lead and...
ClifyX
Richmond, VA
2 hours ago
Dairy/Frozen Lead
Grocery Team Member Under the direction of the Grocery Manager is responsible for ordering, stocking, rotating, displaying dairy and frozen food products, ensuring product freshness, maintaining sales shelf cleanliness, and maintaining an organized sales floor backroom...
The Market at 25th
Richmond, VA
1 day ago
Appeals Team Lead
...service to our affiliated Universal Health Services hospitals. The Atlantic Region CBO is seeking a dynamic and talented Appeals Team Lead. The Appeals Team Lead is responsible for working in conjunction with the Appeals Manager to coordinate the operational activities...
Work at office
Local area
UHS
Richmond, VA
3 days ago
Lead Structured Cabling Tech
...Lead Structured Cabling Technician The Lead Structured Cabling Technician is responsible for overseeing the installation, maintenance, and testing of structured cabling systems for Wi-Fi Access Point (AP) installation projects. This role involves managing a team...
For contractors
Local area
ACAV and Associates LLC
Richmond, VA
15 hours ago
Manufacturing Team Lead
$25 - $30 per hour
...Manufacturing Team Lead The Manufacturing Team Lead oversees the complete mechanical and electrical assembly of units from start to finish in a hands-on production environment. This role combines technical assembly work with production line leadership, quality oversight...
Contract work
Temporary work
Work at office
Aerotek
Richmond, VA
20 hours ago
Security Lead
Job Posting Sorry, you have been blocked. You are unable to access carvana.com. This website is using a security service to protect itself from online attacks. The action you just performed triggered the security solution. There are several actions that could trigger...
Carvana
Richmond, VA
2 hours ago
Merchandising Lead
$21 - $29 per hour
...Outlined below are the optional preferred qualifications for this position. If none are listed, there are no preferred qualifications. Leading a team, Supervising experience to include hiring, evaluating, mentoring, developing, and managing the workload of others Primary...
Hourly pay
Minimum wage
Full time
Temporary work
Part time
Walmart
Richmond, VA
15 hours ago
AP Team Lead
...AP Team Lead WM Supercenter #2821 2410 Sheila Ln Richmond, VA 23225-2041 CP-2821-9073 $19.50 - $32.50/hr* Full time Shifts may vary Role Summary AP Team Lead What You'll Do You play a major role in how our customers feel when they leave the store. You might...
Hourly pay
Minimum wage
Full time
Temporary work
Part time
Shift work
Weekend work
Afternoon shift
Walmart
Richmond, VA
2 hours ago
Lead IT Project Manager
$138.8k - $231.3k
Lead It Project ManagerMcKesson is an impact-driven, Fortune 10 company that touches virtually every aspect of healthcare. We are known for delivering insights, products, and services that make quality care more accessible and affordable. Here, we focus on the health,...
McKesson
Richmond, VA
2 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Informatica ETL Lead. Be the first to apply!