Senior IT Developer - ETL

This role is fully on-site in our Hyderabad, India office.

Yext is seeking a talented Senior IT Developer (ETL) in Hyderabad, India. 

The Senior ETL Developer/Architect is part of the Business Intelligence team that is responsible for analytics and integrations supported by IT across Sales, Marketing, Services, Customer Success, Finance, HR, Product and Engineering. The right candidate has empathy, curiosity and desire to improve and constantly learn; has technical experience in all the capabilities of the Matillion (or equivalent ETL) platform and a proven track record of driving best practices and processes, with hands-on experience in developing ETL projects, configuration, automation, & support. This individual will: a) Be a key member of the BI team within a dynamic SaaS company full of high caliber engineers; b) Design and build performant ETL projects working independently and in partnership with a global team of PMs, business analysts, and developers (onsite and offshore); c) Provide vision for enhancements, technical design, and participate in design reviews to ensure governance principles and best practices are followed; 

What You'll Do 

• Lead and execute the complete ETL development lifecycle, including requirements gathering, solution design, documentation, configuration, development, testing, and deployment; take ownership of escalated or complex issues and follow through to resolution.
• Create clear, structured and effective documentation that will enable developers within the team to maintain ETL.
• Proactively seek opportunities for process improvement: identify and resolve process bottlenecks, data issues, and inconsistencies to help improve operational efficiencies.
• Suggest improvements inspired by ideas from the global Matillion community and the broader data engineering community.
• Follow Agile principles to projects. Conduct regular knowledge sharing sessions with developers to drive adoption of Matillion (or equivalent ETL) based integrations.
• Implement best practice and architecture recommendations to leadership.
• Perform change management functions associated with large scale high-impact configurations.
• Create, manage and enforce application configuration and SDLC standards.
• Hands-on role (100%) - working on critical ETL fixes, design, development and QA.
• Focus on backend systems (Matillion or equivalent ETL and AWS infrastructure and cloud data warehouse like Redshift or Snowflake).
• Provide BI administration and technical support during weekends, after-hours and holidays, when needed. 
• Work on new BI projects, enhancements as well as production support.

What You Have

• 6-9 years ETL development experience with Data warehouse, Data engineering, or similar roles working with backend systems and large, disparate, and complex datasets. Must have 5+ years of experience with Matillion or tools like Informatica / Talend / Pentaho.
• Good understanding and experience in AWS Cloud infrastructure Platform and Redshift or Snowflake (Highly Preferable).
• Develop and maintain scalable data pipelines and build new API integrations to support continuing increases in data volume and complexity.
• Very good SQL and Python knowledge
• Clear understanding of data warehousing concepts such as Change Data Capture, Slowly Changing Dimensions and experience in practical implementation in ETL.
• Experience using version control, Agile Project Management and Ticketing applications - GIT, JIRA, Zendesk.
• Understanding and experience designing resilient ETL. Ability to anticipate issues and build exception handling processes.
• Experience in data engineering, dimensional database design, data lake, and data warehouse.
• Experience in practicing agile methodologies, including scrum and continuous integration environments.
• Experience leading technical requirements gathering and building solutions from those requirements; working at-scale by standardizing components to ship visualizations rapidly.
• Knowledge of Enterprise Business Applications - Salesforce products (Sales Cloud, Community Cloud, CPQ), Zuora, Callidus, Coupa, Workday, Kyriba.
• BTech/MCA degree in Computer Science, similar technical field of study or equivalent practical experience.

Bonus Points 

• Matillion ‘Building A Data Warehouse' or equivalent ETL certification.
• Experience with Tableau development, configuration and system administration or related reporting tools.
• Experience with CPQ, & quote to cash processes in a SaaS / recurring revenue company.
• Ability to work seamlessly as part of a multi-site, multicultural, development and testing team, onshore and offshore, internal and external resources.

Perks and Benefits

At Yext, we take pride in our diverse workforce and prioritize creating an engaged and connected working environment. Our ambitious mission is to transform the enterprise with AI search, and we know that to achieve that, we need a global team of innovators, visionary thought leaders, and enthusiastic collaborators passionate about making a meaningful impact in the world and contributing to an extraordinary culture.

We believe that people do their best when they feel their best — and to feel their best, they must be well-informed, fuelled, and rested. To ensure our employees are at their best, we offer a wide range of benefits and perks, including:

• Performance-Based Compensation: We offer an attractive bonus structure and stock options for eligible positions.
• Comprehensive Leave Package: Our leave package includes Paid Time Off (PTO), Parental Leave, Sick Leave, Casual Leave, Bereavement Leave, National Holidays, and Floating Holidays to ensure a healthy work-life balance.
• Health & Wellness Offerings: We provide medical insurance with 7L coverage, including enhanced parental and outpatient department (OPD) coverage for you, your spouse, two dependent children, and two parents (as applicable and subject to eligibility requirements).
• Relocation Benefits: We offer relocation assistance and an allowance to eligible candidates to help ease your transition.
• World-Class Office & Building Amenities: Our office has a top-notch infrastructure, including gaming rooms, a plush pantry, and breakout areas.

#LI-RK1