SSIS Jobs in Bangalore (Bengaluru)

Explore top SSIS Job opportunities in Bangalore (Bengaluru) from Top Companies & Startups. All jobs are added by verified employees who can be contacted directly below.
icon
icon
Bengaluru (Bangalore)
icon
10 - 15 yrs
icon
₹12L - ₹32L / yr
T-SQL
SQL
Stored Procedures
MS SQLServer
SSIS

Job Profile

Purpose of Role: To support and maintain the existing and future applications managed by ABD (Agile Business Development) Team.

 

Main Responsibilities:

  • To work on existing and future applications as required
  • Work with ABD India Application Support and Business Support team to address production issues and/or to do development work
  • Work with US ABD team to coordinate the on-going support and monthly release of C-Hub (Customer-Hub) application and other ABD Applications
  • Report status to management on project progress
  • Identify and escalate related issues and risks
  • Coordinate with others in Development and Business Support team to implement new features of SQL Server/ MS Web based technologies 
  • Assess current modules and offer performance improvements techniques  
  • Make sure Database Design Standards/coding standards established by ABD are followed
  • Constant communication with ABD leadership team in US.
  • Problem Solving ability with “Can-do” attitude
  • IT experience in Banking industry is preferred

Candidate Profile:

  • Minimum 10 years of experience at least 3-5 years of experience in Corporate & Investment Banking area and Bachelor's degree in Engineering, Accounting, Finance, or equivalent
  • Expertise with MS SQL Server development including SSIS and SSRS, Proficient in development of Stored procedure, Views, Functions etc in MS SQL Server
  • Experienced with DBA kind tasks such as replication, linked server, query analyzer, DBCC commands, data transfer from one DB server to other DB Server etc
  • Experienced in MS Excel VBA and macro scripting
  • Knowledge of data Encryption in database

 

 
Read more

Global business process management company

Agency job
via Jobdost by Saida Jabbar
icon
Pune, Mumbai, Bengaluru (Bangalore)
icon
3 - 6 yrs
icon
₹10L - ₹13L / yr
ASP.NET MVC
SQL server
MVC Framework
.NET
ASP.NET
+10 more

JOB DESCRIPTION

 

Job brief

We are looking for a ASP.Net MVC Web developer to build software using languages and technologies of the .NET framework. You will create applications from scratch, enhance existing applications configure existing systems and provide user support.

In this role, you should be able to write functional code with a sharp eye for spotting defects. You should be a team player and excellent. communicator. If you are also passionate about the .NET framework and software design/architecture, we’d like to meet you.

Your goal will be to work with internal teams to design, develop and maintain software.

Responsibilities

  • Participate in requirements analysis
  • Collaborate with internal teams to produce software design and architecture
  • Write clean, scalable code using C#.NET, JavaScript, & TSQL programming languages
  • Test and deploy applications and systems
  • Revise, update, refactor and debug code
  • Improve existing software
  • Develop documentation throughout the software development life cycle (SDLC)
  • Ensure the best possible performance, quality, and responsiveness of applications
  • Serve as an expert on applications and provide technical support
  • Help maintain code quality
  • Good hands on designing, coding, debugging, technical problem solving, and writing Unit Test cases, etc.

Mandatory skills:

  • Proficient in Web Application development using ASP.NET, C# with .Net version 4.5+.
  • Familiarity with the ASP.NET framework, SQL Server and design/architectural patterns (e.g. Model-View-Controller (MVC))
  • Experience with SQL Server or any other equivalent Database and know how to build efficient queries.
  • Strong knowledge on jQuery, AJAX, JavaScript, HTML5, CSS3 and Bootstrap.
  • Good to have experience on SSIS.
  • Experience in debugging in multiple browsers.
  • Strong understanding of object-oriented programming.
  • Clear understanding of TFS or an equivalent VCS.
  • Familiar with IIS and deploying code to Web Server.
  • Understanding of Agile methodologies
  • Excellent troubleshooting and communication skills
  • Attention to detail
  • BSc/BE in Computer Science, Engineering or a related field

 

QUALIFICATIONS

 

