Solution Architect - SSIS/Tableau (1-2 yrs)
Job Description :
Overall purpose of job :
- Understand client requirements and build entire tech solution.
- Lead the team to deliver the project end to end.
- Find innovative ways to accomplish tasks and handle multiple projects simultaneously and independently.
- Strong experience in full-stack development front end and back end.
- Effectively communicate with business stakeholders and clients.
Duties & Responsibilities :
1. Understand technical requirements and design a solution involving multiple data sources. Provide detailed estimates for development, design, testing and integration of the solution.
2. Own development responsibilities for building the solution.
3. Resolve any technical issues that may arise and ensure smooth development and delivery of a solution.
4. Ensure appropriate testing of the solution and necessary co-ordination for the quality process.
5. Provide support for the entire quality process including support for user testing.
6. Lead/guide and develop prototype web applications on html5 framework.
7. Resolve complex issues, conduct architecture level quality control reviews and suggest ways to improve the performance of current solutions.
8. Ensure best practices are followed: documentation, version control, arch/code review, load testing, stakeholder communication, knowledge transfer etc.
Skills required :
1. Deep expertise in system design and architecture, ability to evaluate different technology tools and stack for specific business requirements,
2. Experience in software architecture, cloud design, API definition, system performance analysis etc
3. Strong data extraction, database design, dimension modelling and data integration skills.
5. Exposure to traditional bi architecture (database, etl and reporting/ visualization) is a plus.
6. The stack we use is SQL server, alteryx/ ssis and tableau)
7. Ability to design a database to store huge data with proper index and key combination to provide speedy delivery of data to clients/end users