Codes solutions and unit test to deliver a requirement/story per the defined acceptance criteria and compliance requirements
Utilizes multiple architectural components (across data, application, business) in design and development of client requirements
Performs Continuous Integration and Continuous Development (CI-CD) activities
Contributes to story refinement and definition of requirements
Participates in estimating work necessary to realize a story/requirement through the delivery lifecycle
Contributes to existing test suites (integration, regression, performance), analyze test reports, identify any test issues/errors, and triage the underlying cause
Performs spike/proof of concept as necessary to mitigate risk or implement new ideas
Skills:
Application Development
Automation
Collaboration
DevOps Practices
Solution Design
Agile Practices
Architecture
Result Orientation
Solution Delivery Process
User Experience Design
Analytical Thinking
Data Management
Risk Management
Technical Strategy Development
Test Engineering
Responsibilities:
The role will require the person to gain an in-depth understanding of Capital Markets applications and technologies.
The person will work with other senior developers and Architects to help prioritize work for the platform.
Ability to design system architecture and execute the design into clear roadmaps, come up with estimates on user stories and evaluate story points.
Required Qualifications :
Extensive experience in BI Solutions (ETL & Reporting) using SQL Server/Oracle, Tableau and SQL Programming using DDL, DML, DCL commands for various business applications.
Expert at developing ETL interfaces using SSIS, Data marts/cubes using SSAS and enterprise reports Tableau.
Expert in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications.
Experience in Error handling and debugging coding issues and troubleshoot production problems.
Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans.
Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS, Import, Export Data, Bulk Insert and BCP utilities.
Excellent analytical/Communication Skills, Team Play and very much result Oriented.
Strong knowledge of Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling and Snow-Flake Modeling.
Good understanding of Normalization /De-normalization and database design methodology.
5+ years of total experience in BI tools.
At least 3+ years of data visualization using Tableau 2020 or higher.
Familiarity with Thought Spot is a major plus.
Secondary Skill: Oracle CloudTertiary SkillOracle : Workflow Builder Required Skills:Agile, Tableau, Oracle1st shift (United States of America)