B.E. / B.Tech. /MSC in Computer Science or IT.

 

ADDITIONAL INFORMATION

 

IT experience in C# and ASP.NET, Web application development.

 

Read more
DP
Posted by Jyoti Kaushik
icon
Noida, Bengaluru (Bangalore), Pune, Hyderabad
icon
4 - 7 yrs
icon
₹4L - ₹16L / yr
ETL
SQL
Data Warehouse (DWH)
Informatica
Datawarehousing
+2 more

We are looking for a Senior Data Engineer to join the Customer Innovation team, who will be responsible for acquiring, transforming, and integrating customer data onto our Data Activation Platform from customers’ clinical, claims, and other data sources. You will work closely with customers to build data and analytics solutions to support their business needs, and be the engine that powers the partnership that we build with them by delivering high-fidelity data assets.

In this role, you will work closely with our Product Managers, Data Scientists, and Software Engineers to build the solution architecture that will support customer objectives. You'll work with some of the brightest minds in the industry, work with one of the richest healthcare data sets in the world, use cutting-edge technology, and see your efforts affect products and people on a regular basis. The ideal candidate is someone that

  • Has healthcare experience and is passionate about helping heal people,
  • Loves working with data,
  • Has an obsessive focus on data quality,
  • Is comfortable with ambiguity and making decisions based on available data and reasonable assumptions,
  • Has strong data interrogation and analysis skills,
  • Defaults to written communication and delivers clean documentation, and,
  • Enjoys working with customers and problem solving for them.

A day in the life at Innovaccer:

  • Define the end-to-end solution architecture for projects by mapping customers’ business and technical requirements against the suite of Innovaccer products and Solutions.
  • Measure and communicate impact to our customers.
  • Enabling customers on how to activate data themselves using SQL, BI tools, or APIs to solve questions they have at speed.

What You Need:

  • 4+ years of experience in a Data Engineering role, a Graduate degree in Computer Science, Statistics, Informatics, Information Systems, or another quantitative field.
  • 4+ years of experience working with relational databases like Snowflake, Redshift, or Postgres.
  • Intermediate to advanced level SQL programming skills.
  • Data Analytics and Visualization (using tools like PowerBI)
  • The ability to engage with both the business and technical teams of a client - to document and explain technical problems or concepts in a clear and concise way.
  • Ability to work in a fast-paced and agile environment.
  • Easily adapt and learn new things whether it’s a new library, framework, process, or visual design concept.

What we offer:

  • Industry certifications: We want you to be a subject matter expert in what you do. So, whether it’s our product or our domain, we’ll help you dive in and get certified.
  • Quarterly rewards and recognition programs: We foster learning and encourage people to take risks. We recognize and reward your hard work.
  • Health benefits: We cover health insurance for you and your loved ones.
  • Sabbatical policy: We encourage people to take time off and rejuvenate, learn new skills, and pursue their interests so they can generate new ideas with Innovaccer.
  • Pet-friendly office and open floor plan: No boring cubicles.
Read more
DP
Posted by Baiju Sukumaran
icon
Remote, Vadodara, Bengaluru (Bangalore), Pune, Ahmedabad
icon
7 - 9 yrs
icon
Best in industry
Spotfire
Qlikview
Tableau
PowerBI
Data Visualization
+6 more
Key Responsibilities
 Ability to interpret and map business, functional and non functional requirements to technical specifications
 Interact with diverse stakeholders like clients, project manager/scrum master, business analysts, testing and
other cross-functional teams as part of Business Intelligence projects
 Develop solutions following established technical design, application development standards and quality processes in projects to deliver efficient, reusable and reliable code with complete ownership
 Assess the impacts on technical design because of the changes in functional requirements.
 Developing the full life cycle of a BI project (data movement and visualization) which includes requirements analysis , platform selection , architecture , application design and development , testing and deployment
 Provide architectural leadership with a strong emphasis on data architecture around ETL and governance
 Troubleshoot highly complex technical problems in a OLAP/OLTP/DW based environments
 Provide support specific to application bugs or issues within defined SLAs
 Proactively identify and communicate technical risks, issues, and challenges with mitigations
 Perform independent code reviews and guide junior team members for correction

