Noor Vaishnav

• Understand and follow enterprise architectural strategy and standards and contribute in updating it where needed

• Establish standardized data integration patterns for the complex use cases involving heterogeneous data sources, real-time data, as well as EOD/batch data

• Be proficient in data integration, ETL, data modelling, and data reporting technologies and be up to date with the latest industry tools and solutions

• Be proficient in relevant cloud and data technologies including AWS, Snowflake, Python, Data APIs, and data streaming

• Create Conceptual, Logical, and Physical Data Models and ER diagrams

• Create Data Modelling standard and guidelines to be used across the organization

• Work towards automation using data APIs to convert logical ER models into physical data models and physical database scripts

• Help team in creating technical solutions and review as needed

• Mentor technical leads and developers and help them follow architectural standards and processes

• Interact with technology and business stakeholders such as Architects, Senior managers, and Unit Heads to understand their views and requirements

• Help with hiring process by shortlisting resumes and taking technical interviews

• Understand requirements from business analysts, business users, and technology stakeholders

• Create technical solution for ETL, data streaming, data integration, and data reporting requirements

• Ensure optimal performance of the data-centric applications and tune the performance where needed

• Be proficient in technologies and tools such as Python, Kafka, Nifi, Oracle, SQL & PLSQL, Pytest, Informatica PowerCenter, ER Studio, Control M, GitHub, Bamboo

• Interact with architects and other consultants to understand the direction and align the technical solution with Enterprise Architecture.

• Create accurate, maintainable, and high performing software code and applications on relevant technologies

• End-to-end delivery of the software artefacts using version control (GitHub) and DevOps tools like Bamboo

• Propose, design, and implement DevOps pipelines for relevant technologies

• Help fellow developers with technical guidance

• Help establishing coding standards, procedures, and best practices for the team

• Help with hiring process by shortlisting resumes and taking technical interviews

• Understand technical requirements for the Management Information Datawarehouse (MIDW) project

• Understand the complete flow for the existing ETL in the ongoing Datawarehouse and propose improvements

• Create and update existing design for the ETL and coordinate with the stakeholders such as architects and agree upon the final solution

• Implement the automation of the ETL workflows using UNIX scripting

• Be proficient in technologies and tools such as Oracle, SQL & PLSQL, Informatica PowerCenter, Control M, SVN, Unix, and Shell Scripting

• Technically lead a team of developers and testers towards the implementation and help them with coding and design practices

• Interact with technology stakeholders like architects, business analysts, and managers

• Follow architectural Principles defined within the organization

• Take technical interviews to help with the hiring within the team

• Understand Business and Technical requirements for the given projects

• Create technical specification and design documents as per the overall solution

• Deliver accurate and maintainable software code as per the standard and best practices

• Create software code and applications with relevant technologies and tools such as Oracle, SQL & PLSQL, Informatica PowerCenter, Unix Shell scripts, TOAD, SQL Developer, Control M

• Tune the performance by optimizing SQL queries and improving PLSQL stored procedures

• End-to-end delivery of the software artefacts using version control (SVN) and DevOps tools like Bamboo

• Assist Production Support teams in resolving the issues

• Interact with technical leads and architects to implement solutions in-line with overall strategy

• Work with other developers, quality analysts, and business analysts in a coordinated fashion

• Help in maintaining the standards, procedures, and best practices in the team

• Understand the business functionality of TCS product BaNCS, specifically Corporate Action modules

• Be proficient in relevant technologies like Java, SQL, PLSQL, Unix, Shell Scripting

• Independently deliver back-end application using Java for invocation and PLSQL for business processing

• Interact with Tech Leads and Architects to understand the architecture and use their inputs to create accurate design and code

• Perform code and test case reviews for the fellow developers

• Work with other developers, quality analysts, and business analysts in a coordinated fashion

• Help in maintaining the standards, procedures, and best practices in the team

• Understand the existing functional and technical design of TCS implementation at client site while working for the clients National Clearing Corporation Ltd. & Tata Capital Ltd.

• Understand the change requirements and deliver software code to implement the same

• Prepare Unit Test Cases and low-level technical design documents as per the best practices

• Be proficient in relevant technologies like Pro*C, Oracle Forms & Reports, SQL, PLSQL, Unix, Shell Scripting

• Deliver complex PLSQL packages and stored procedures and write well tunes SQL queries

• Be able to work with tools like TOAD, SQL Developer, version control (SVN)

• Work with business users to resolve Production Issues

• Work with other developers, quality analysts, and business analysts in a coordinated fashion

• Help in maintaining the standards, procedures, and best practices in the team