Senior Informatica ETL Developer
TalentOla
Job Summary:
We are looking for a Senior Informatica ETL Developer with strong experience in Data Warehousing concepts and ETL development . The candidate should have hands-on expertise in designing, developing, and optimizing ETL pipelines using Informatica PowerCenter / Informatica Intelligent Cloud Services, along with deep understanding of data models, CDC, SCD, and performance tuning.
Key Responsibilities:
- Design and develop ETL pipelines to load data into Data Warehouse
- Work with multiple source systems (RDBMS, flat files, APIs) and integrate data into staging and DWH layers
- Build and maintain Fact and Dimension tables based on business requirements
- Implement Slowly Changing Dimensions (SCD Type 1, 2, 3) in ETL processes
- Handle Late Arriving Dimensions using industry best practices
- Implement Change Data Capture (CDC) mechanisms, including scenarios without timestamp columns
- Optimize long-running ETL sessions and improve performance using partitioning and tuning techniques
- Debug and optimize complex SQL queries and ETL workflows
- Work with clustered and non-clustered indexes , and understand row store vs column store
- Collaborate with business and analytics teams for data validation and reporting needs
Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Senior Informatica ETL Developer in Dallas, TX vacancy
- ...WiproContact: Meghana GorusuCompany: SRI Tech SolutionsSenior Informatica ETL DeveloperLocation - Dallas, TX / Cleveland, OH /... ...Type - FTEJob Description:We are seeking a highly skilled Senior Informatica ETL Developer to join our data engineering team. In this role, you...SeniorFull time
- ...ETL Developer Locations: Charlotte, NC; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Fargo, ND; Florham Park, NJ; Garden City... ...Develop new ETL and enhancements and modify existing code using Informatica PowerCenter. Work independently to develop, configure, and...Senior
The Dignify Solutions, LLC
Dallas, TX4 days ago - ...Surendra PenumalaCompany: SRI Tech SolutionsJob Title: Sr ETL DeveloperLocation - Dallas, TX ( DAY 1 onsite ) Prefer local... ...interview. JD :We are seeking a highly skilled and experienced Senior ETL Tools Developer with deep expertise in Microsoft Azure Data Factory (ADF)...SeniorFull timeLocal area
- ...days per week (Monday-Thursday) onsite in Addison TX. Required Skills: 10+ years of overall Data Engineering experience with a focus on ETL 5+ years of Snowflake ETL design & development Knowledge of SAP, SQL, and other data sources Good Data quality / Data validation...SeniorContract workLocal area
- ...ETL Developer Location: Strongsville OH/Pittsburgh, PA/Dallas, TX Duration: Full Time Job Description: ~ Informatica powercenter, IICS, Migration project, Unix, Data Quality Rules, Oracle, PLSQL, Hadoop. Roles & Responsibilities Looking for...SuggestedFull time
JConnect Infotech
Dallas, TX21 hours ago - ETL Developer / Data Engineer Location: Dallas, TX (Hybrid - Local Candidates Only) Interview Process: Onsite Interview Required Duration: Long-Term Contract Visa: GC / USC Only Strong ETL Developer/Data Engineer with expertise in ETL pipeline development, advanced SQL...SeniorLong term contractLocal area
- Key Responsibilities1. Backend & Microservices DevelopmentDesign, develop, and implement scalable, resilient microservices using Java and... ...application performance for low latency and high throughput.2. ETL & Data Pipeline EngineeringArchitect and maintain complex ETL/ELT...Senior
- ...stack agile team including Pega, Java, ETL, Data Engineers, VB (.NET), and Mainframe... ...with the business, mainframe, and Java/API developers to build and maintain Pega rulesets and... ...in Python, PySpark, SQL, ETL (Informatica or other) a plusExperience in Mainframe...SeniorFull time
- ...the exact job title and job location in your email message. ETL Developer This position requires someone to be onsite in an office... ...level ETL developer. This candidate should seamlessly utilize Informatica, Oracle, Teradata and Tableau with the latest in responsive database...Work at officeImmediate start
System One
Dallas, TX12 days ago - ...Extensive knowledge of Data Warehousing, ETL and BI Architectures, concepts, and frameworks... ...translation of mappings into code. Develop strategies for data collection and ingestion... .... Troubleshoot and optimize SQL and Informatica mappings and stored procedures. Syntricate...
$86.25k - $158.13k
...s success. As a Software Engineer Lead (ETL) within PNC's Retail Tech Core Debit Product... ...-quality outcomes. Requirements: -Informatica ETL development and design. -Leading... ...our employees to be heard, valued, and developed to do their best work. Being a great...Full timeTemporary workPart timeWork experience placementWork at officePNC
Dallas, TX1 day ago$115k - $141k
...[5] Salesforce.com point-and-click developer interface* Awareness of programmatic... ...as third-party integration tools and ETL (Such as Mulesoft, Informatica, Jitterbit etc. ) with [8] Salesforce... ...base salary pay range for a Senior Consultant is:* East Bay, San Francisco...SeniorTemporary workLocal area- ...Senior Business Intelligence Developer – BI / Data Analytics Sigma Inc. is seeking a Senior Business Intelligence Developer to support our client in... ...experienced BI professional with strong expertise in SQL, ETL, data modeling, data warehousing, Power BI, OBIEE, and...Senior
Sigma
Irving, TX3 days ago - ...technologies. The ideal candidate will be responsible for designing, developing, and implementing data-driven solutions that leverage agentic... ...deploying AI solutions.Solid understanding of data modeling, ETL processes, and data warehousing.Preferred Skills:Familiarity...SeniorWork at office
- ...Job Title: Sr BI Reports Developer Location: San Antonio, TX (Hybrid - 4/Week) Duration... ...Presentation/Design skills ETL Concepts Nice to haves skills/technologies... ...Hands on experience with any ETL tool (Informatica/Datastage) Certification in any of Tableau...SeniorContract workWork at office
Intellisoft Technologies
Farmers Branch, TX5 days ago - ...you and that’s why there’s nowhere like RSM.Senior Database DeveloperSummary:We are seeking an experienced Senior Database Developer for a temporary engagement to lead a critical... ...).Strong expertise in:Data migration, ETL processes, and integration tools (e.g., SSIS...SeniorFull timeTemporary workWork experience placementInternshipLocal area
- ...Senior Data Engineer Location: Richardson, TX (Hybrid T/W/TH) We are seeking a highly... ...and integrity. Build and optimize ETL/ELT pipelines using tools like DBT, Apache... ...various structured/unstructured sources. Develop modern APIs for secure data sharing...Senior
United IT
Richardson, TX20 hours ago $45 - $60 per hour
...Senior Business Intelligence Developer - Contract Position Overview Our client, a large healthcare organization, is seeking a Senior Business... ...intelligence solutions. Build and maintain ETL processes supporting data transformation, staging, cleansing...SeniorHourly payContract workTemporary workThe LaSalle Group
Irving, TX3 days ago$150k - $225k
...transforming how the world thinks about senior living and wellness-focused real estate.... ...organization.KEY RESPONSIBILITIESDesign, develop, and maintain scalable ELT data pipelines... ...implementing and managing data pipelines and ETL/ELT processesKnowledge of data modeling,...SeniorFull timeNight shift- ...WiproContact: Meghana GorusuCompany: SRI Tech SolutionsHadoop / ETL Developer and PySparkLocation - Dallas, TX / Atlanta, GA / Cleveland, OH... ...Type - FTEJob Description:We are seeking a highly experienced Senior Big Data & DevOps Engineer with 8+ years of professional...Full time
- ...Description Summary: The Information Services Developer Senior is primarily responsible for designing, developing, and implementing systems based on requirements. The candidate should have good knowledge of development methodologies and follow them while designing...SeniorFull timeWork experience placement
Christus Health
Irving, TX4 hours ago - Job Description Our client is seeking an experienced Senior Middleware Developer to join its growing Enterprise Applications team. This role is ideal... ...with: REST APIs SOAP Web Services XML JSON EDI SQL ETL processes Experience integrating cloud and on-premise enterprise...SeniorWork at officeMonday to Friday3 days per week
$88.9k - $165.1k
...Senior Software Engineer A subsidiary of Publicis Groupe, Epsilon is a leading provider... .... What You'll Achieve Design, develop, and maintain scalable backend services using... ..., data warehousing, and/or building ETL pipelines Cloud platforms (AWS / Azure...SeniorTemporary workFreelanceLocal areaFlexible hoursEpsilon
Irving, TX3 days ago- ...fixes to uphold the software quality standards Develop user training programs, documentation, and support... ...integration.Required Skill and Experience• Informatica development, Python, AWS, SQL, Oracle, and GitLab.• ETL Testing, Data Warehouse Testing, and Data Migration...Full timeTemporary workRelocation
- CRM Salesforce Developer Location: DFWDepartment: Salesforce Digital Experience / ITReports To: IT Manager - SalesforcePosition Summary Flowserve... ....Experience with relational databases, data modeling, and ETL tools.Experience supporting CRM projects for mid-market and...SeniorFull time
- MPOWERHealth is seeking a Senior Data Engineer to lead data integration and platform architecture in a hybrid role based in Addison, TX... ...across enterprise systems. Your work will emphasize Azure-based ETL/ELT pipelines, data governance, and collaboration with business...Senior
- ...and Microsoft Fabric. We are looking for a Senior BI Engineer to help lead that... ...tables, star schemas, and the T‑SQL and ETL behind them — that the business runs on.... .... Key Responsibilities Define, design, develop, document, and maintain dimensional data...SeniorTemporary workWork at officeRemote work
- ...AI pipelines to enable reasoning, planning, and decision-making.Develop and govern ontologies, taxonomies, and semantic data models that... ...experience in Python, with frameworks like TensorFlow, PyTorch, and ETL pipeline tools (e.g., Apache NiFi, Airflow)Practical experience...SeniorFull timeWork experience placementLive inWork at officeLocal area3 days per week
- Anblicks in Dallas is seeking a Senior Snowflake & dbt Engineer with 8+ years of data engineering experience to design, develop, and optimize data pipelines and modern data warehouses... ...be proficient with Snowflake, dbt, SQL, ETL/ELT development, and Azure cloud services,...Senior
$107.12k - $160.68k
...Applications DevelopmentCompany: CitiThe Applications Development Senior Programmer Analyst is an intermediate level position... ...analysis and programming activities.Responsibilities:Develop and maintain scalable ETL/ELT pipelines using PySpark, Spark SQL, and Delta Lake on...SeniorFull time
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Senior Informatica ETL Developer. Be the first to apply!
