Informatica ETL Senior Technical Specialist

Temporary

Noblesoft Technologies

Remote

Informatica ETL Senior Technical Specialist

Location: Richmond, VA (Local candidates preferred) Remote-OK

Mandatory skills:Informatica ETL, SQL, AWS, Snowflake

Job Summary

Job Description: Informatica ETL Lead (Onsite - USA)

Position Title: Informatica ETL Lead
Location: Onsite, USA
Experience: 10+ Years
Job 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 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 Senior Technical Specialist in Remote vacancy

Senior Technical Integration Specialist
$100k - $115k
...healthcare on a better path!! Job Description The Senior Technical Integration Specialist plays a pivotal part in onboarding new practices’... ...with data and technical integration projects that includes ETL pipeline, data normalization/processing, SFTP, and API...
Senior
Bi-weekly pay
Full time
Temporary work
For contractors
Local area
Remote work
Work from home
Flexible hours
Guidehealth
Boston, MA
18 days ago
Senior Informatica ETL/Data Engineer
...Job Description Job Description Senior Informatica ETL/Data Engineer (PowerCenter, Snowflake & Oracle) Total Required Experience in... ...quality and performance issues, and work with business and technical stakeholders throughout the SDLC. Key Responsibilities:...
Senior
Remote work
Siritech Solutions Corp
Austin, TX
3 days ago
Senior GIS Technical Specialist
Join the Clean Energy RevolutionBecome a Senior GIS Technical Specialist at Southern California Edison (SCE) and build a better tomorrow. In this job, you’ll be part of the Geospatial Analysis group within our Transmission & Distribution Business Unit. In this role, you...
Senior
Remote work
Relocation
Edison International
Pomona, CA
1 day ago
Senior Technical Support Specialist
The Senior Technical Support Specialist is responsible for leading the IT Operations team in technical processes, managing the standard Windows image and lifecycle, and administrating the Help Desk system. Like a Technical Support Specialist, this role also is a staffing...
Senior
Remote work
Bowen Health
Warsaw, IN
12 hours ago
Senior Technical Specialist - HW/SW
Job Description As the Technical Specialist - HW/SW integration for the SDV 2.0 Aggregator supporting the Ultifi platform, you will plan, lead, and execute SDV 2.0 hardware‑software as a product. You will provide technical direction for both internal GM teams and external...
Senior
Local area
Work from home
Relocation package
General Motors
Austin, TX
4 days ago
Senior Technical Integration Specialist
...team. Join us as we put healthcare on a better path!! The Senior Technical Integration Specialist plays a pivotal part in onboarding new practices’... ...with data and technical integration projects that includes ETL pipeline, data normalization/processing, SFTP, and API connections...
Senior
Full time
Remote work
Flexible hours
Guidehealth
Remote
18 days ago
Senior Technical Business Analyst
$84.58k - $111.09k
...our team as a Sr. Analyst I. We are seeking an experienced Senior Technical Business Analyst to support the development, integration, and... ...knowledge of data warehouse and Lakehouse concepts including ETL/ELT, batch/incremental processing, facts and dimensions, data...
Senior
NYU Langone Health
New York, NY
1 day ago
Senior Big Data Engineer (Java, Kafka, Spark, ETL)
...Opportunity SDA is seeking a Senior Big Data Engineer / Java Data... ...Elasticsearch | Oracle | SQL | ETL | Data Integration | Data... ...stakeholders to design and implement technical solutions. Support... ...Apache NiFi, AWS Glue, Talend, Informatica, Pentaho, or SSIS. Experience...
Senior
Full time
Remote work
Flexible hours
Systems Development and Analysis
Arlington, VA
3 days ago
Senior Technical Business Analyst
$81.5k - $138.55k
Senior Technical Business Analyst Location: US Remote Preferred: Virginia Remote (with local travel to ICF's office and client events as needed... ...data quality and surface inconsistencies or issues. Interpret ETL processes and data flows and work with technical teams to...
Senior
Full time
Contract work
Work experience placement
Local area
Remote work
Flexible hours
ICF International Inc
Reston, VA
1 day ago
Senior Power Generation Technical Specialist - FULLY REMOTE
$115k - $125k
...Job Description Job Description Senior Power Generation Technical Specialist Base Salary: $115,000 - $125,000 Health Insurance: 100% employer-paid for you + your dependents Location: Remote Schedule: Remote $130,000–$142,000 in compensation with base...
Senior
Remote job
Lionheart Critical Power
Huntley, IL
22 days ago
Senior Assoc, Technical Governance & Risk Management Specialist, Enterprise Architecture, Group Technology
...Key Responsibilities This is a specialized technical governance and risk management Specialist role. It requires expert human judgment and risk oversight that cannot be fully replicated by automated tools or AI. Key responsibilities include: Architectural Risk & Compliance...
Senior
Full time
DBS Bank Ltd
Remote
6 days ago
Senior Business Technical Analyst
$87.7k - $157.8k
...Position Purpose: Provides advanced business and technical expertise to design, build, validate, implement, and support complex data solutions... ...complex SQL queries, stored procedures, database structures, ETL processes, data pipelines, data models, and paginated and...
Senior
Full time
Part time
Work experience placement
H1b
Work at office
Remote work
Flexible hours
Centene Corporation
Missouri
2 days ago
Blue Yonder Sr Technical Platform Specialist
...employment authorization, now or in the future, for this role. The Senior Platform Specialist is the “go to” role for the business users needing... ...business areas as well as ensuring valuable innovative technical solutions are brought forward and considered.Key Responsibilities...
Senior
Full time
Local area
Remote work
Lineage Logistics
Novi, MI
1 day ago
Senior Data Engineer - ETL | Data Integration
...Engineering: Designing, configuring, and monitoring production grade ETL/ELT pipelines to ingest unstructured and structured data from... ...inconsistencies. Ensure data quality, consistency Provide technical leadership and define data integration best practices and standards...
Senior
Remote work
JerseySTEM
Florham Park, NJ
4 days ago
SR ETL/Informatica Developer
...POSITION SR ETL/Informatica Developer REQUIRED SKILLS Description We are seeking a talented and motivated Technology... ...to analyze business requirements and translate them into technical ETL solutions. Experience working with large datasets and...
Senior
Akaasa Technologies
Remote
2 days ago
Cyber Technical Specialist, Senior
$86.8k - $198k
Cyber Technical Specialist, SeniorThe Opportunity:As a cyber mission specialist, you understand the value of hunt-forward operations, and you... ...systems to aggregate threat feeds that inform briefings for senior leadership aligned to cyber modeling and simulation (M&S) support...
Senior
Full time
Contract work
Part time
Local area
Remote work
Worldwide
Booz Allen Hamilton
Suffolk, VA
5 hours ago
Enterprise Data Integration Engineer (Python/ETL) - Senior
$90k - $115k
...Job Description Enterprise Data Integration Engineer (Python/ETL) - Senior Location: On-location at Pentagon (Hybrid and Remote... ...validation, reconciliation, and quality assurance activities. Technical Collaboration Partner with application engineers, data...
Senior
Remote work
Montcure, LLC
Washington DC
a month ago
Senior Technical Support Specialist
...Providing advanced functional and technical support for customers using ERP integrations, the full-time Senior Technical Support Specialist will troubleshoot complex issues related to payment processing and accounting while collaborating with cross-functional teams in...
Senior
Full time
Remote work
Virtual Vocations Inc
United States
4 days ago
Senior Technical Analyst
Job DescriptionVirginia Tech is seeking a collaborative, highly motivated, and expert Senior Technical Analyst to lead the Data and Analytics division of the Human Resources Information Technology (HRIT) department. Reporting directly to the Senior Director of HR Information...
Senior
Remote work
Virginia Tech
Blacksburg, VA
3 days ago
Senior Help Desk Technician
...Providing remote technical support for a production fleet of ATMs, the part-time Senior Help Desk Technician will troubleshoot hardware and software issues, assist field service technicians, and ensure high availability in a fast-paced environment. Key responsibilities...
Senior
Part time
Remote work
Night shift
Weekend work
Virtual Vocations Inc
United States
4 days ago
Senior AI Research Systems Support Data Analyst
$140k - $160k
...We require experience with SQL, Python, ETL processes, databases, and analytics/reporting... ...skills, including the ability to present technical findings to executive and non-technical... ...clients nationwide. We are seeking a Senior Data Analyst to support AI, analytics, and...
Senior
Temporary work
Work at office
Remote work
Document Storage Systems Inc
Alexandria, VA
15 days ago
Senior Technical Support Specialist
...Senior Technical Support SpecialistAs the Sr. Technical Support Specialist, you are a vital part of the IT Team. In this role, you are responsible for investigating, diagnosing, and resolving technical support issues for the ministry. This individual serves as an advanced...
Senior
Permanent employment
Temporary work
Work at office
Local area
Remote work
Addison Group
Washington DC
1 day ago
Senior IT Support Analyst
...measures to avoid a significant regulatory failure, compliance violation or a material data breach. Job Summary We are looking for a Senior IT professional to join our team in the SLC office to manage our Help Desk, assist in training new employees, and help improve our...
Senior
Full time
Temporary work
Work at office
Remote work
Socket
Salt Lake City, UT
1 day ago
Senior Technical Claims Specialist, Construction Complex
$83k - $157k
...Description Looking for an amazing new claims opportunity? Senior Complex Construction Claims Specialist - Complex CGL & Construction Liability (Litigated, $5... ...role is a great fit for you Work exclusively on technically complex, high-exposure construction-related casualty...
Senior
Full time
Work at office
Local area
Immediate start
Remote work
Home office
Liberty Mutual Insurance
Boston, MA
1 day ago
Senior IT Service Desk Technician
...Old Republic Bitco is seeking a Senior IT Service Desk Technician to join our office located in Atlanta, GA . As a respected specialty... ...services across Old Republic Bitco. You'll serve as a senior technical resource within Client Services, resolving complex technical...
Senior
Temporary work
Work experience placement
Work at office
Remote work
BITCO Insurance Companies
Duluth, GA
12 hours ago
Senior Field Applications Specialist - Mass Spectrometry - LA/San Diego
$80.3k - $149.1k
...matters.The PositionSenior Field Applications Specialist - Mass Spectrometry - West Coast (San... ...what makes us Roche.The OpportunityAs a Senior Field Applications Specialist (Sr. FAS)... ...team and the primary scientific and technical authority for Roche’s novel automated mass...
Senior
Full time
Work experience placement
Local area
Relocation package
Shift work
Night shift
Roche
San Diego, CA
5 hours ago
Senior Help Desk Technician
$34.84 per hour
...Overview SENIOR HELP DESK TECHNICIAN (BHAK): Bowhead is currently seeking/searching for a qualified On-Site Senior Help Desk Technician to deliver exceptional technical assistance to our end-users in Anchorage, AK. The selected candidate will be accountable for offering...
Senior
Work experience placement
Work at office
Remote work
Relocation
uiccareers-uicalaska
Anchorage, AK
2 days ago
ETL/Data Migration Engineer (Senior)
...to be Performed: AnaVation is seeking an experienced ETL/Data Migration Engineer (Senior) to join our growing Huntsville, Alabama-based work program... ...modern cloud platforms. The engineer serves as a senior technical contributor within the Migration Workstream, ensuring...
Senior
Full time
Temporary work
Immediate start
Remote work
AnaVation
Huntsville, AL
3 days ago
Senior Technical Risk Analyst (Controls Testing)
...organizational, planning, and time management skills.Effective skill communicating with all levels within an organization, including technical and non-technical stakeholders.Experience working on cross-functional, multi-dimensional teams and projects.Effective skill...
Senior
Internship
Monday to Friday
Navy Federal Credit Union
Vienna, VA
4 days ago
Senior Technical Support Specialist
Overview/ Job Responsibilities We are seeking Senior Technical Support Specialist to provide advanced macOS, Jamf, and mobile device support across enterprise environments, delivering exceptional white-glove service to executives, senior leadership, and VIP stakeholders...
Senior
Remote work
Sev1Tech LLC
Arlington, VA
1 day ago

Do you want to receive more vacancies?

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