Informatica ETL Senior Technical Specialist

Diverse Lynx

Richmond, VA

Job Description

Job Summary

Job Description: Informatica ETL Lead (Onsite - USA)

Position Title: Informatica ETL Lead

Job Summary

We are seeking an experienced Informatica ETL Lead with 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.
Eligible to workimize 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

IT experience with strong expertise in ETL and Data Warehousing .
Hands-on experience with Informatica PowerCenter .
Strong experience in ETL design, development, and performance tuning.
Extensive experience with SQL , query Eligible to workimization, 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 Eligible to workP.
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.

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.
Eligible to workimize 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.

Apply

Vacancy posted 16 days ago

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

Senior Data Science Analyst/ Data Engineer
...Overview: Role Summary: The Senior Data Engineer is a handson expert and technical leader, actively engaged in... ...Build endto-end data pipelines and ETL/ELT solutions to support analytics... ...ELT platforms (e.g., Talend, dbt, Informatica). Deep understanding of data...
Senior
Full time
PTR Global
Richmond, VA
14 days ago
Senior Help Desk Technician
User Access Provisioning Analyst | Identity & Access Management (IAM) | Enterprise IT Operations Pay: Up to $22/hr W2 Contract: W2 Contract | 2 Openings Duration: 12 Months Schedule: Onsite Location: Richmond, VA If you have experience managing user...
Senior
Contract work
Swoon
Richmond, VA
1 day ago
Senior Data Engineer
...Senior Data Engineer | Richmond, VA (Hybrid) 26-00558 Onsite;... ...enterprise-scale data pipelines and ETL/ELT solutions. Build high-... ...initiatives. Required Technical Skills Advanced SQL, ELT... ...such as Talend, dbt, or Informatica. Strong understanding of data...
Senior
Full time
H1b
Work at office
Local area
Remote work
TM Floyd & Company (TMF)
Richmond, VA
2 days ago
Control Systems Technical Senior Specialist
...you could help make great things possible not only in your community, but around the world. In the role of Control Systems Technical Senior Specialist, we'll count on you to:The Control Systems Technical Senior Specialist will have responsibility for programming, testing,...
Senior
Local area
HDR
Glen Allen, VA
6 hours ago
Senior Data Engineer (AWS, Azure, GCP)
$90k - $200k
...engineered solution. Provide technical leadership and collaborate within... ...with at least one ETL / Data Orchestration technology... ...technology (Azure Data Factory, SSIS, Informatica, Alteryx, Ab Initio, Pentaho,... ...level: Mid-Senior LevelIndustry: Management Consulting
Senior
Work at office
Remote work
Visa sponsorship
Work visa
Flexible hours
CapTech
Richmond, VA
4 days ago
Senior Programmer Analyst (.Net, application support)
...Job Description Position: Senior Programmer Analyst (.Net, application support) Location: Richmond Virginia 23219 (Hybrid)... ...candidates will be responsible for understanding business needs and technical specifications to build and implement automation solutions....
Senior
Full time
PTR Global
Richmond, VA
14 days ago
Decision Support Analyst
$68.4k
...business partners. Mentor colleagues with less experience on both the technical and business aspects of project and consultative work.... ...comfortable presenting findings and offering recommendations to senior management. Language (Other than English): None Travel Requirement...
For contractors
Work at office
Local area
Highmark Health
Richmond, VA
2 days ago
Supply Chain Optimization Data Scientist Senior Consultant
$116.2k - $229.1k
...or execution processes into functional or technical requirements.· Experience integrating... ...data through extract, transform, and load (ETL), extract, load, and transform (ELT), or... ...development From entry-level employees to senior leaders, we believe there’s always room to...
Senior
Local area
Deloitte
Richmond, VA
4 days ago
Senior Data Scientist/Engineer and Application Developer
$91.1k - $179.5k
...business needs. The ideal candidate brings technical experience in data engineering, strong... ...building, and maintaining data pipelines and ETL/ELT workflows3+ years of experience using... ...From entry-level employees to senior leaders, we believe there’s always room to...
Senior
Deloitte
Richmond, VA
15 hours ago
IT - Senior Technology Architect | Data Management - Data Integration | Talend
...role will implement a Monte Carlo based Data Observability solution integrated with Snowflake, Exadata, SQL Server, dbt, Talend, Informatica, and Denodo to provide proactive monitoring, lineage, data quality, and SLA visibility. Enable automated anomaly detection, root...
Senior
Contract work
Ampcus Incorporated
Richmond, VA
16 days ago
Senior Platform Engineer - Azure Data Platforms & DevOps
$96.7k - $145k
...business hours of 9am-5pm EST.YOUR ROLEAs a Senior Platform Engineer - Azure Databricks,... ...operational excellence.You will serve as a senior technical resource responsible for defining and... ....Working knowledge of data integration, ETL/ELT processes, event streaming, analytics...
Senior
Full time
Work experience placement
Work at office
Remote work
Genworth Financial
Richmond, VA
3 days ago
Senior Engineer, ADL Platform Admin
...your future as we are, join our team.KPMG is currently seeking a Senior Engineer, ADL Platform Administrator to join our Digital Nexus... ...controls), and integrating enterprise tools like Salesforce, Informatica, Oracle, and SAP HANAStrong understanding of Azure Key Vault,...
Senior
Work experience placement
H1b
Local area
KPMG
Richmond, VA
15 hours ago
Cyber Data Privacy Specialist - Senior Consultant
$105.4k - $207.8k
Position Summary As a Senior Consultant in Deloitte’s Digital Trust & Privacy practice... ...with client stakeholders to gather technical, functional, and business requirements... ...Marketing Cloud), Master Data Management (e.g., Informatica MDM) and middleware (MuleSoft, Kafka)...
Senior
Local area
Deloitte
Richmond, VA
1 day ago
Genesys Technical Specialist
...as a platform expert, and enable LMI’s delivery teams to maximize value from the partnership. The ideal candidate blends Genesys technical acumen with business development savvy, and thrives in a mission-driven, collaborative environment.LMI is a new breed of digital solutions...
LMI
Richmond, VA
3 days ago
Senior Technology Architect | Data Management - Data Integration | Talend
...role will implement a Monte Carlo based Data Observability solution integrated with Snowflake, Exadata, SQL Server, dbt, Talend, Informatica, and Denodo to provide proactive monitoring, lineage, data quality, and SLA visibility. Enable automated anomaly detection, root...
Senior
Contract work
IMCS Group Inc
Richmond, VA
16 days ago
Senior Programmer Analyst - .NET
...Job Title: Senior Programmer Analyst - .NET Max pay rate: $55/hr w2 + benefits Primary location of assignment: Richmond, VA... ...candidates will be responsible for understanding business needs and technical specifications to build and implement automation solutions....
Senior
Full time
Pinnacle Group, Inc.
Richmond, VA
4 days ago
Technical Support Specialist
...written communication skills, customer servicetalents to help non-technical usersand exceptional time management skills. Here you will be... ...of advanced technologies and be able to work side by side with senior team members to increase your knowledge. Our clients are...
Full time
Work at office
Weekend work
Afternoon shift
Core Managed
Richmond, VA
15 hours ago
Help Desk Specialist
$45k - $55k
...experience About the Role IT Help Desk Specialist I Star Children's Dress Company, Inc.... ...Help Desk Specialist I to provide on-site technical support for our Virginia Distribution Center... ...them appropriately. Coordinate with senior IT personnel and outside technology...
Full time
Work at office
Monday to Friday
Rare Editions
Richmond, VA
3 days ago
Information Technology Help Desk Technician
...shape the future of banking, you’ll feel right at home here. General Job Summary: The IT Help Desk Technician provides first-line technical support for Bank employees and assists in maintaining a secure, reliable, and efficient technology environment. This position is...
Full time
Work experience placement
Remote work
Newhorizonbank
Richmond, VA
15 hours ago
Service Desk Analyst
$70k - $80k
...development, security, and operational best practices across multiple classification levels. The main customer-facing team provides technical support and guidance throughout the customer lifecycle, enabling users to access and effectively utilize the PAAS offerings and...
Remote work
GXM Technologies
Richmond, VA
2 days ago
Technical Support Specialist
Technical Support Specialist Dahlgren, VA Active Secret Clearance needed to apply Cornerstone Defense is the Employer of Choice within the Intelligence, Defense, and Space communities of the U.S. Government. Realizing early on that our most prized assets are our employees...
Remote work
Cornerstone Defense LLC
Richmond, VA
15 hours ago
Senior/Lead Electrical Engineer, Power Distribution (Data Centers)
...electrical design in house for the first time. The role As the senior electrical engineer, you will own power distribution from the... ...function as the portfolio grows. This suits a senior engineer, technical lead or working manager who wants to build out their own team....
Senior
Permanent employment
Remote work
Root Edge
Richmond, VA
3 days ago
Senior Data Engineer
...Job Title: Senior Data Engineer Location: Mclean, VA/ Richmond, VA - Hybrid Duration: 07+ Months Contract with Extension Job id – 180924 Responsibilities : Designing and implementing high-performance data pipelines that handle large volumes of data...
Senior
Contract work
PTR Global
Richmond, VA
3 days ago
Senior Programmer Analyst
...Senior Programmer Analyst | Richmond, VA (Onsite) 26-00556 Onsite; candidates must be local or able to commute to Richmond, VA... ...Agile product support team to understand business needs, develop technical solutions, automate processes, and maintain critical enterprise...
Senior
Full time
Contract work
H1b
Local area
TM Floyd & Company (TMF)
Richmond, VA
4 days ago
Senior Staff Principal Enterprise Architect (Data Analytics and AI)
...exposure to applications, data, infrastructure, and integration technologies. A minimum of 2 years additional directly related technical experience is required. Experience designing and implementing complex enterprise data and analytics architectures using Databricks...
Senior
Full time
Work experience placement
brk tech, A Berkshire Hathaway Group Company
Glen Allen, VA
2 days ago
Senior Data Engineer
$85.5k - $110k
...visit our Careers page. The Role in Brief: Senior Data Engineer The Senior Data Engineer... ...offerings. The role combines people leadership, technical and operational judgment, and a partner-... ...how data flows across systems, including ETL pipelines, data mapping, validation, and...
Senior
Work experience placement
Work at office
Immediate start
Remote work
Flexible hours
EAB
Richmond, VA
15 hours ago
Senior Quality Assurance Automation Engineer
$80k - $100k
Senior Quality Assurance Automation Engineer Duration: 12 Months About the Role Evaluate test automation tools and lead the transition from manual to automated testing. Build and implement test automation frameworks, provide QA support, and define/update quality standards...
Senior
Contract work
Work experience placement
Radiant Digital
Richmond, VA
15 hours ago
Senior Technical Account Manager
...capabilities built in such as security, compliance controls, and observability. For more information, visit EDB is hiring a Senior Technical Account Manager (TAM) for US. The Senior TAM is responsible for building and maintaining post-sales relationships with EDB's largest...
Senior
Remote work
EDB
Richmond, VA
2 days ago
Senior Manager, Data Analysis
$200.7k - $229.1k
...Senior Manager, Data Analysis At Capital One, data is at the center of everything we do. When we launched as a startup we disrupted... ...business‑impacting analytical tools. You will enhance your technical and analytical skills, while also working with leaders to influence...
Senior
Full time
Part time
Local area
Capital One Group
Richmond, VA
2 days ago
Senior Network Engineer
$100k - $125k
...Senior Network Engineer Virginias community colleges have a 50-year track record of educational excellence and innovation to serve... ...and work well with everyone from the highest levels of technical management to staff level. To understand a technical environment...
Senior
Work experience placement
Work at office
Local area
Remote work
Weekend work
Virginia Community Colleges
Richmond, VA
2 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Informatica ETL Senior Technical Specialist. Be the first to apply!