Must Have Technical Skills :
3+ years of experience leading data warehouse implementation with technical architectures , ETL / ELT, reporting / analytic tools and scripting (end to end implementation)
 Experienced in Microsoft Azure (Azure SQL Managed Instance , Data Factory , Azure Synapse, Azure Monitoring, Azure DevOps , Event Hubs , Azure AD Security)
 Deep experience in using any BI tools such as Power BI/Tableau, QlikView/SAP-BO etc.,
 Experienced in ETL tools such as SSIS, Talend/Informatica/Pentaho
 Expertise in using RDBMSes like Oracle, SQL Server as source or target and online analytical processing (OLAP)
 Experienced in SQL/T-SQL/ DML/DDL statements, stored procedure, function, trigger, indexes, cursor
 Expertise in building and organizing advanced DAX calculations and SSAS cubes
 Experience in data/dimensional modelling, analysis, design, testing, development, and implementation
 Experienced in advanced data warehouse concepts using structured, semi-structured and un-structured data
 Experienced with real time ingestion, change data capture, real time & batch processing
 Good knowledge of meta data management and data governance
 Great problem solving skills, with a strong bias for quality and design excellence
 Experienced in developing dashboards with a focus on usability, performance, flexibility, testability, and
standardization.
 Familiarity with development in cloud environments like AWS / Azure / Google
Read more
icon
Bengaluru (Bangalore)
icon
1 - 4 yrs
icon
₹7L - ₹12L / yr
SQL Server Integration Services (SSIS)
SQL
ETL
Informatica
Data Warehouse (DWH)
+4 more

About Company:

Working with a multitude of clients populating the FTSE and Fortune 500s, Audit Partnership is a people focused organization with a strong belief in our employees. We hire the best people to provide the best services to our clients.

APL offers profit recovery services to organizations of all sizes across a number of sectors. APL was borne out of a desire to offer an alternative from the stagnant service provision on offer in the profit recovery industry.

Every year we cover million of pounds for our clients and also work closely with them, sharing our audit findings to minimize future losses. Our dedicated and highly experienced audit teams utilize progressive & dynamic financial service solutions & industry leading technology to achieve maximum success.

We provide dynamic work environments focused on delivering data-driven solutions at a rapidly increased pace over traditional development. Be a part of our passionate and motivated team who are excited to use the latest in software technologies within financial services.

Headquartered in the UK, we have expanded from a small team in 2002 to a market leading organization serving clients across the globe while keeping our clients at the heart of all decisions we make.


Job description:

We are looking for a high-potential, enthusiastic SQL Data Engineer with a strong desire to build a career in data analysis, database design and application solutions. Reporting directly to our UK based Technology team, you will provide support to our global operation in the delivery of data analysis, conversion, and application development to our core audit functions.

Duties will include assisting with data loads, using T-SQL to analyse data, front-end code changes, data housekeeping, data administration, and supporting the Data Services team as a whole.  Your contribution will grow in line with your experience and skills, becoming increasingly involved in the core service functions and client delivery.  A self-starter with a deep commitment to the highest standards of quality and customer service. We are offering a fantastic career opportunity, working for a leading international financial services organisation, serving the world’s largest organisations.

 

