Senior Consultant Technical - ETL + SQL Expertise

2 Days ago • All levels • Programming

Job Summary

Job Description

The Senior Consultant will integrate and map customer data from client source systems to the insightsoftware platform. This role involves performing extract, transform, load (ETL) activities for accurate and timely data conversions, providing in-depth research and analysis for complex scenarios to develop innovative solutions, and mapping business requirements to solution designs. Responsibilities include presenting findings to stakeholders, identifying and documenting data gaps for change impact analysis, and collaborating with clients and project managers throughout the conversion/integration process. Experience with data assessment, real-time and batch ETL, and data mapping tools is essential, along with strong SQL scripting skills and knowledge of SDLC methodologies.
Must have:
  • Assess data and analytic requirements
  • Experience with real-time, batch, and ETL
  • Working knowledge of ETL methodologies and tools
  • Utilize data mapping tools
  • Working experience using Oracle SQL, Excel, .csv
  • Strong SQL scripting experience
  • Communicate with clients and Project Manager
  • Collaborate via phone and email
  • Demonstrated collaboration and problem-solving skills
  • Working knowledge of SDLC methodologies
  • Clear understanding of cloud and application integrations
  • Ability to work independently and manage multiple tasks
  • Ensure data conversion/integration accuracy and deadlines
  • Experience in customer SIT, UAT, migration and go live support

Job Details

Job Description

Location: Hyderabad (Work from Office- Hybrid)

Working Hours: 2:30 PM to 11:30 PM for 3 Days 5:00 PM - 2:00AM IST or 6:00 PM to 3:00 AM IST for 2 Days, should be ok to work in night shift as per requirement.

Position Summary

The Senior Consultant will integrate and map customer data from client source system(s) to our industry-leading platform.  The role will include, but is not limited to:

  • Using strong technical data migration, scripting, and organizational skills to ensure the client data is converted efficiently and accurately to the insightsoftware (ISW) platform.
  • Performing extract, transform, load (ETL) activities to ensure accurate and timely data conversions.
  • Providing in-depth research and analysis of complex scenarios to develop innovative solutions to meet customer needs whilst remaining within project governance.
  • Mapping and maintaining business requirements to the solution design using tools such as requirements traceability matrices (RTM).
  • Presenting findings, requirements, and problem statements for ratification by stakeholders and working groups.
  • Identifying and documenting data gaps to allow change impact and downstream impact analysis to be conducted.

Qualifications

  • Experience assessing data and analytic requirements to establish mapping rules from source to target systems to meet business objectives.
  • Experience with real-time, batch, and ETL for complex data conversions.
  • Working knowledge of extract, transform, load (ETL) methodologies and tools such as Talend, Dell Boomi, etc.
  • Utilize data mapping tools to prepare data for data loads based on target system specifications.
  • Working experience using various data applications/systems such as Oracle SQL, Excel, .csv files, etc. 
  • Strong SQL scripting experience.
  • Communicate with clients and/or ISW Project Manager to scope, develop, test, and implement conversion/integration
  • Effectively communicate with ISW Project Managers and customers to keep project on target
  • Continually drive improvements in the data migration process.
  • Collaborate via phone and email with clients and/or ISW Project Manager throughout the conversion/integration process.
  • Demonstrated collaboration and problem-solving skills.
  • Working knowledge of software development lifecycle (SDLC) methodologies including, but not limited to: Agile, Waterfall, and others.
  • Clear understanding of cloud and application integrations.
  • Ability to work independently, prioritize tasks, and manage multiple tasks simultaneously.
  • Ensure client’s data is converted/integrated accurately and within deadlines established by ISW Project Manager.
  • Experience in customer SIT, UAT, migration and go live support.

Additional Information

All your information will be kept confidential according to EEO guidelines.

** At this time insightsoftware is not able to offer sponsorship to candidates who are not eligible to work in the country where the position is located. **

** At this time insightsoftware is not able to offer sponsorship to candidates who are not eligible to work in the country where the position is located. **

insightsoftware About Us: Hear From Our Team - InsightSoftware (wistia.com)

Background checks are required for employment with insightsoftware, where permitted by country, state/province.

At insightsoftware, we are committed to equal employment opportunity regardless of race, color, ethnicity, ancestry, religion, national origin, gender, sex, gender identity or expression, sexual orientation, age, citizenship, marital or parental status, disability, veteran status, or other class protected by applicable law. We are proud to be an equal opportunity workplace.

Similar Jobs

Rippling - Senior Compensation Manager

Rippling

Bengaluru, Karnataka, India (On-Site)
2 Months ago
Thumbtack - Senior Experience Researcher

Thumbtack

United States (Remote)
2 Months ago
Regent craft - Autonomy Engineer

Regent craft

North Kingstown, Rhode Island, United States (On-Site)
1 Month ago
Qualcomm - Sr Engineer - DFT

Qualcomm

Hyderabad, Telangana, India (On-Site)
2 Months ago
LTI Mindtree - Senior Specialist - Interactive SEM Consultant

LTI Mindtree

