Analyst Programmer

Title Analyst Programmer

Department      WPFH

Location Gurgaon

Level

Intro

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 [insert name of team/ business area] team and feel like you're part of something bigger.

About your team

The successful candidate would join the Data team . Candidate would be responsible for building data integration and distribution experience to work within the Distribution Data and Reporting team and its consumers. The team is responsible for developing new, and supporting existing, middle tier integration services and business services, and is committed to driving forwards the development of leading edge solutions.

About your role

This role would be responsible for liaising with the technical leads, business analysts, and various product teams to design, develop & trouble shoot the ETL jobs for various Operational data stores. The role will involve understanding the technical design, development and implementation of ETL and EAI architecture using Informatica / ETL tools. The successful candidate will be able to demonstrate an innovative and enthusiastic approach to technology and problem solving, will display good interpersonal skills and show confidence and ability to interact professionally with people at all levels and exhibit a high level of ownership within a demanding working environment.

Key Responsibilities

• Work with Technical leads, Business Analysts and other subject matter experts.
• Understand the data model / design and develop the ETL jobs
• Sound technical knowledge on Informatica to take ownership of allocated development activities in terms of working independently
• Working knowledge on Oracle database to take ownership of the underlying SQLs for the ETL jobs (under guidance of the technical leads)
• Providing the development estimates
• Implement standards, procedures and best practices for data maintenance, reconciliation and exception management.
• Interact with cross functional teams for coordinating dependencies and deliverables.

Essential Skills

• Technical
  • Deep knowledge and Experience of using the Informatica Power Centre tool set min 4 yrs.
  • Experience of Source Control Tools such as Clear Case / SVN
  • Experience of using job scheduling tools such as Control-M
  • Experience in UNIX scripting
  • Strong SQL or Pl/SQL experience with a minimum of 2 years' experience
  • Experience in Data Warehouse, Datamart and ODS concepts
  • Knowledge of data normalisation/OLAP and Oracle performance optimisation techniques
  • 4 + Yrs Experience of either Oracle or SQL Server and its utilities coupled with experience of UNIX/Windows
• Functional
  • 4 + years' experience of working within financial organisations and broad base business process, application and technology architecture experience
  • Experience with data distribution and access concepts with ability to utilise these concepts in realising a proper physical model from a conceptual one
  • Business facing and ability to work alongside data stewards in systems and the business
  • Strong interpersonal, communication and client facing skills
  • Ability to work closely with cross functional teams

Essential Skills / Experience

• Deep knowledge and Experience of using the Informatica Power Centre tool set
• Deep knowledge of Oracle and SQL query writing
• Experience of Source Control Tools such as Clear Case / SVN
• Experience of using job scheduling tools such as Control-M
• Experience in UNIX scripting
• Understanding of Software Development Lifecycle

Desirable Skills / Experience

• Diagnostic and analytical skills
• Good communication skills – both verbal and written.
• Display a flexible attitude, be able to thrive in an ever-changing environment

Personal Characteristics

• Good interpersonal and communication skills.
• Strong team player
• Ability to work at a strategic and tactical level
• Ability to convey strong messages in a polite but firm manner
• Self-motivation is essential, should demonstrate commitment to high quality design and development.
• Ability to develop & maintain working relationships with a number of stakeholders.
• Flexibility and an open attitude to change.
• Problem solving  skills with the ability to think laterally, and to think with a medium term and long term perspective
• Ability to learn and quickly get familiar with a complex business and technology environment.

About you

B.E./B.Tech/MBA/M.C.A/Any other bachelors Degree. At least 3+years of experience in Data Integration and Distribution Experience in building web services and APIs Knowledge of Agile software development life-cycle methodologies

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

For more about our work, our approach to dynamic working and how you could build your future here, visit