What we are looking for:

  • 1-2 years of previous experience in a similar role
  • Data analysis and conversion skills using Microsoft SQL Server is essential
  • An understanding of relational database design and build
  • Schema design, normalising data, indexing, query performance analysis
  • Ability to analyse complex data to identify patterns and detect anomalies
  • Assisting with ETL design and implementation projects
  • Knowledge or experience in one or more of the key technologies below would be preferable:
    • Microsoft SQL Server (SQL Server Management Studio, Stored Procedure writing etc)
    • T-SQL
    • Programming languages (C#, VB, Python etc)
    • Use of Python to manipulate and import data
    •  
    • Experience of ETL/automation advantageous but not essential (SSIS/Prefect/Azure)
  • A self-starter who can drive projects with minimal guidance
  • Meeting stakeholders to agree system requirements
  • Someone who is enthusiastic and eager to learn
  • Very good command of English and excellent communication skills

 

Perks & Benefits:

  • A fantastic work life balance
  • Competitive compensation and benefits
  • Exposure of working with Fortune 500 organization
  • Expert guidance and nurture from global leaders
  • Opportunities for career and personal advancement with our continued global growth strategy
  • Industry leading training programs
  • A working environment that is exciting, fun and engaging

 

Read more

A global provider of Business Process Management company

Agency job
via Jobdost by Saida Jabbar
icon
Bengaluru (Bangalore), UK
icon
5 - 10 yrs
icon
₹15L - ₹25L / yr
Data Visualization
PowerBI
ADF
Business Intelligence (BI)
PySpark
+11 more

Power BI Developer

Senior visualization engineer with 5 years’ experience in Power BI to develop and deliver solutions that enable delivery of information to audiences in support of key business processes. In addition, Hands-on experience on Azure data services like ADF and databricks is a must.

Ensure code and design quality through execution of test plans and assist in development of standards & guidelines working closely with internal and external design, business, and technical counterparts.

Candidates should have worked in agile development environments.

Desired Competencies:

  • Should have minimum of 3 years project experience using Power BI on Azure stack.
  • Should have good understanding and working knowledge of Data Warehouse and Data Modelling.
  • Good hands-on experience of Power BI
  • Hands-on experience T-SQL/ DAX/ MDX/ SSIS
  • Data Warehousing on SQL Server (preferably 2016)
  • Experience in Azure Data Services – ADF, DataBricks & PySpark
  • Manage own workload with minimum supervision.
  • Take responsibility of projects or issues assigned to them
  • Be personable, flexible and a team player
  • Good written and verbal communications
  • Have a strong personality who will be able to operate directly with users
Read more
Agency job
via Nu-Pie by Trisha Paul
icon
Mumbai, Kolkata, Bengaluru (Bangalore)
icon
4 - 6 yrs
icon
₹6L - ₹11L / yr
Technical support
Tech Support
MS SQLServer
SSIS
Microsoft SSRS

Job Description - He/she  will be responsible to take care of vendor product support and maintenance, and If experience in MS SQL SSIS and SSRS is an additional advantage
Must Have Skill - MS SQL SSIS and SSRS
Good to have skill  - Good Communication, Team Builder, Logical Thinking
Delivery Skill - Hands on Database-MS SQL, Hands on SSIS and SSRS, communication skills, Common Tools such as Version Control tools, Build tools, continuous integration, production support tools

 

Read more
icon
Bengaluru (Bangalore)
icon
3 - 8 yrs
icon
₹6L - ₹14L / yr
SQL Server Integration Services (SSIS)
SSIS
SQL Server Reporting Services (SSRS)
SSRS
Microsoft SQL Server
+4 more

Primary Responsibilities:

  • We need strong SQL database development skills using the MS SQL server.
  • Strong skill in SQL server integration services (SSIS) for ETL development.
  • Strong Experience in full life cycle database development project using SQL server.
  • Experience in designing and implementing complex logical and physical data models.
  • Exposure to web services & web technologies (Javascript, Jquery, CSS, HTML).
  • Knowledge of other high-level languages (PERL, Python) will be an added advantage
  • Nice to have SQL certification.

Good to have:

•             Bachelor’s degree or a minimum of 3+ years of formal industry/professional experience in software development – Healthcare background preferred.
Read more
DP
Posted by Rajendra Dasigari
icon
Bengaluru (Bangalore)
icon
2 - 7 yrs
icon
₹6L - ₹12L / yr
ETL
Data Warehouse (DWH)
Apache Hive
Informatica
Data engineering
+5 more
1. Create and maintain optimal data pipeline architecture
2. Assemble large, complex data sets that meet business requirements
3. Identify, design, and implement internal process improvements
4. Optimize data delivery and re-design infrastructure for greater scalability
5. Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS technologies
6. Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics
7. Work with internal and external stakeholders to assist with data-related technical issues and support data infrastructure needs
8. Create data tools for analytics and data scientist team members
 
Skills Required:
 
1. Working knowledge of ETL on any cloud (Azure / AWS / GCP)
2. Proficient in Python (Programming / Scripting)
3. Good understanding of any of the data warehousing concepts (Snowflake / AWS Redshift / Azure Synapse Analytics / Google Big Query / Hive)
4. In-depth understanding of principles of database structure
5.  Good understanding of any of the ETL technologies (Informatica PowerCenter / AWS Glue / Data Factory / SSIS / Spark / Matillion / Talend / Azure)
6. Proficient in SQL (query solving)
7. Knowledge in Change case Management / Version Control – (VSS / DevOps / TFS / GitHub, Bit bucket, CICD Jenkin)
Read more
DP
Posted by Anees MD
icon
Bengaluru (Bangalore)
icon
5 - 8 yrs
icon
₹7L - ₹18L / yr
Tableau
SSIS
Microsoft SSMS

Look for people having the below skills:

  1. SSIS / SSMS Minimum of 6+ Years
  2. Tableau: Minimum of 5+ Years
Read more

at 1CH

DP
Posted by Sathish Sukumar
icon
Chennai, Bengaluru (Bangalore), Hyderabad, NCR (Delhi | Gurgaon | Noida), Mumbai, Pune
icon
4 - 15 yrs
icon
₹10L - ₹25L / yr
Data engineering
Data engineer
ETL
SSIS
ADF
+3 more
  • 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
Read more

MNC

Agency job
via Fragma Data Systems by geeti gaurav mohanty
icon
Bengaluru (Bangalore), Hyderabad, Pune
icon
3 - 8 yrs
icon
₹8L - ₹16L / yr
ADF
SSIS
Job Responsibilities/KRAs:
Responsibilities
 Understand business requirement and actively provide inputs from Data perspective.
 Experience of SSIS development.
 Experience in Migrating SSIS packages to Azure SSIS Integrated Runtime
 Experience in Data Warehouse / Data mart development and migration
 Good knowledge and Experience on Azure Data Factory
 Expert level knowledge of SQL DB & Datawarehouse
 Should know at least one programming language (python or PowerShell)
 Should be able to analyse and understand complex data flows in SSIS.
 Knowledge on Control-M
 Knowledge of Azure data lake is required.
 Excellent interpersonal/communication skills (both oral/written) with the ability to communicate
at various levels with clarity & precision.
 Build simple to complex pipelines & dataflows.
 Work with other Azure stack modules like Azure Data Lakes, SQL DW, etc.
Requirements
 Bachelor’s degree in Computer Science, Computer Engineering, or relevant field.
 A minimum of 5 years’ experience in a similar role.
 Strong knowledge of database structure systems and data mining.
 Excellent organizational and analytical abilities.
 Outstanding problem solver.
 Good written and verbal communication skills.
Read more
icon
Remote, Bengaluru (Bangalore)
icon
3 - 10 yrs
icon
₹5L - ₹15L / yr
Big Data
ETL
PySpark
SSIS
Microsoft Windows Azure
+4 more

Must Have Skills:

- Solid Knowledge on DWH, ETL and Big Data Concepts

- Excellent SQL Skills (With knowledge of SQL Analytics Functions)

- Working Experience on any ETL tool i.e. SSIS / Informatica

- Working Experience on any Azure or AWS Big Data Tools.

- Experience on Implementing Data Jobs (Batch / Real time Streaming)

- Excellent written and verbal communication skills in English, Self-motivated with strong sense of ownership and Ready to learn new tools and technologies

Preferred Skills:

- Experience on Py-Spark / Spark SQL

- AWS Data Tools (AWS Glue, AWS Athena)

- Azure Data Tools (Azure Databricks, Azure Data Factory)

Other Skills:

- Knowledge about Azure Blob, Azure File Storage, AWS S3, Elastic Search / Redis Search

- Knowledge on domain/function (across pricing, promotions and assortment).

- Implementation Experience on Schema and Data Validator framework (Python / Java / SQL),

- Knowledge on DQS and MDM.

Key Responsibilities:

- Independently work on ETL / DWH / Big data Projects

- Gather and process raw data at scale.

- Design and develop data applications using selected tools and frameworks as required and requested.

- Read, extract, transform, stage and load data to selected tools and frameworks as required and requested.

- Perform tasks such as writing scripts, web scraping, calling APIs, write SQL queries, etc.

- Work closely with the engineering team to integrate your work into our production systems.

- Process unstructured data into a form suitable for analysis.

- Analyse processed data.

- Support business decisions with ad hoc analysis as needed.

- Monitoring data performance and modifying infrastructure as needed.

Responsibility: Smart Resource, having excellent communication skills

 

 
Read more
Agency job
via Nu-Pie by Jerrin Thomas
icon
Bengaluru (Bangalore)
icon
6 - 9 yrs
icon
₹10L - ₹18L / yr
ETL
Windows Azure
ADF
SQL Azure
SSIS
+4 more

 

1) 6-9 years of industry experience and at least 4 years of experience in an architect role is required, along with at least 3-5 year experience in designing and building analytics/data solutions in Azure.

