Specialist - Application development

Job Description

Role DescriptionDesignationSpecialist - DevelopmentBand5.1Team Name CAS TeamTypeNewEmployment TypePermanent About ASCI

• Our Purpose
  • To create economies of scale for common functions, improve productivity, reduce unit costs, and enable Sun Life to make more effective investments in technology.
  • By working in a collaborative mode with the Sun Life business partners, Asia Service Centre- India seeks to extend the Clock, the Dollar and provide Scalability.
• Our Strategic Objectives (what is to be achieved)
  • Contribute to growth
  • Customer focused execution
  • Increase efficiency and effectiveness
  • Ensure effective governance
  • Innovate for business value
  • Maximize our people capabilities
• Our Culture
  • At Sun Life Asia Service Centre- India, we are committed to Sun Life Financial value system.
  • We value our employee relationships. We offer long term associations and invest resources to provide opportunities to develop professional, technical and management skills.
  • We view our employees as catalysts in building success. We invite our employees to play a part in delivering better business processes and solutions to help Sun Life business partners become high-performance businesses.
  • At Sun Life Asia Service Centre- India, we provide safe, stable working conditions and a supportive working environment.
  • We respect diversity of individuals and recognize that diverse cultures and backgrounds make Sun Life a great place to work.
  • Sun Life Asia Service Centre- India builds relationships of mutual trust, in accordance with our global practices and strives to be an organization in which individuals can demonstrate their abilities fully, grow professionally and have pride.

Role SummaryThis is a position for ETL Designer/Developer with Tableau hands on experience having 5 to 7 years of experience in Informatica and at least 3 years experience in Tableau.

• Working with the Subject Matter Experts and Business Analysts to grasp the best knowledge of existing/ new SLF investment product architecture and implement new features in the scope of the project and other project deliverables.
• Design, Development, Testing and Support of Informatica based ETL Applications, using existing and emerging technology platforms.
• The incumbent will be responsible for requirement gathering from the client team and building the interactive dashboards and stories in Tableau, should be an adaptable individual who enjoys getting into details.
• The person will be exposed to a variety of assignments, responding to new business service requests/assignments, problem solving, maintaining stability and performing technical implementations.
• Partner with SME s, Developers and other stakeholders.

Unique requirements : Shift timing : Overlap with onshore team till 11am, and be flexible to shift working hours from time to time if neededAccountability Core Responsibility

• Understand the project scope, identify activities/ tasks, task level estimates, schedule, dependencies, risks and provide inputs to Program Lead for review.
• Lead the analysis, design and development phases to develop a robust ETL solutions which can best meet the business requirements for investments applications.
• Analyze the data sources, be it a RDBMS or XLSX, CSV file or any other data source.
• Design and Develop individual tableau reports, dashboard or stories.
• Testing the reports for formatting and data correctness, and publishing the workbooks on the Tableau server for scheduled refreshes.
• Optimize the data source queries/joins and tableau reports.
• Prepare/Modify design documents (High level design and Detailed design documents) based on business requirements.
• Suggest changes in design on technical grounds.
• Work on the functional and technical upgrades of the application
• Coordinate delivery of the assigned tasks with the onshore Partners or/and Business Analyst.
• Ensure timely notification and escalation of possible issues/problems, options and recommendations for prompt resolution
• Follow development standards to ensure that code is clear, efficient, logical and easily maintainable.
• Create and maintain application documentation like Network diagrams, Technical project handbook, technical data mapping doc, unit test documents, implementation plan.
• Ensure SLF Information Security Policies and General Computing Control is compiled to in all situations.
• Take complete ownership of work assignments and ensure the successful completion of assigned tasks.
• Ensure all written and verbal communication is clear, understandable and audience appropriate.

Eligibility Minimum Qualification

• A degree in Computer Science, related technology degree, or equivalent experience.

Industry Experience

• Minimum 5 to 7 years of overall IT experience
• Strong knowledge of ETL (Informatica PowerCenter), relational databases (Microsoft SQL Server), PLSQL and Tableau.

Competencies (Technical) Mandate Skills

• Design and Development
  • Excellent problem solving skills with the ability to analyze business problems systematically and deliver effective right-sized solutions in a timely manner.
  • Proven analysis and design/development skills on ETL platforms.
  • Design, Develop, Test and Implement the changes following the Software Development Life Cycle methodologies and quality concepts.
• Technical Skills
  • Hands-on experience in data modelling.
  • Good knowledge of data warehousing concepts.
  • Good analytical and problem solving skills.
  • Strong knowledge on ETL (extract, transform, and load) tools - Informatica PowerCenter.
  • Experience with designing, developing, publishing and supporting Tableau dashboards.
  • Working knowledge on job scheduling tools like zeke, Control-M, Autosys etc.
  • Experience in TFS, GIT versioning tools.
  • Strong knowledge of relational database (Microsoft SQL Server).
  • Good understanding of Software Development Life Cycle methodology
• Communication & Collaboration
  • Ability to communicate effectively in the multi-team projects.
  • Knowledge of the investments industries
  • Ability to work independently as well as being a strong team player
  • Good organizational skills with the ability to handle several tasks efficiently.

Preferred skills

• Technical Skills
  • Hands-on experience on any data-modeling platform like Erwin.
  • Experience with scripting languages: PowerShell, Python, Unix.
  • Strong knowledge of relational database (Microsoft SQL Server) and stored procedures.
  • Experience with various DevOps tools - source code management tools such as TFS, Bit bucket, CI CD tools Ansible, CDD etc.
  • Knowledge of APIs.
  • Experience of Agile methodology.
  • Experience on Automation/Robotics Blue Prism/Pega
• Functional Knowledge
  • Experience on Hyperion/Longview/GL/SAP

Behavioral skills Mandate Skills

• Collaborates effectively
  • Drives collaboration among team members in his/ her function
  • Presenting a supportive, united front when appropriate.
• Communicates Confidently
  • Communicates crisply and candidly
  • Communicates effectively across audiences (reporting managers, peers, business partners)
  • Balances talking and listening to foster candid dialogue
• Focuses on the Customer
  • Raises concerns and recommends potential solutions for those processes that negatively impact the customer service experience or the fair treatment of customers
  • Helps employees understand the impact of their work on the customer/ client
  • Organizes own work to meet agreed upon deadlines
  • Focuses on surfacing underlying customer issues / concerns and identifying root causes
• Takes Accountability
  • Takes steps to understand decision making processes and procedures uses this understanding in developing work plans
  • Escalating issues or redirecting enquiries in a timely and efficient fashion.
  • Following up with customers when we say we will and delivering on our commitments
  • Works under general supervision on day to day matters.
• Understands our Business
  • Enhances understanding about the business of SLF (e.g. products and services, org structure, key competitors)
  • Understands how his/her role relates to the Business Unit/ Functions objectives
• Self-starter Taking initiative self-leaner and finding opportunities
• Trust - Ability to work in an open culture with a positive approach
• Flexibility Ability to accept change, agility

Job Category:IT - Application DevelopmentPosting End Date:30/05/2021,

Keyskills :
data warehousingdata mappingsoftware developmentnetwork diagramssubject matter expertslevel designinformation securitysoftware development life cycledistribution networknew business