7+ SSIS Jobs in Mumbai | SSIS Job openings in Mumbai

Project context

Summary

A new GIT platform will be created in our existing Captive in India (CASPL) and it will operate some activities of Digital Centre of Excellence (DEC)

Digital Centre of Excellence (DEC) manages a transverse offer of digital products and delivers IT services through its centers of excellence.

Activities encompass development of reusable components (building blocks), development and maintenance of business solutions that leverage on multiple expertise.

It requires professionals having technical competencies and noticeable experience on critical services in the context of an investment bank.

Working in DEC requires ability to extensively collaborate across geographies with other IT professionals and non-IT functions as well as a strong motivation on supporting the digital transformation of the bank.

Key Responsibilities

•Design & Develop Microsoft BI solutions to answer business needs

•Support existing BI application on their evolution / fixes based on the urgency

•Visualize, interpret, and report data findings and may create dynamic data reports as well

•Deliver code according to the specifications; follow code standards, versioning and branching

•Maintain a high standard of delivery quality

•Interact with business analysts in order to provide business focused solutions

•Interact with tech-leads, architects to ensure good design and code quality

•Work closely with the team, internal stakeholders and other cross functional teams

•Ensure documentations are up to date (technical design, deployment guide, release notes, etc.)

•Follow the user acceptance test and coordinate the prioritization with project manager

•Diagnose & resolve application/configuration/code level technical issues

•Create / amend necessary CI/CD pipelines using Azure DevOps

•Innovate and look for new solutions/components

•Build POCs to demonstrate new usage and present them in senior audience

•Perform regular peer-reviews, maintain low technical debts, assess & up-skill junior staffs

•Implement any possible automation of a recurrent process

Communication Key Internal Contacts

•GIT CASPL DEC – Operation manager

•GIT CASPL DEC – Squad leader

•GIT ISAP DEC – Product manager

Legal and Regulatory Responsibilities

•Comply with all applicable legal, regulatory and internal Compliance requirements, including, but not limited to, the local Compliance manual and the Financial Crime Policy. Complete any mandatory training in line with legal, regulatory and internal Compliance requirements.

•Maintain appropriate knowledge to ensure to be fully qualified to undertake the role. Complete all mandatory training as required to attain and maintain competence.

•Refrain from taking any steps which could lead to the removal of certification of fitness and properness to perform the role.

•Undertake all necessary steps to satisfy the annual certification process.

•Comply with all applicable conduct rules as prescribed by the relevant regulator.

ROLE REQUIREMENTS:

•Minimum 8+ years of experience with Microsoft BI stack components

•Experience and knowledge of SDLC or Agile development framework and methodologies

•Strong experience on data warehousing design, modelling and historization

•Experience with CI/CD practices using AzureDevOps

Degree holder in Computer Science or related discipline / relevant experience with MSBI technology A total of 8+ years in IT industry with a minimum of 6+ years of related working experience, in financial/banking environment.

Mandatory skills

•Experience with SQL Server (2017 / 2022)

•Experience in SQL query optimization; complex data retrievals and manipulations.

•Design and development of SSRS, PowerBI, ETL (SSIS)

•MDX/DAX, SSAS Tabular modelling

•C# experience for SSIS

Nice to have (Optional)

•Exposure with data processing pipelining using Python, PySpark, Airflow, etc

•Cloud development using Kubernetes, micro-services

•MPP database like Vertica

•Scripting using PowerShell

Data visualization tools Cognos, Tableau or Qlik

C#, SSRS, SQL Query Optimization, SQL Server (2017/2022), Microsoft Power BI

MSBI Developer- 

We have the following opening in our organization:

Years of Experience: Experience of  4-8 years. 

Location- Mumbai ( Thane)/BKC/Andheri
Notice period: Max 15 days or Immediate 

Educational Qualification: MCA/ME/Msc-IT/BE/B-Tech/BCA/BSC IT in Computer Science/B.Tech

Requirements:

•   3- 8 years of consulting or relevant work experience
• Should be good in SQL Server 2008 R2 and above.
• Should be excellent at SQL, SSRS & SSIS, SSAS,
• Data modeling, Fact & dimension design, work on a data warehouse or dw architecture design.
• Implementing new technology like power BI, power bi modeling.  
• Knowledge of Azure or R-programming is an added advantage.
• Experiences in BI and Visualization Technology (Tableau, Power  BI).
• Advanced T-SQL programming skill
• Can scope out a simple or semi-complex project based on business requirements and achievable benefits
• Evaluate, design, and implement enterprise IT-based business solutions, often working on-site to help customers deploy their solutions.