2) Demonstrated in-depth skills with Azure Data Factory(ADF),Azure SQL Server, Azure Synapse, ADLS with the ability to configure and administrate all aspects of Azure SQL Server.

3) Demonstrated experience delivering multiple data solutions as an architect.

4) Demonstrated experience with ETL development both on-premises and in the cloud using SSIS, Data Factory, and related Microsoft and other ETL technologies

5) DP-200 and DP-201 certifications preferred.

6) Good to have hands on experience in Power BI and Azure Databricks.

7)Should have good communication and presentation skills.

Read more
DP
Posted by Jerrin Thomas
icon
Bengaluru (Bangalore)
icon
1 - 3 yrs
icon
₹3L - ₹5L / yr
PowerBI
Tableau
MS-Excel
SQL
DAX
+2 more
Required Skills and Experience
• • General or Strong IT background, with at least 2 to 4 years of working experience
• o Strong understanding of data integration and ETL methodologies.
• o Demonstrated ability to multi-task
• o Excellent English communication skills
• o A desire to be a part of growing company. You'll have 2 core responsibilities (Client Work, and Company Building), and we expect dedication to both.
• o Willingness to learn and work on new technologies.
• o Should be a quick and self-learner.

Tools:
1. Good Knowledge of Power Bi and Tableau
2. Good experience in handling data in Excel.
Read more
DP
Posted by Jerrin Thomas
icon
Bengaluru (Bangalore)
icon
2 - 4 yrs
icon
₹4L - ₹6L / yr
SSIS
ETL
Snap Logic
MuleSoft
Informatica
+5 more
The Data Engineer is at the core of our customer’s success. We are looking for talented and
experienced engineers to join our team. If you are a problem solver and enjoy working on an exciting
and fast-paced environment, this may be the perfect opportunity for you to join us and take your
career to the next level.
Responsibilities
• • Communicate effectively with customers, including expectations for callbacks and followup
on their issues.
• • Handle technical issues of different complexity and help other members of the team.
• • Collaborate with other support teams, Engineering and other internal departments to help
resolve critical issues.
• • Cross train on multiple technologies to effectively build and support product/technology
portfolio.
• • Troubleshoot, diagnose & resolve customer issues independently, making use of the
resources available to you.
• • Keep all the ongoing cases documented and up to date in the case management system.
• • Promote and maintain a high quality, professional, service orientated DigiTop image
amongst internal and external customers.
• • Works in adherence to defined processes and procedures implemented in the organization
• • Maintain and continually upgrade technical understanding of products and technologies.
• • Build and maintain solid working relationships with the members of the team.
• • Write and/or edit knowledge articles for every issue resolved.
Required Skills and Experience
• • General o Strong IT background, with at least 2 to 4 years of working experience
• o Strong understanding of data integration and ETL methodologies.
• o Degree in Computer Science or equivalent experience.
• o Demonstrated ability to multi-task
• o Excellent English communication skills
• o A desire to be a part of growing company. You'll have 2 core responsibilities (Client Work,
and Company Building), and we expect dedication to both.
• o Willingness to learn and work on new technologies.
• o Should be a quick and self-learner.
• • Technical o Extensive experience using ETL methodology for supporting Data Extraction,
Transformations, Data validation and Loading.
• o Experience in Database skills (load data from Excel/CSV/Text files to staging, write sql
statements/functions/ stored procedures, run SSIS packages).
• o Knowledge of integrating with different data sources such as SQL, Web Services, API’s,
text files and CSV is mandatory
• o Extensive experience troubleshooting and solving complex
technical problems.
• o Experience in at-least one of the ETL Tools (SSIS).
• o Knowledge of other ETL Tools such as Snaplogic, IBM Data Stage, Mulesoft and
Informatica is a plus.
• o Knowledge of different/diversified technologies will be added advantage. Additional
weightage will be given.
• o Experience with Visualization tools Power BI, Qlik Sense and
Tableau is preferred
Read more
Agency job
via Nu-Pie by Jerrin Thomas
icon
Bengaluru (Bangalore)
icon
5 - 8 yrs
icon
₹8L - ₹13L / yr
ETL
Data Warehouse (DWH)
ETL Developer
Relational Database (RDBMS)
Spark
+8 more

 Minimum of 4 years’ experience of working on DW/ETL projects and expert hands-on working knowledge of ETL tools.

