Senior IT Developer (ETL)

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).
• 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 (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.

#LI-MK1