Staff Software Engineer, Enterprise Data Integration

Description

• Utilize expertise in high-volume, complex data migration to drive future needs of the business, maintaining the highest standards of performance, quality, and efficiency.
• Own and drive data movement and readiness strategies to enable AI adoption across the enterprise.
• Model and encourage best practices in DevOps to enhance efficiency and automation.
• Leverage deep expertise in Informatica IDMC (Intelligent Data Management Cloud) to design and implement business solutions that enable efficiency and scalability for the business.
• Act as a technical role model, mentoring mid-level engineers and elevating coding and design practices. Continuous improvement in performance, scalability, security, and reliability across data integration tools at AppFolio.
• Develop high-quality data integrations across systems, such as external applications, AppFolio Product, Snowflake, Salesforce, Zuora Billing, Zuora RevPro, NetSuite, etc..
• Leverage AI and emerging technologies to drive data quality and governance standards.
• Design, build, configure, debug, monitor, and maintain reliable, scalable, and secure enterprise data integration solutions using modern cloud-based platforms like Informatica, Mulesoft, AWS, Snowflake, etc.. to integrate, cleanse, and move data across enterprise systems.
• Collaborate with stakeholders, technical, and functional teams to influence and execute data integration strategies, standards, and guidelines to enable future scale and growth.
• Participate in ARB (Architecture Review Board) discussions, providing design and code review support.

Requirements

• Proven expertise in designing AI-ready data architectures, building semantic and governed data layers that enable enterprise-wide AI, analytics, and automation initiatives
• 5+ years of deep experience with multiple multi-tenant SaaS cloud-based enterprise and data integration platforms like: Informatica IDMC, AB Initio, AWS Glue, Mulesoft, Salesforce, CData, Fivetran, etc, designing and implementing scalable, fault-tolerant data flows.
• SOLID concepts and hands-on experience with components of AI architecture (MCP, LLM, RAG, AI Agents, etc).
• Extensive experience leading large-scale, high-volume data migrations — including data profiling, cleansing, validation, and reconciliation leveraging Informatica IDMC Data Quality or similar tools.
• Excellent communication, interpersonal, and presentation skills. Strong analytical, problem-solving troubleshooting skills.
• Certifications in relevant platforms, such as AWS Solutions Architect, Informatica Architect, etc..
• 3+ years of experience as a Staff Software Engineer leading the discovery, design, and development of data Integration solutions using Informatica IDMC, with expert-level proficiency across the platform’s full suite (Cloud Data Integration, Application Integration, Data Quality, Mass Ingestion, etc).
• Demonstrated ability to build trust and credibility with business partners.
• Bachelor's degree in Computer Science, Information Systems, or a related field; Master's degree preferred.
• 3+ years of experience and expert-level knowledge in various software design patterns and architectures.
• 3+ years designing and implementing AWS-based data and application architectures using S3, Glue, Lambda, Step Functions, and EventBridge within large-scale enterprise systems.
• Proven experience in SDLC and Agile methodology, driving the execution of complex software projects. Experience working in global teams, including offshore resources.
• 8+ years of experience in software engineering with a focus on enterprise data architecture and integrations within large-scale, high-growth SaaS organizations $1B+.
• Expert-level programming skills in Ruby, Java, Python, JavaScript, or equivalent.

Benefits

Training + Development

Interview process

Visa Sponsorship

Security clearance