Office Location: Goregaon Mumbai

Position description:

4+ years of experience in database development.

Primary Responsibilities:

• Understand requirements from front end applications developers
• Write advanced queries, stored procedures, cursors, functions & triggers
• Conduct code reviews
• Work with high-traffic application servers
• Complete understanding of various DB like Postgresql, Mongo DB, MySQL 
• Ability to identify root cause and mitigate issues
• Ability to lead a team of DB developers

Required Skills:

Mandatory: Passionate about sports, Problem solving, Team player, Target & Result oriented, Strong communication skills

Functional: Oracle SQL, PostgreSQL Development - TSQL, Advance Queries, Query Optimization, Stored Procedures, Triggers & Cursors, Database Design, Indexes, Joins, ETL tools like SSAS, SSIS, High Data Volume Processing, DB Backup/Recovery.

• Expertise in designing and implementing enterprise scale database (OLTP) and Data warehouse solutions.
• Hands on experience in implementing Azure SQL Database, Azure SQL Date warehouse (Azure Synapse Analytics) and big data processing using Azure Databricks and Azure HD Insight.
• Expert in writing T-SQL programming for complex stored procedures, functions, views and query optimization.
• Should be aware of Database development for both on-premise and SAAS Applications using SQL Server and PostgreSQL.
• Experience in ETL and ELT implementations using Azure Data Factory V2 and SSIS.
• Experience and expertise in building machine learning models using Logistic and linear regression, Decision tree  and Random forest Algorithms.
• PolyBase queries for exporting and importing data into Azure Data Lake.
• Building data models both tabular and multidimensional using SQL Server data tools.
• Writing data preparation, cleaning and processing steps using Python, SCALA, and R.
• Programming experience using python libraries NumPy, Pandas and Matplotlib.
• Implementing NOSQL databases and writing queries using cypher.
• Designing end user visualizations using Power BI, QlikView and Tableau.
• Experience working with all versions of SQL Server 2005/2008/2008R2/2012/2014/2016/2017/2019
• Experience using the expression languages MDX and DAX.
• Experience in migrating on-premise SQL server database to Microsoft Azure.
• Hands on experience in using Azure blob storage, Azure Data Lake Storage Gen1 and Azure Data Lake Storage Gen2.
• Performance tuning complex SQL queries, hands on experience using SQL Extended events.
• Data modeling using Power BI for Adhoc reporting.
• Raw data load automation using T-SQL and SSIS
• Expert in migrating existing on-premise database to SQL Azure.
• Experience in using U-SQL for Azure Data Lake Analytics.
• Hands on experience in generating SSRS reports using MDX.
• Experience in designing predictive models using Python and SQL Server.
• Developing machine learning models using Azure Databricks and SQL Server

NeoQuant Solutions Pvt Ltd

NeoQuant Solutions is a Software Application Development and Software Services company that uses cutting edge technologies in developing software. We provide software solutions and custom products in the domain of Insurance, Banking and Media sector that are known for the use of the latest technology. We believe in innovations and simplicity to solve the business problems of our clients and partners.

Website: https://neoquant.com/">https://neoquant.com/ 

MSBI Developer- 

We have the following opening in our organization:

Years of Experience: Experience of  3 - 8 years 

Location- Mumbai (thane, BKC, Andheri)

Educational Qualification: MCA/ME/Msc-IT/BE/B-Tech/BCA/BSC IT in Computer Science/B.Tech

Requirements:

• 3 - 8 years of consulting or relevant work experience
• Should be good in SQL Server 2008 R2 and above.
• Should be excellent at SQL, SSRS & SSIS, SSAS,

• Data modelling, Fact & dimension design, work on a data warehouse or dw architecture design.
• Implementing new technology like power BI, power bi modeling.  
• Knowledge of Azure or R-programming is an added advantage.

• Can scope out a simple or semi-complex project based on business requirements and achievable benefits
• Evaluate, design, and implement enterprise IT-based business solutions, often working on-site to help customers deploy their solutions