Siritech Solutions Corp
Bellville, Texas
Job Description Job Description Senior Informatica ETL/Data Engineer (PowerCenter, Snowflake & Oracle) Total Required Experience in Years: 12 + Years Mode of Work: Hybrid 3 Days Onsite / 2 Days Remote Must Currently Reside Within 50 Miles of Austin, TX The Senior Informatica ETL/Data Engineer will design, develop, implement, and support enterprise data-integration solutions using Informatica PowerCenter, Informatica Cloud Data Integration, Oracle SQL/PL-SQL, and Snowflake . The role requires extensive hands-on experience developing ETL/ELT workflows, mappings, sessions, transformations, data-ingestion pipelines, and batch-processing solutions. The engineer will also troubleshoot production pipelines, resolve data-quality and performance issues, and work with business and technical stakeholders throughout the SDLC. Key Responsibilities: Design, develop, and support enterprise ETL/ELT solutions. Develop Informatica PowerCenter mappings, sessions, workflows, and reusable transformations. Develop cloud-based integrations using Informatica Cloud Data Integration. Ingest data from heterogeneous source systems. Integrate flat files, APIs, relational databases, and mainframe extracts. Load and transform enterprise data into Oracle and Snowflake environments. Develop complex Oracle SQL and PL/SQL. Develop and maintain Oracle stored procedures and packages. Perform ETL-related SQL and database performance tuning. Develop Snowflake data-loading processes. Support Snowflake schema design and query optimization. Gather and analyze business and data requirements. Develop source-to-target mappings and data-flow specifications. Troubleshoot production ETL pipelines and job failures. Additional Responsibilities: Identify and resolve data-quality issues. Diagnose and resolve ETL performance bottlenecks. Optimize mappings, workflows, SQL queries, and batch processes. Support job scheduling and orchestration. Monitor scheduled enterprise batch loads. Analyze existing systems and identify data-processing improvements. Develop technical and data-flow documentation. Support production deployments and change-management activities. Work within formal SDLC processes. Collaborate with business analysts, database teams, application teams, and technical stakeholders. Support SAP BusinessObjects Universe design or maintenance where applicable. Required Skills: Minimum 8+ years as a Data Engineer/Systems Analyst designing, developing, and supporting enterprise data-integration solutions. Minimum 8+ years of hands-on Informatica PowerCenter experience. Strong experience developing: Mappings Sessions Workflows Reusable Transformations Minimum 8+ years ingesting data from heterogeneous sources, including: Flat Files APIs Relational Databases Mainframe Extracts Minimum 8+ years of strong Oracle SQL/PL-SQL experience. Experience developing Oracle stored procedures and packages. Experience tuning ETL-related Oracle queries. Minimum 8+ years of Snowflake experience, including data loading, schema design, and query-performance optimization. Minimum 8+ years with Informatica PowerCenter and/or Informatica Cloud Data Integration for cloud ETL/ELT. Minimum 8+ years gathering data requirements and performing source-to-target mapping. Experience documenting data-flow and design specifications. Minimum 8+ years troubleshooting data-quality issues, ETL job failures, and performance bottlenecks. Minimum 8+ years using batch scheduling/orchestration tools such as: Control-M AutoSys Informatica Scheduler Preferred Skills: Minimum 3+ years of SAP BusinessObjects Universe design and/or maintenance experience. Minimum 3+ years working within a state-government or large enterprise IT environment. Experience following formal SDLC processes. Experience with enterprise change-management processes. Large-scale data migration and integration experience. Cloud-based ETL/ELT implementation experience. Enterprise data-quality and production-support experience. Qualifications: Strong hands-on Informatica development expertise. Strong Oracle SQL/PL-SQL and Snowflake capabilities. Strong understanding of ETL/ELT architecture and data-integration patterns. Strong troubleshooting and root-cause-analysis skills. Ability to optimize complex data-processing pipelines. Strong analytical and problem-solving capabilities. Strong technical documentation skills. Ability to translate business requirements into technical data solutions. Strong written and verbal communication skills. Ability to work effectively with business and technical stakeholders. Must currently reside within a 50-mile radius of Austin, TX . Must be willing to work 3 days onsite and 2 days remotely . Work arrangement is subject to change. Education: Education requirements were not specified in the provided requirement . Certifications: Informatica PowerCenter Certification Preferred Informatica Cloud Data Integration Certification Preferred Snowflake SnowPro Certification Preferred Oracle Database / PL-SQL Certification Preferred
Job Description Job Description Senior Informatica ETL/Data Engineer (PowerCenter, Snowflake & Oracle) Total Required Experience in Years: 12 + Years Mode of Work: Hybrid 3 Days Onsite / 2 Days Remote Must Currently Reside Within 50 Miles of Austin, TX The Senior Informatica ETL/Data Engineer will design, develop, implement, and support enterprise data-integration solutions using Informatica PowerCenter, Informatica Cloud Data Integration, Oracle SQL/PL-SQL, and Snowflake . The role requires extensive hands-on experience developing ETL/ELT workflows, mappings, sessions, transformations, data-ingestion pipelines, and batch-processing solutions. The engineer will also troubleshoot production pipelines, resolve data-quality and performance issues, and work with business and technical stakeholders throughout the SDLC. Key Responsibilities: Design, develop, and support enterprise ETL/ELT solutions. Develop Informatica PowerCenter mappings, sessions, workflows, and reusable transformations. Develop cloud-based integrations using Informatica Cloud Data Integration. Ingest data from heterogeneous source systems. Integrate flat files, APIs, relational databases, and mainframe extracts. Load and transform enterprise data into Oracle and Snowflake environments. Develop complex Oracle SQL and PL/SQL. Develop and maintain Oracle stored procedures and packages. Perform ETL-related SQL and database performance tuning. Develop Snowflake data-loading processes. Support Snowflake schema design and query optimization. Gather and analyze business and data requirements. Develop source-to-target mappings and data-flow specifications. Troubleshoot production ETL pipelines and job failures. Additional Responsibilities: Identify and resolve data-quality issues. Diagnose and resolve ETL performance bottlenecks. Optimize mappings, workflows, SQL queries, and batch processes. Support job scheduling and orchestration. Monitor scheduled enterprise batch loads. Analyze existing systems and identify data-processing improvements. Develop technical and data-flow documentation. Support production deployments and change-management activities. Work within formal SDLC processes. Collaborate with business analysts, database teams, application teams, and technical stakeholders. Support SAP BusinessObjects Universe design or maintenance where applicable. Required Skills: Minimum 8+ years as a Data Engineer/Systems Analyst designing, developing, and supporting enterprise data-integration solutions. Minimum 8+ years of hands-on Informatica PowerCenter experience. Strong experience developing: Mappings Sessions Workflows Reusable Transformations Minimum 8+ years ingesting data from heterogeneous sources, including: Flat Files APIs Relational Databases Mainframe Extracts Minimum 8+ years of strong Oracle SQL/PL-SQL experience. Experience developing Oracle stored procedures and packages. Experience tuning ETL-related Oracle queries. Minimum 8+ years of Snowflake experience, including data loading, schema design, and query-performance optimization. Minimum 8+ years with Informatica PowerCenter and/or Informatica Cloud Data Integration for cloud ETL/ELT. Minimum 8+ years gathering data requirements and performing source-to-target mapping. Experience documenting data-flow and design specifications. Minimum 8+ years troubleshooting data-quality issues, ETL job failures, and performance bottlenecks. Minimum 8+ years using batch scheduling/orchestration tools such as: Control-M AutoSys Informatica Scheduler Preferred Skills: Minimum 3+ years of SAP BusinessObjects Universe design and/or maintenance experience. Minimum 3+ years working within a state-government or large enterprise IT environment. Experience following formal SDLC processes. Experience with enterprise change-management processes. Large-scale data migration and integration experience. Cloud-based ETL/ELT implementation experience. Enterprise data-quality and production-support experience. Qualifications: Strong hands-on Informatica development expertise. Strong Oracle SQL/PL-SQL and Snowflake capabilities. Strong understanding of ETL/ELT architecture and data-integration patterns. Strong troubleshooting and root-cause-analysis skills. Ability to optimize complex data-processing pipelines. Strong analytical and problem-solving capabilities. Strong technical documentation skills. Ability to translate business requirements into technical data solutions. Strong written and verbal communication skills. Ability to work effectively with business and technical stakeholders. Must currently reside within a 50-mile radius of Austin, TX . Must be willing to work 3 days onsite and 2 days remotely . Work arrangement is subject to change. Education: Education requirements were not specified in the provided requirement . Certifications: Informatica PowerCenter Certification Preferred Informatica Cloud Data Integration Certification Preferred Snowflake SnowPro Certification Preferred Oracle Database / PL-SQL Certification Preferred
9th Way Insignia
Washington, Washington DC
Job Description Job Description 9th Way Insignia is a service-disabled, veteran-owned small business bringing transformative technology to our government customers so they can achieve their missions. Our specialties include cybersecurity, cloud modernization, software development, data analytics, enterprise architecture, enterprise IT, analytics, process automation, and artificial intelligence. Learn more about 9th Way Insignia at Application password: Niner Team (Project) Introduction The Office of Performance Analysis and Integrity manages and enhances the Veterans Benefits Administration (VBA) Enterprise Data Warehouse (EDW) which resides on one Oracle M8 Supercluster database and thirteen application servers. Our team provides the technical services required to sustain EDW applications to include Project Management, Data Warehouse Management, Advanced Analytics, Tableau Server Administration/Tableau Desktop Administration, Technical Collaboration Support, Lessons Learned, Executive Orders and Special Projects, Architectural Enhancement, and Cloud Migration. We also provide management, enhancement, integration, implementation, maintenance, modernization, and infrastructure support for EDW applications as well as enhancement and maintenance of business intelligence capabilities and predictive analytics. 9th Way Insignia is looking for a Senior Informatica PowerCenter Migration Engineer to join and lead this team. We are seeking a hands-on Senior Informatica PowerCenter Migration Engineer to support the migration of the VA Enterprise Data Warehouse (EDW) from an on-premises Oracle environment to Oracle Cloud Infrastructure (OCI) within the VA Enterprise Cloud environment. This role will be responsible for assessing, configuring, migrating, validating, and optimizing Informatica PowerCenter ETL workloads supporting a large, business-critical data warehouse. The successful candidate will bring practical experience configuring enterprise ETL environments, executing migration activities, validating large-scale data movement, and resolving production-grade ETL issues. Responsibilities: Assess existing Informatica PowerCenter ETL workflows, repositories, dependencies, source-to-target mappings, schedules, parameter files, and operational procedures. Configure and support Informatica PowerCenter components in the OCI cloud environment. Plan and execute migration of Informatica ETL processes across development, test, pre-production/UAT, and production environments. Validate migrated ETL streams to confirm source-to-target requirements are fulfilled and data is not lost during the load process. Develop and execute automated and repeatable data-reconciliation processes, including record counts, control totals, aggregate comparisons, exception reporting, and source-to-target validation. Troubleshoot ETL failures, data discrepancies, performance bottlenecks, and connectivity issues. Optimize and tune Informatica jobs to improve nightly-load performance and meet operational processing requirements. Coordinate with Oracle database, GoldenGate, cloud infrastructure, networking, security, and EDW technical teams on migration dependencies and cutover readiness. Support cloud setup, configuration, provisioning, account/privilege planning, migration readiness, deployment, rollback, and post-implementation activities. Develop and maintain ETL design documentation, test plans, test-results reports, migration runbooks, restart/recovery procedures, and configuration-management artifacts. Support defect tracking, root-cause analysis, change control, production-readiness reviews, and knowledge transfer. Follow applicable VA security, architecture, configuration-management, and change-control processes. Requirements: Minimum 10 years of relevant experience in hands-on experience administering, configuring, developing, and troubleshooting Informatica PowerCenter ETL workloads. Bachelor's degree in Computer Science, Information Systems, Software Engineering, Data Engineering, Mathematics, or other technical discipline. 8 years of additional relevant experience may be substituted for a degree consistent with position requirements. Demonstrated experience migrating or upgrading a large-scale ETL platform, including execution of testing and data validation. Strong Oracle SQL and PL/SQL skills, including the ability to investigate and resolve source-to-target data discrepancies. Experience with Unix/Linux shell scripting and production ETL scheduling or operations. Experience developing test plans, executing data reconciliation, documenting results, and resolving ETL defects. Hands-on cloud implementation experience, including provisioning, configuration, or deployment activities; OCI experience is strongly preferred. Strong written and verbal communication skills and the ability to work effectively with technical and non-technical stakeholders. Ability to obtain and maintain required VA suitability/access authorization. Must be authorized to work for any employer in the U.S. Must be able to obtain and maintain the required security clearance. Preferred Qualifications: Direct experience migrating Informatica PowerCenter from an on-premises environment to OCI or another enterprise cloud environment. Experience with Oracle Database 19c and Oracle RAC. Experience with Informatica Metadata Manager, data lineage, metadata repositories, and source-to-target mapping. Experience with Oracle GoldenGate, enterprise data replication, or hybrid on-premises/cloud data-movement dependencies. Experience with VA, VA Enterprise Cloud, federal programs, or other regulated enterprise environments. Experience supporting ATO/A&A, POA&M, change control, or cloud operational-readiness activities. OCI and/or Informatica certifications. Experience with high-volume data warehouses, automated validation, and performance optimization Salary Range $98,153.18-$120,000 USD 9th Way Insignia's range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law. Clearance/Background Investigation Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information. Benefits Eligible employees will have access to our comprehensive benefits package which includes Medical, Dental, Vision, Voluntary Life Insurance, 401(k), Basic Life A&D, STD, LTD, PTO, Telehealth, paid holidays, FSA, HSA. Additional resources include our Employee Assistance Program (EAP) and Traveling Assistance. Legal We're an equal employment opportunity employer that empowers our people to fearlessly drive change - no matter their race, color, religion, sex (including pregnancy, childbirth, lactation, or related medical conditions), national origin, age, marital status, sexual orientation, gender identity, disability, veteran status, military or uniformed service member status, genetic information, or any other status protected by applicable federal, state, or local law. Equal Employment Opportunity Notice Applicants have the right to be free from unlawful workplace discrimination. Please review the EEOC's Know Your Rights: Workplace Discrimination is Illegal notice. Accessible formats and translations are also available from the EEOC. Application Accommodations If you require a reasonable accommodation to complete this application or participate in the hiring process, please contact . Requests will be considered individually.
Job Description Job Description 9th Way Insignia is a service-disabled, veteran-owned small business bringing transformative technology to our government customers so they can achieve their missions. Our specialties include cybersecurity, cloud modernization, software development, data analytics, enterprise architecture, enterprise IT, analytics, process automation, and artificial intelligence. Learn more about 9th Way Insignia at Application password: Niner Team (Project) Introduction The Office of Performance Analysis and Integrity manages and enhances the Veterans Benefits Administration (VBA) Enterprise Data Warehouse (EDW) which resides on one Oracle M8 Supercluster database and thirteen application servers. Our team provides the technical services required to sustain EDW applications to include Project Management, Data Warehouse Management, Advanced Analytics, Tableau Server Administration/Tableau Desktop Administration, Technical Collaboration Support, Lessons Learned, Executive Orders and Special Projects, Architectural Enhancement, and Cloud Migration. We also provide management, enhancement, integration, implementation, maintenance, modernization, and infrastructure support for EDW applications as well as enhancement and maintenance of business intelligence capabilities and predictive analytics. 9th Way Insignia is looking for a Senior Informatica PowerCenter Migration Engineer to join and lead this team. We are seeking a hands-on Senior Informatica PowerCenter Migration Engineer to support the migration of the VA Enterprise Data Warehouse (EDW) from an on-premises Oracle environment to Oracle Cloud Infrastructure (OCI) within the VA Enterprise Cloud environment. This role will be responsible for assessing, configuring, migrating, validating, and optimizing Informatica PowerCenter ETL workloads supporting a large, business-critical data warehouse. The successful candidate will bring practical experience configuring enterprise ETL environments, executing migration activities, validating large-scale data movement, and resolving production-grade ETL issues. Responsibilities: Assess existing Informatica PowerCenter ETL workflows, repositories, dependencies, source-to-target mappings, schedules, parameter files, and operational procedures. Configure and support Informatica PowerCenter components in the OCI cloud environment. Plan and execute migration of Informatica ETL processes across development, test, pre-production/UAT, and production environments. Validate migrated ETL streams to confirm source-to-target requirements are fulfilled and data is not lost during the load process. Develop and execute automated and repeatable data-reconciliation processes, including record counts, control totals, aggregate comparisons, exception reporting, and source-to-target validation. Troubleshoot ETL failures, data discrepancies, performance bottlenecks, and connectivity issues. Optimize and tune Informatica jobs to improve nightly-load performance and meet operational processing requirements. Coordinate with Oracle database, GoldenGate, cloud infrastructure, networking, security, and EDW technical teams on migration dependencies and cutover readiness. Support cloud setup, configuration, provisioning, account/privilege planning, migration readiness, deployment, rollback, and post-implementation activities. Develop and maintain ETL design documentation, test plans, test-results reports, migration runbooks, restart/recovery procedures, and configuration-management artifacts. Support defect tracking, root-cause analysis, change control, production-readiness reviews, and knowledge transfer. Follow applicable VA security, architecture, configuration-management, and change-control processes. Requirements: Minimum 10 years of relevant experience in hands-on experience administering, configuring, developing, and troubleshooting Informatica PowerCenter ETL workloads. Bachelor's degree in Computer Science, Information Systems, Software Engineering, Data Engineering, Mathematics, or other technical discipline. 8 years of additional relevant experience may be substituted for a degree consistent with position requirements. Demonstrated experience migrating or upgrading a large-scale ETL platform, including execution of testing and data validation. Strong Oracle SQL and PL/SQL skills, including the ability to investigate and resolve source-to-target data discrepancies. Experience with Unix/Linux shell scripting and production ETL scheduling or operations. Experience developing test plans, executing data reconciliation, documenting results, and resolving ETL defects. Hands-on cloud implementation experience, including provisioning, configuration, or deployment activities; OCI experience is strongly preferred. Strong written and verbal communication skills and the ability to work effectively with technical and non-technical stakeholders. Ability to obtain and maintain required VA suitability/access authorization. Must be authorized to work for any employer in the U.S. Must be able to obtain and maintain the required security clearance. Preferred Qualifications: Direct experience migrating Informatica PowerCenter from an on-premises environment to OCI or another enterprise cloud environment. Experience with Oracle Database 19c and Oracle RAC. Experience with Informatica Metadata Manager, data lineage, metadata repositories, and source-to-target mapping. Experience with Oracle GoldenGate, enterprise data replication, or hybrid on-premises/cloud data-movement dependencies. Experience with VA, VA Enterprise Cloud, federal programs, or other regulated enterprise environments. Experience supporting ATO/A&A, POA&M, change control, or cloud operational-readiness activities. OCI and/or Informatica certifications. Experience with high-volume data warehouses, automated validation, and performance optimization Salary Range $98,153.18-$120,000 USD 9th Way Insignia's range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law. Clearance/Background Investigation Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information. Benefits Eligible employees will have access to our comprehensive benefits package which includes Medical, Dental, Vision, Voluntary Life Insurance, 401(k), Basic Life A&D, STD, LTD, PTO, Telehealth, paid holidays, FSA, HSA. Additional resources include our Employee Assistance Program (EAP) and Traveling Assistance. Legal We're an equal employment opportunity employer that empowers our people to fearlessly drive change - no matter their race, color, religion, sex (including pregnancy, childbirth, lactation, or related medical conditions), national origin, age, marital status, sexual orientation, gender identity, disability, veteran status, military or uniformed service member status, genetic information, or any other status protected by applicable federal, state, or local law. Equal Employment Opportunity Notice Applicants have the right to be free from unlawful workplace discrimination. Please review the EEOC's Know Your Rights: Workplace Discrimination is Illegal notice. Accessible formats and translations are also available from the EEOC. Application Accommodations If you require a reasonable accommodation to complete this application or participate in the hiring process, please contact . Requests will be considered individually.