Experience with Data Management & data warehouse development

Star schemas, Data Vaults, RDBMS, and ODS

Change Data capture

Slowly changing dimensions

Data governance

Data quality

Partitioning and tuning

Data Stewardship

Survivorship

Fuzzy Matching

Concurrency

Vertical and horizontal scaling

ELT, ETL

Spark, Hadoop, MPP, RDBMS

Experience with Dev/OPS architecture, implementation and operation

Hand's on working knowledge of Unix/Linux

Building Complex SQL Queries. Expert SQL and data analysis skills, ability to debug and fix data issue.

Complex ETL program design coding

Experience in Shell Scripting, Batch Scripting.

Good communication (oral & written) and inter-personal skills

Expert SQL and data analysis skill, ability to debug and fix data issue Work closely with business teams to understand their business needs and participate in requirements gathering, while creating artifacts and seek business approval.

Helping business define new requirements, Participating in End user meetings to derive and define the business requirement, propose cost effective solutions for data analytics and familiarize the team with the customer needs, specifications, design targets & techniques to support task performance and delivery.

Propose good design & solutions and adherence to the best Design & Standard practices.

Review & Propose industry best tools & technology for ever changing business rules and data set. Conduct Proof of Concepts (POC) with new tools & technologies to derive convincing benchmarks.

