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

Mandatory Skills: ETL, Data Warehousing, Python, GCP Services

Required Skills:

● Bachelor’s degree in Computer Science or similar field or equivalent work experience.

● 4+ years of experience on Data Warehousing, Data Engineering or Data Integration projects.

● Expert with data warehousing concepts, strategies, and tools.

● Strong SQL background.

● Strong knowledge of relational databases like SQL Server, PostgreSQL, MySQL.

● Strong experience in GCP & Google BigQuery, Cloud SQL, Composer (Airflow), Dataflow, Dataproc, Cloud Function and GCS

● Good to have knowledge on SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS).

● Knowledge of AWS and Azure Cloud is a plus.

● Experience in Informatica Power exchange for Mainframe, Salesforce, and other new-age data sources.

● Experience in integration using APIs, XML, JSONs etc.

● In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework, data-warehousing and Data Lakes

● Good understanding of SDLC, Agile and Scrum processes.

● Strong problem-solving, multi-tasking, and organizational skills.

● Highly proficient in working with large volumes of business data and strong understanding of database design and implementation.

● Good written and verbal communication skills.

● Demonstrated experience of leading a team spread across multiple locations.

Role & Responsibilities:

● Work with business users and other stakeholders to understand business processes.

● Ability to design and implement Dimensional and Fact tables

● Identify and implement data transformation/cleansing requirements

● Develop a highly scalable, reliable, and high-performance data processing pipeline to extract, transform and load data from various systems to the Enterprise Data Warehouse

● Develop conceptual, logical, and physical data models with associated metadata including data lineage and technical data definitions

● Design, develop and maintain ETL workflows and mappings using the appropriate data load technique

● Provide research, high-level design, and estimates for data transformation and data integration from source applications to end-user BI solutions.

● Provide production support of ETL processes to ensure timely completion and availability of data in the data warehouse for reporting use.

● Analyze and resolve problems and provide technical assistance as necessary. Partner with the BI team to evaluate, design, develop BI reports and dashboards according to functional specifications while maintaining data integrity and data quality.

● Work collaboratively with key stakeholders to translate business information needs into well-defined data requirements to implement the BI solutions.

● Leverage transactional information, data from ERP, CRM, HRIS applications to model, extract and transform into reporting & analytics.

● Define and document the use of BI through user experience/use cases, prototypes, test, and deploy BI solutions.

● Develop and support data governance processes, analyze data to identify and articulate trends, patterns, outliers, quality issues, and continuously validate reports, dashboards and suggest improvements.

● Train business end-users, IT analysts, and developers.

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