Job Description

About the Opportunity Job Type: Permanent Application Deadline: 31 October 2023 Title: Technical Specialist Data - Snowflake Department: Technology - ISS Distribution Location: Gurgaon Level : 4 We\'re proud to have been helping our clients build better financial futures for over 50 years. How have we achieved this By working together - and supporting each other - all over the world. So, join our team and feel like you\'re part of something bigger. Department Description The Distribution & Client Technology department comprises of Client Reporting, Data and CRM Technology teams that enable and support the business in the UK, EMEA and Asia Pac regions and is a strategic area targeted for growth over the coming years. The Distribution & Client Technology has been acting as the key enabler for the business in achieving their goals. The portfolio of projects will include a large collection of strategic initiatives as well as tactical ones to support day-to-day operations and strengthen the environment. Purpose of your role This is a challenging opportunity for senior Snowflake data professionals who understand and solves complex functional, technical and architectural issues around data integrations and has the ability to understand the implication of the chosen technical strategy and ensure alignment with business context. The candidate will be expected to interact with all levels of the business and technical community, seeking approval from all stakeholders of the projects. The candidate should have good experience in Snowflake architecture and design as well as in data modelling, while demonstrating a keenness to master, suggest and work with different technologies & toolsets. Candidate should have understanding of how the enterprise wide data lake construct can be implemented. The candidate is also expected to be hands-on on coding, so as to be an effective reviewer as well as to develop complex scenarios. The role would also involve intensive interaction with the business and other systems groups, so good communication skills and the ability to work under pressure is absolute must. Key Responsibilities Work with the business analysts and enterprise architects to devise and propose the technical solution to business problems or new opportunities Prepare system and technical high-level design documents Produce Technical specifications, unit test cases for the reports under development For assigned projects, ensure that all project technical artefacts are constructed, compiled, packaged and documented in accordance with FIL Technology development methodology, technical delivery method and quality gates Support and mentor analyst programmers in all technical deliveries, review their code and provide technical guidance Build trusted relationships with business partners and proactively seek feedback on systems processes and personal performance Analyse technical issues, flag risks and provide solution approach to such issues. Ensure code is maintained in version control system and participate in code deployments with the Deployment team Give inputs to prepare the Implementation plan for deployment into production, provide necessary production support during initial phases after go-live. Experience and Qualifications B.E./B.Tech. or M.C.A. in Computer Science from a reputed University 7-10 years of relevant industry experience Essential Skills Design, develop, test, deploy, and maintain enterprise-level applications using the Snowflake platform Experience of data migration from existing platforms to Snowflake in large scale and complex implementations Good with data modelling skills entity relationship as well as dimensional, designing various layers of Datawarehouse, etc - 3+ years Experience on PL-SQL/Data warehousing/Oracle/Snowflake. Strong experience in SQL, PL/SQL, Informatica Powercenter, Unix shell scripting, Oracle 12c database optimization and scheduling tools along with performance improvement techniques across ETL technology stack with hands-on abilities - 6+ years Data analysis, source system analysis and data mapping to target data model - 4 to 6 years Extensive knowledge in data integration architecture/ETL/Data warehouse, esp large volumes with complex integrations - 6+ years Good knowledge of reporting tools such as OBIEE, Tableau with understanding of different types of reporting, storytelling using visualization, etc Good knowledge of emerging alternate tools/technologies like Python, Spring Integration, Big Data technologies, etc... Good Knowledge in Architectural and Design patterns Overseeing and reviewing the application design & development to ensure that it meets both the technical constraints of thearchitecture and the business objectives in terms of reliability, scalability and serviceability Ability to identify and define non-functional requirements and design systems to meet the same Knowledge of applicationarchitecture to ensure performance and scalability, including the identification and alleviation of bottlenecks. Excellent verbal, written communication and problem-solving skills Desirable Skills Experience in preparing Technical Documentation (Pseudo Code, Process Flow, Data Model, Class Diagram) Integration with cloud systems like Workday, Salesforce and Marketo Exposure to Data quality, complex transformation such as B2B, metadata management, etc Exposure and sound understanding of financial services domain - Mutual Funds and Fund accounting Self-starter with ability to take ownership of end to end implementations Candidate must be willing to travel overseas at short notice for the duration necessitated by project needs Feel rewarded For starters, we\'ll offer you a comprehensive benefits package. We\'ll value your wellbeing and support your development. And we\'ll be as flexible as we can about where and when you work - finding a balance that works for all of us. It\'s all part of our commitment to making you feel motivated by the work you do and happy to be part of our team. For more about our work, our approach to dynamic working and how you could build your future here, visit careers.fidelityinternational.com. For more about our work, our approach to dynamic working and how you could build your future here, visit careers.fidelityinternational.com.

foundit