Tokyo, Japan (On-Site)
1 Month ago
Xplor Technologies - Senior Software Engineer - .Net

Xplor Technologies

Pune, Maharashtra, India (On-Site)
4 Months ago
Ion - Software Developer/Engineer - Graduate Development Program

Ion

Turin, Piedmont, Italy (On-Site)
9 Months ago
Ion - Senior Software Engineer - C

Ion

Uniondale, New York, United States (On-Site)
3 Months ago
Ion - Senior Java Developer - Italy

Ion

Rome, Lazio, Italy (On-Site)
9 Months ago
N-ix - Senior Java Engineer

N-ix

Ukraine (On-Site)
3 Weeks ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Drivetrain - SDE (Automation & Quality Focus)

Drivetrain

Kolkata, West Bengal, India (Remote)
11 Months ago
Easybrain - Product Manager

Easybrain

Limassol, Limassol, Cyprus (Hybrid)
9 Months ago
Veeam Software - Virtualization Backup Engineer

Veeam Software

Prague, Czechia (Remote)
2 Months ago
Capgemini - Change and Release Management

Capgemini

Mumbai, Maharashtra, India (On-Site)
1 Month ago
Stake logic - Compliance Officer

Stake logic

Eindhoven, North Brabant, Netherlands (On-Site)
1 Month ago
Nexters - Technical Lead

Nexters

Cyprus (Remote)
5 Months ago
Diligent Corporation - Marketing Campaign Manager

Diligent Corporation

Vancouver, British Columbia, Canada (Hybrid)
2 Weeks ago
GHX - Manager Software Development

GHX

Hyderabad, Telangana, India (On-Site)
2 Months ago
Ziff Davis - DevOps Engineer

Ziff Davis

New York, United States (On-Site)
3 Weeks ago
DWS Group - Data Scientist

DWS Group

Mumbai, Maharashtra, India (Hybrid)
8 Months ago

Get notifed when new similar jobs are uploaded

Jobs in Hyderabad, Telangana, India

Saviynt - Principal / Senior Principal Software Engineer - (Grails Server Page)

Saviynt

Bengaluru, Karnataka, India (Hybrid)
1 Month ago
velotio technologies  - Lead Fullstack Engineer

velotio technologies

Pune, Maharashtra, India (Remote)
1 Month ago
Nice - Specialist Software Engineer (Dot Net)

Nice

Pune, Maharashtra, India (Hybrid)
2 Weeks ago
zeta - Assistant Manager - Process Design

zeta

Bengaluru, Karnataka, India (On-Site)
2 Months ago
Xentrix studios - Production – Trainee

Xentrix studios

India (On-Site)
8 Months ago
Capgemini - Java Architect

Capgemini

Coimbatore, Tamil Nadu, India (On-Site)
2 Months ago
Flexera - Senior Site Reliability Engineer

Flexera

Bengaluru, Karnataka, India (Hybrid)
10 Months ago
oportun - Senior Data Engineer

oportun

India (Remote)
2 Months ago
Pulse Point - 2D Creative Artists

Pulse Point

Hyderabad, Telangana, India (On-Site)
1 Month ago
Autodesk - Senior Software Engineer (Full Stack - Java, AWS, AI/ML)

Autodesk

Bengaluru, Karnataka, India (On-Site)
1 Month ago

Get notifed when new similar jobs are uploaded

Programming Jobs

ISS Stoxx - Python Development Lead

ISS Stoxx

Mumbai, Maharashtra, India (On-Site)
1 Year ago
big red button - Senior Server Programmer

big red button

Los Angeles, California, United States (On-Site)
1 Month ago
Ion - Senior Python Developer

Ion

Budapest, Hungary (On-Site)
4 Years ago
Nexters - Lead .NET Developer

Nexters

Cyprus (Remote)
5 Months ago
Synechron - Bigdata ( Spark /Scala+ Python) developers

Synechron

Bengaluru, Karnataka, India (On-Site)
2 Months ago
binance - Senior Java Developer

binance

Taipei City, Taiwan (Remote)
10 Months ago
adglobal 360 - Java Engineer (Leader, Sub-leader Candidate)

adglobal 360

(Remote)
2 Months ago
Thales - Avionics Software Developer

Thales

Bengaluru, Karnataka, India (Hybrid)
10 Months ago
P99 soft - Lead Java Developer

P99 soft

Hyderabad, Telangana, India (On-Site)
2 Months ago
Ubisoft - Programming Team Lead (Engine)

Ubisoft

Saguenay, Quebec, Canada (Hybrid)
1 Year ago

Get notifed when new similar jobs are uploaded

About The Company

Hyderabad, Telangana, India (Hybrid)

Hyderabad, Telangana, India (Hybrid)

Hyderabad, Telangana, India (On-Site)

Gouda, South Holland, Netherlands (On-Site)

Bengaluru, Karnataka, India (On-Site)

London, England, United Kingdom (On-Site)

Hyderabad, Telangana, India (On-Site)

London, England, United Kingdom (On-Site)

View All Jobs

Get notified when new jobs are added by Insight Software

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug