Associate Data Architect I

9 - 12 Years
1 Opening
Chennai, Kochi, Trivandrum

Role Proficiency:

Leverage expertise in a technology area (e.g. Infromatica Transformation Terradata data warehouse Hadoop Analytics) Responsible for Architecture for a small/mid-size projects.

Outcomes:

Measures of Outcomes:

Outputs Expected:

Strategy & Planning:

Operational Management :

Project Control and Review :

Knowledge Management & Capability Development :

Requirement gathering and Analysis:

People Management:

Alliance Management:

Technology Consulting:

Innovation and Thought Leadership:

Project Management Support:

Stakeholder Management:

New Service Design:

Skill Examples:

Knowledge Examples:

• Data visualization
  • Data migration

  • RDMSs (relational database management systems SQL

  • Hadoop technologies like MapReduce Hive and Pig.

  • Programming languages especially Python and Java

  • Operating systems like UNIX and MS Windows.

  • Backup/archival software.
  
  
  Additional Comments:

  • 10+ years of experience working with Microsoft SQL Server, MS SQL • 10+ years of strong hands on background as a SQL developer • Excellent knowledge on writing complex SQL stored procedures in an application development environment. • Design database tables, views, indexes, functions and develop the various reports using SQL and Stored Procedures. • Work with other front-end developers in completing the database modules end to end • Query optimization for performance improvement. • Should be proficient in creating database triggers • Create / Modify and optimize database schemas, stored procedures and SQL queries. • Analysing, troubleshooting, and resolving data issues. • Understanding of 3rd party software APIs in order to integrate them with your solutions. • Working closely with business stakeholders and assist with data analysis with regard to SQL. • Preparing the mapping documents for the existing stored procedures. • Should be able to perform SQL profiling • Analyse the performance issues of existing stored procedure and fine tune performance of the system • Identifies and proposes database system improvements and changes. • Builds and executes data queries for business partners. • Implements systems changes, upgrades, and modifications according to business needs. • Maintain active relationships with stakeholders to understand business requirements, lead requirement gathering meetings and review designs with the stake holders • Perform technical design reviews and code reviews • Perform peer reviews on source code to ensure reuse, scalability and the use of best practices • Participate in collaborative technical discussions that focus on design, architecture, and development • Identify opportunities that can improve efficiency of business processes • Troubleshoot software application and technical issues - identify modifications needed in existing applications to meet changing user requirements

Data Architecture,Engineering,Program Delivery,Healthcare