> Markdown version of [/jobs/ext/2923771-data-engineer-informatica](https://www.wearedevelopers.com/jobs/ext/2923771-data-engineer-informatica). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Engineer - Informatica - **Company:** Conquest Consulting - **Location:** Austin, TX, United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Query Performance, Application Programming Interfaces (APIs), Data Analysis, CA Workload Automation Ae, Information Engineering, Data Integration, Extract Transform Load (ETL), Data Mapping, Data Transformation, Data Structures, Relational Databases, Document-Oriented Databases, Job Scheduling, Mainframes, Operational Databases, Oracle Databases, Oracle (Applications), Oracle SQL Developer, Performance Tuning, Process Driven Development, Systems Development Life Cycle, Software Requirements Analysis, SQL Stored Procedures, PL-SQL, SQL Databases, Data Streaming, Enterprise Data Management, Data Processing, Data Ingestion, Informatica Powercenter, Snowflake, Informatica Cloud, Database Performance, Sap Business Objects, Information Technology, Enterprise Integration, Data Delivery, Data Pipelines, Control M - **Published:** September 15, 2026 - **Apply:** https://www.dice.com/job-detail/38ee8c79-ec43-44b3-9998-949b879256cc ## About the Role * 15+ years of overall IT experience - Mandatory. * Experience as a Data Engineer / Systems Analyst designing, developing, and supporting enterprise data integration solutions. * Strong hands-on experience with Informatica PowerCenter. * Experience developing and maintaining Informatica mappings, sessions, workflows, and reusable transformations. * Strong experience with Oracle SQL/PL-SQL. * Experience with Oracle stored procedures, packages, and performance tuning. * Experience ingesting data from multiple heterogeneous sources into Oracle databases. * Hands-on experience with Snowflake, including data loading, schema design, and query performance optimization. * Experience with Informatica PowerCenter and/or Informatica Cloud Data Integration (IICS). * Strong experience gathering data requirements and performing source-to-target mapping. * Experience documenting data flows, transformation rules, and technical design specifications. * Strong experience troubleshooting production ETL pipelines, job failures, data quality issues, and performance bottlenecks. * Experience with Control-M, AutoSys, Informatica Scheduler, or similar job scheduling/orchestration tools. * Experience with SAP Business Objects Universe design and/or maintenance. * Experience working in a state government or large enterprise IT environment. * Familiarity with formal SDLC and change management processes. Technical Environment ETL / Integration: Informatica PowerCenter, Informatica Cloud Data Integration, ETL/ELT Databases: Oracle, Snowflake, SQL, PL/SQL Data Engineering: Data Integration, Data Ingestion, Source-to-Target Mapping, Data Quality, Data Transformation Scheduling: Control-M, AutoSys, Informatica Scheduler BI / Reporting: SAP Business Objects, Universe Design/Maintenance Development Methodology: SDLC, Change Management, Production Support Ideal Candidate Profile The ideal candidate will have extensive enterprise-level experience across: Informatica PowerCenter + Oracle SQL/PL-SQL + Snowflake + ETL/ELT + Data Integration + Source-to-Target Mapping + Heterogeneous Data Ingestion + Production ETL Support + SAP Business Objects Strong analytical, problem-solving, communication, documentation, and stakeholder management skills are required. ## Description The State of Texas is seeking a highly experienced Senior Data Engineer with strong expertise in Informatica PowerCenter, Oracle SQL/PL-SQL, Snowflake, Data Integration, ETL/ELT, and SAP Business Objects. The ideal candidate will have extensive experience designing, developing, implementing, troubleshooting, and supporting enterprise data integration and data engineering solutions in large-scale environments. The candidate should be comfortable working with heterogeneous data sources, developing complex ETL workflows, performing source-to-target mapping, resolving production data quality issues, optimizing ETL performance, and collaborating with both technical and business stakeholders. Top 10 Required Skills 1. Informatica PowerCenter / ETL 2. Oracle SQL / PL-SQL 3. Data Integration / Data Engineering 4. Snowflake 5. ETL / ELT 6. Source-to-Target Mapping & Data Requirements 7. Heterogeneous Data Ingestion 8. ETL Production Support & Data Quality 9. Job Scheduling / Batch Orchestration 10. SAP Business Objects, * Design, develop, implement, and support enterprise data integration and data engineering solutions. * Develop and maintain complex Informatica PowerCenter ETL workflows, including mappings, sessions, workflows, and reusable transformations. * Design and implement scalable ETL/ELT processes for enterprise data environments. * Ingest data from multiple heterogeneous source systems, including flat files, APIs, relational databases, mainframe extracts, and other enterprise sources. * Develop and optimize Oracle SQL and PL/SQL, including stored procedures, packages, and ETL-related queries. * Work with Snowflake for data loading, schema design, data integration, and query performance optimization. * Develop cloud-based ETL/ELT solutions using Informatica Cloud Data Integration (IICS) where applicable. * Gather and analyze data requirements from business and technical stakeholders. * Perform source-to-target mapping and document data flows, transformation rules, and technical design specifications. * Analyze business objectives, operational procedures, and system requirements to identify opportunities for automation and system improvements. * Evaluate alternative technical solutions and contribute to feasibility and cost/benefit analysis. * Analyze existing computer systems and data processing procedures to determine opportunities for enhancements and improvements. * Translate user requirements into detailed functional and technical specifications for data engineering and system development activities. * Collaborate with organizational units and stakeholders to understand data inputs, outputs, reporting requirements, data structures, and processing needs. * Troubleshoot and resolve ETL job failures, data quality issues, data discrepancies, and performance bottlenecks in production environments. * Monitor ETL pipelines and batch processes to ensure successful and timely data delivery. * Work with job scheduling and orchestration tools such as Control-M, AutoSys, or Informatica Scheduler. * Support production releases, change requests, incident resolution, and system enhancements. * Develop, maintain, and troubleshoot SAP Business Objects Universes and related reporting environments. * Perform ETL and database performance optimization to improve processing efficiency and reliability. * Maintain technical documentation related to ETL workflows, data mappings, system processes, and data integration solutions. * Participate in structured SDLC, change management, testing, implementation, and production support activities. * Collaborate with developers, database administrators, business analysts, QA teams, architects, and business stakeholders. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Brewing Tea over the Internet](https://www.wearedevelopers.com/videos/697-brewing-tea-over-the-internet) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Business Strategies for Scaling European Tech](https://www.wearedevelopers.com/videos/1694-business-strategies-for-scaling-european-tech) - [Hacking AI at the Edge of the Indian Ocean](https://www.wearedevelopers.com/videos/100177-hacking-ai-at-the-edge-of-the-indian-ocean) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [The 12 Best Jobs for Software Engineers](https://www.wearedevelopers.com/magazine/401-the-12-best-jobs-for-software-engineers)