Prepare the plan, design and document the architecture, High-Level Topology Design, Functional Design, and review the same with customer IT managers and provide detailed knowledge to the development team to familiarize them with customer requirements, specifications, design standards and techniques.

Review code developed by other programmers, mentor, guide and monitor their work ensuring adherence to programming and documentation policies.

Work with functional business analysts to ensure that application programs are functioning as defined. 

Capture user-feedback/comments on the delivered systems and document it for the client and project manager’s review. Review all deliverables before final delivery to client for quality adherence.

Technologies (Select based on requirement)

Databases - Oracle, Teradata, Postgres, SQL Server, Big Data, Snowflake, or Redshift

Tools – Talend, Informatica, SSIS, Matillion, Glue, or Azure Data Factory

Utilities for bulk loading and extracting

Languages – SQL, PL-SQL, T-SQL, Python, Java, or Scala

J/ODBC, JSON

Data Virtualization Data services development

Service Delivery - REST, Web Services

Data Virtualization Delivery – Denodo

 

ELT, ETL

Cloud certification Azure

Complex SQL Queries

 

Data Ingestion, Data Modeling (Domain), Consumption(RDMS)
Read more
Get to hear about interesting companies hiring right now
iconFollow Cutshort
Why apply via Cutshort?
Connect with actual hiring teams and get their fast response. No spam.
Learn more
Get to hear about interesting companies hiring right now
iconFollow Cutshort