Informatica Intelligent Cloud Services (IICS)- 5 + Years- Gurgaon (hybrid) Must have-Cloud Application Integration (CAI) Software Developer Senior Financial Systems From coast-to-coast, our inspiring colleagues are at the heart of what we do best: helping people, businesses and society prosper in good times and be resilient in bad times. With our team, youll bring this purpose to life every day by living our Values, being open to change, and pursuing your goals. well give you countless opportunities to learn and grow, alongside a diverse and passionate community of experts – the best the industry has to offer. You’ll be empowered to be your best self, do your best work, and make a meaningful impact. Here, you can: shape the future of insurance, win as a team, and grow with us. About the role We are looking for a driven and enthusiastic Senior Software Developer with experience in Informatica Intelligent Cloud Services (IICS) for our Financial Systems, who will participate in successful implementation of technology projects that support finance modernization and strategic acquisition programs. Work location: Toronto (700 University Ave) or Montreal (2020 Robert-Bourassa) This role will offer you the chance to: Lead and support the user experience Maximize the value of the system by identifying and recommending functional and technological solutions to improve business processes Work with a talented, diverse and open-minded group of individuals/stakeholders across multiple Business and IT teams Have exposure to delivering solutions using emerging technology stack Coach and mentor junior Software Application Architects and other team members You’ll also handle many key responsibilities: Design, develop and maintain Informatica cloud assets using the appropriate data load techniques Debug and tune Data Integration, Application Integration and Mass Ingestion assets; analyze data warehouse architecture, troubleshoot and recommend improvements and alternate methodologies Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural and requirement specifications May prepare or review product documentation, written instructions or technical literature for accuracy and completeness Maintenance of business rules associated with data integration Participate in the fulfillment of ad-hoc data requests from internal business owners Participate and guide vendor teams in implementing solutions to fit current architecture The requirements Must Have: Good analytical skills Minimum 3-5 years' experience working with Informatica Intelligent Cloud Services (IICS) – Primarily Cloud Application Integration. Experience on Cloud Data Integration would be an added advantage Must be comfortable with developing API integrations, providing thought leadership around leading practices for IICS development Knowledge of working on an environment with AWS Platform would be added advantage Hands-on experience working with API integration projects Application Integration workflows with REST API endpoint Experience service connectors, application connectors, AWS S3 connector Experience with integrating with Oracle ERP and Oracle EPM Ability to create solution Architecture for different ETL use cases Ability to review existing system Architecture, find out the gaps and suggest the best possible solution Data Integration workflows for data validation, inserts, and querying Testing/QA/Code Scanning and Code Migration Experience in working on premise and cloud databases and Datawarehouse is a plus Experience working in Linux environment Strong Assets Experience in Design and implementation of complex ETL processes Proficient in writing complex SQL queries Good Understanding of traditional RDBMS systems like SQL Server, Oracle, etc. Good understanding of REST based systems and interfaces Excellent problem solving, debugging, performance tuning skills Excellent communication skills Here are a few reasons why others have joined our team: An award-winning, inspiring workplace that supports its people and recognizes great work Stimulating, challenging projects and development opportunities to help you grow your skills and career A comprehensive financial rewards program that recognizes your success An extensive, flexible benefits package An industry leading Employee Share Purchase Plan where we match 50% of net shares purchased A $350 annual wellness account that promotes an active lifestyle