Senior Consultant Technical (ETL Tool + SQL + Data migration)

2 Weeks ago • All levels

Job Summary

Job Description

The Senior Consultant will be responsible for integrating and mapping customer data from client source systems to the Insightsoftware platform. This includes performing extract, transform, load (ETL) activities, researching complex scenarios for innovative solutions, mapping business requirements to the solution design, presenting findings to stakeholders, and identifying data gaps. This role requires strong technical data migration, scripting, and organizational skills to ensure efficient and accurate data conversions. Additionally, the consultant will need to communicate with clients and project managers, continually drive improvements in the data migration process, and support customer SIT, UAT, and go-live phases. The work location is Hyderabad, India, and requires working in a night shift.
Must have:
  • Assess data and analytic requirements.
  • Experience with real-time, batch, and ETL for complex data conversions.
  • Working knowledge of ETL methodologies and tools.
  • Utilize data mapping tools for data loads.
  • Working experience using various data applications/systems like Oracle SQL, Excel.
  • Strong SQL scripting experience.
  • Communicate with clients and/or ISW Project Manager.
  • Effectively communicate with ISW Project Managers and customers.

Job Details

Company Description

Insightsoftware is a growing, dynamic software company that helps businesses achieve greater levels of financial intelligence across their organization with our world-class financial reporting solutions. At Insightsoftware, you will learn and grow in a fast-paced, supportive environment that will take your career to the next level. We are looking for future Insighters who can demonstrate teamwork, results orientation, a growth mindset, disciplined execution, and a winning attitude to join our growing team.

Job Description

Insightsoftware (ISW) is a growing, dynamic computer software company that helps businesses achieve greater levels of financial intelligence across their organization with our world-class financial reporting solutions.  At insightsoftware, you will learn and grow in a fast-paced, supportive environment that will take your career to the next level.  The Data Conversion Specialist is a member of the insightsoftware Project Management Office (PMO) who demonstrates teamwork, results orientation, a growth mindset, disciplined execution, and a winning attitude.

Location: Hyderabad (Work from Office)

Working Hours: 5:00 PM - 2:00AM IST or 6:00 PM to 3:00 AM IST, 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. **

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

Hike - Business Analyst

Hike

(Remote)
1 Month ago
King - Manager, Commercial Finance

King

London, England, United Kingdom (On-Site)
2 Weeks ago
N-iX - Senior QA (C#) Engineer

N-iX

Poland (Hybrid)
1 Week ago
GameJobs - Strategic Financial Analyst - Infrastructure

GameJobs

San Mateo, California, United States (On-Site)
1 Day ago
MIQ Digital - Data Engineer II

MIQ Digital

Bengaluru, Karnataka, India (Hybrid)
9 Hours ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Tencent - Game Strategy & Data Analyst Manager

Tencent

Shenzhen, Guangdong Province, China (On-Site)
2 Weeks ago
anydesk - Software Developer Generalist

anydesk

Stuttgart, Baden-Württemberg, Germany (On-Site)
7 Hours ago
Inkittt - Senior Product Manager, Retention & Renewals

Inkittt

San Francisco, California, United States (On-Site)
8 Months ago
Google - Technical Solutions Consultant

Google

Dublin, County Dublin, Ireland (On-Site)
2 Weeks ago
Tesla - Senior Software Engineer (Backend, .Net)

Tesla

Amsterdam, North Holland, Netherlands (On-Site)
2 Months ago
Airbyte - Technical Support Engineer

Airbyte

San Francisco, California, United States (On-Site)
1 Day ago
Rackspace Technology - Service Delivery/Engagement Manager

Rackspace Technology

Gurugram, Haryana, India (Remote)
3 Weeks ago
Shyft Labs - Manager Data Engineer

Shyft Labs

Noida, Uttar Pradesh, India (Hybrid)
1 Month ago
Airlab Inc  - Junior Programmer Artificial Intelligence

Airlab Inc

Quebec, Canada (On-Site)
1 Month ago
Universal Music - Director, Analytics

Universal Music

Santa Monica, California, United States (On-Site)
3 Weeks ago

Get notifed when new similar jobs are uploaded

Jobs in Hyderabad, Telangana, India

T systems - Java Web Developer

T systems

Bengaluru, Karnataka, India (On-Site)
1 Month ago
Level AI - FullStack Engineer - AI (Noida, India)

Level AI

Noida, Uttar Pradesh, India (Hybrid)
6 Months ago
PwC - IN_Associate – D365 Technical -Ms Dynamics– Advisory  - Gurgaon

PwC

Gurugram, Haryana, India (On-Site)
7 Months ago
spauldingridge - Anaplan Senior Associate

spauldingridge

Bengaluru, Karnataka, India (Hybrid)
20 Hours ago
Leapwork - Sr. Software Engineer

Leapwork

Gurugram, India (On-Site)
7 Hours ago
Enphase Energy - Associate, Sales Ops

Enphase Energy

Bengaluru, Karnataka, India (On-Site)
4 Months ago
Gigamon - Paralegal

Gigamon

Chennai, Tamil Nadu, India (Hybrid)
4 Months ago
OLIVER Agency - Senior Designer

OLIVER Agency

Mumbai, Maharashtra, India (On-Site)
23 Hours ago
Enphase Energy - Associate Manager/Manager - Web Projects (Design)

Enphase Energy

Bengaluru, Karnataka, India (On-Site)
4 Months ago
PwC - IN-Senior Associate_Azure data Engineer_Data &  Analytics_Advisory_PAN India

PwC

Bengaluru, Karnataka, India (On-Site)
7 Months ago

Get notifed when new similar jobs are uploaded

Similar Category Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

About The Company

insightsoftware is a global provider of Connected Solutions for the Office of the CFO. We believe an actionable business strategy begins and ends with accessible financial data. With solutions across financial planning and analysis (FP&A), accounting, and operations, we transform how teams operate, empowering leaders to make timely and informed decisions. With data at the heart of everything we do, insightsoftware enables automated processes, delivers trusted insights, boosts predictability, and increases productivity.



Hyderabad, Telangana, India (On-Site)

Hyderabad, Telangana, India (On-Site)

Bengaluru, Karnataka, India (On-Site)

Bengaluru, Karnataka, India (On-Site)

Bengaluru, Karnataka, India (On-Site)

Aachen, North Rhine-Westphalia, Germany (On-Site)

Hyderabad, Telangana, India (On-Site)

Bengaluru, Karnataka, India (On-Site)

Bengaluru, Karnataka, India (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