Technical Consultant - Data Architect

Offers investment solutions and retirement expertise to institutions, individuals and their advisers around the world. For individual investors and their advisers we provide guidance to help them invest in a simple and cost effective way.

Key Responsibilities

-Define and own technical architecture and design for projects
-Help team to develop and deliver applications/components in accordance with technical design
-Help team with complex issues during development
-Provide guidance to the team on complex and emergent design patterns and technologies
-Should work on projects needing development of large and scalable applications with good
performance and high availability

-Work with infrastructure teams to define the architecture stack needs like storage, security, load
balancing, disaster recovery & failover
-Delivery of highly secure solutions that are optimized for performance and built to scale
Develop, implement and maintain technical standards, procedures and best practices
-Communicate with senior stakeholders, teams to articulate technology solutions

Experience and Qualifications

BE / B-Tech / MCA
10 -14 years of total experience

Essential Skills

- Architecting, planning and implementation of e2e data warehouse and business intelligence
systems utilizing best practices from data architecture, data integration and management areas - 2+
years

- Expert data modelling skills; entity relationship as well as dimensional, designing various layers of
Datawarehouse - 4+ years

- Data analysis, source system analysis and data mapping to target data model - 6 to 8 years
Extensive knowledge in data integration architecture/ETL/Data warehouse, especially large
volumes with complex integrations - 8+ years

- Strong experience in SQL, PL/SQL, Informatica Power center, Unix shell scripting, Oracle 12c
database optimization and scheduling tools along with performance improvement techniques across

- ETL technology stack with hands-on abilities - 8+ years

- Good knowledge of reporting tools such as OBIEE, Tableau with understanding of different types of
reporting, storytelling using visualization

- Good knowledge of emerging alternate tools/technologies like Python, Spring Integration, Big Data
technologies

- Good Knowledge in Architectural and Design patterns
Overseeing and reviewing the application design & development to ensure that it meets both the
technical constraints of the architecture 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 application architecture 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 )

- Experience in using other ETL tools like Kettle or Talend
- 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, Fund accounting,

Procurement

- 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