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

• Must have 5+ years of experience with Matillion or tools like Informatica / Talend / Pentaho.
• Must have 3+ years of experience in AWS Cloud infrastructure Platform and Snowflake (Highly Preferable).
• Must have 5+ years of experience in writing and optimizing complex SQL queries to ensure high performance and efficiency
• Develop and maintain scalable data pipelines and build new API integrations to integrate data from various sources, ensuring consistency, accuracy and reliability.
• Hands-on experience of data warehousing concepts such as Change Data Capture, Slowly Changing Dimensions and experience in practical implementation in ETL.
• Experience in data engineering, dimensional database design, data lake, and datawarehouse.
• Knowledge of Enterprise Business Applications - Salesforce products (Sales Cloud, Community Cloud, CPQ), Zuora, Callidus, Coupa, Workday, Kyriba.
• Utilize Python for data manipulation, automation and integration tasks.

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