Provides technical leadership and hands-on development for Informatica ETL and enterprise data warehouse implementations. Designs, develops, tests, supports, and optimizes workflows, mappings, data integration processes, and dimensional models. Maintains platform health, resolves technical issues, leads releases, establishes development standards, supports data quality and governance, and collaborates with QA and business teams. Requires strong SQL, cloud, Kimball modeling, data management, and Informatica expertise, plus occasional on-call duty and travel.
JOB TITLE: SENIOR ETL DEVELOPER
DEPARTMENT: IT- EP - ENTERPRISE DATA PLATFORM
STATUS: EXEMPT
JOB CODE: 10049
PAY SCALE: $123,600.00 - $160,000.00 Annually
GENERAL DESCRIPTION
The Sr. ETL Developer provides technical leadership and hands on expertise with respect to the analysis, design, development and support of Golden 1’s Informatica ETL implementation. This is a senior position responsible for assisting the ETL Architect with implementation methodologies including standards, design patterns and best practices for enterprise data warehouse development. The Sr. ETL Developer will assist in leading other ETL developers. This includes both leading and participating in ETL development activities to ensure an efficient, high-performance implementation which fully supports the business’ data needs.
TASKS, DUTIES, FUNCTIONS
- Helps creates standards, design patterns and best practices for ETL development in an enterprise data warehouse environment.
- Installs, configures and administrates Informatica PowerCenter and IDQ. Informatica Web Services Hub experience also desired.
- Responsible for workflow and mapping analysis, design, development, testing, and configuration.
- Functions as both an expert and lead technical resource on ETL projects throughout the project lifecycle.
- Provides support for enterprise data warehouse ETL jobs and processes.
- Diagnoses and remedies technical problems to ensure platform up-time and application service levels are met.
- Supports, maintains and monitors the health of the platform and associated processes.
- Writes high quality processes utilizing structured development techniques to support process components and development.
- Utilizes agile-based approach to implementing data services and solutions.
- Recommends improvements to ETL processes to improve on data delivery, data quality and overall processing efficiency.
- Partners with quality assurance testing teams to identify errors and confirm business specifications have been achieved.
- Able to organize and lead code releases using native Informatica PowerCenter capabilities.
- Develops support guides and run books for operational support purposes.
- Collects information to analyze and evaluate existing or proposed application designs.
- Maintains system and programming guidelines by adhering to the software development lifecycle; develops and maintains artifacts related to standards and architecture.
- Assists with the definition and implementation of processes, policies, standards and procedures to assure compliance with corporate and regulatory policies.
- Effective oral and written communication skills required to train, direct, and evaluate staff, diagnose, correct and resolve system problems.
- Maintain a thorough understanding of state and federal laws and regulations related to credit union compliance including bank secrecy and anti-money laundering laws appropriate to the position.
PHYSICAL SKILLS, ABILITIES, AND EXERTION UTILIZED IN THE PERFORMANCE OF THESE TASKS
- Availability for emergency and on call duty 24 hours a day, 7 days a week, as needed.
- Occasional travel may be required.
- Lift and carry communications equipment and computer hardware weighing up to fifty pounds.
- Must possess sufficient manual dexterity to skillfully operate applicable computer hardware, a variety of hand tools and standard office equipment.
- May work additional work hours to accomplish tasks.
ORGANIZATIONAL CONTACTS & RELATIONSHIPS
- INTERNAL: All levels of staff and management
- EXTERNAL: Vendors
QUALIFICATIONS
- EDUCATION: Bachelor’s degree in Computer Science, Management Information Systems or comparable discipline or equivalent work experience.
- EXPERIENCE: Minimum of five years’ experience, designing, developing and supporting enterprise data warehouse ETL implementations.
- KNOWLEDGE/SKILLS:
- Experience with Cloud implementations is essential.
- Highly experienced working with Kimball based data warehouse implementations.
- Strong understanding of all aspects of dimensional modeling as it pertains to ETL design and development. Must have prior experience designing loads for daily and monthly snapshot facts, accumulating snapshot facts, factless facts, type 1, 2, 3 and other hybrid dimension types as well as 3NF and other modeling techniques.
- Strong understanding of enterprise architecture, security, management and monitoring.
- Strong understanding of data management best practices and concepts including data quality, reference data, metadata, and data lineage.
- Strong SQL skills expected.
- Data Integration experience necessary.
- This is a master developer role.
PHYSICAL REQUIREMENTS
- Prolonged sitting throughout the workday with occasional mobility required.
- Corrected vision in the normal range required to configure, test, and troubleshoot network server hardware and data.
- Hearing within normal range. A device to enhance hearing will be provided if needed.
LICENSES/CERTIFICATIONS
Possession of a valid California Driver’s License is required.
Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.
#LI-Remote
REV. 3.22.2023
Similar Jobs
Edtech
Designs and stewards enterprise ETL/ELT pipelines, lakehouse, warehouse, and data models using Microsoft Fabric, SQL, and Python. Establishes data quality, testing, lineage, security, governance, DataOps, CI/CD, and performance optimization practices. Uses AI coding and agentic tools for development while reviewing outputs rigorously. Partners with stakeholders to shape requirements, leads complex initiatives, mentors engineers, and collaborates with analysts, data scientists, and BI teams to deliver reliable data products.
Top Skills:
Agentic Development ToolsAi Coding AssistantsAutomated TestingCi/CdData WarehousesDataopsMcpMetadata-Driven Pipeline FrameworksMicrosoft FabricPythonRelational DatabasesSQL
Information Technology • Consulting
Design, develop, maintain, and optimize enterprise ETL pipelines supporting Army Human Resources Command data. Build data mappings and transformation logic, ensure data quality and security compliance, maintain database systems, manage scheduling and monitoring for reliable pipelines, provide lifecycle technical solutions, and create architecture and data-flow documentation using DataStage and SQL databases.
Top Skills:
HTMLIbm Infosphere DatastageMicrosoft Sql ServerMicrosoft VisioOraclePostgresSQLXML
.png)
eCommerce • Fintech • Hardware • Payments • Software • Financial Services
Leads sales compensation operations, including quota and crediting processes, commission calculations, data pipelines, audits, controls, governance, and payout accuracy. Manages and develops a high-performing team while administering Pigment and Salesforce, improving automation and data integrity, resolving exceptions, and partnering with Sales, Finance, and Revenue Operations leadership. Requires strong analytical, systems, stakeholder-management, and sales compensation expertise.
Top Skills:
AnaplanCaptivateiqEtl PipelinesGoogle SheetsLookerExcelPigmentSalesforceSQLVaricentXactly
What you need to know about the Austin Tech Scene
Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center
