Data Integration Lead

Data Management

Job ID-181239

148 Positions

Experience 6-9 Years

Saltillo, Coahuila, Mexico

Job Skills

SSIS-SQL Server Integ Services, Data Management, BI/BA

Job Description

Job Summary:

(Briefly describe the main objectives and purpose of the job. Why does the job exist?  What is it expected to accomplish?)


Level 3 Production Services Support for business critical global reporting applications which use BI Architecture.

Production Services responsibilities include assistance on application/batch monitoring, infrastructure support, installation and configuration expertise, operational housekeeping and maintenance and the code competency expertise to carry out Tier 3 incident resolution and problem analysis.

This role requires knowledge of SQL, SSIS/ETL, SSRS and needs an experience supporting applications, batch jobs, troubleshooting ETL/batch failures, incidents, user/performance issues. Coordination and collaboration skill to work with multiple teams like Infrastructure, DBA or Business is required.







Essential Functions of the Job:

(Identifyand describe essential functions, or primary duties and responsibilities.  Assume that the reader does not know the role or function of the job.)

1.       Should have excellent understanding of Microsoft Business Intelligence and reporting Architecture.

2.       Should have excellent understanding of MS SQL Server Architecture.

3.       Prior experience in end to end BI Implementation projects.

4.       Required to work  on late shifts.

5.       Production Support of Applications in MSBI (SSIS and SSRS)

6.       Analyze the job failure for cause and recommend technical resolution.

7.       Provide work-around solutions where possible to restore the service.

8.       Recommend solutions to application teams if code change is required.

9.       Ability to demonstrate strong analytical skills.

10.    Knowledge of ticketing tools such as Service Now. (desired)

11.    Manage and work on Incidents and resolutions.

12.    Liaise with customers and manage customers expectations on incidents.

13.    Define, document and implement processes and procedures for supporting production environment.

14.    Work with developers to implement the change & document it.

15.    Must be able to communicate effectively and work well within a team environment.

16.    Follow proper escalations procedures.

17.    Good understanding of ITIL concepts. (desired )

18.    Excellent communication and interpersonal skills.

19.    Excellent listening skills, self-starter, assertive, follows established procedures and the ability to meet deadlines.




Analytical/Decision Making Responsibilities:

(Describe the kind of problems and challenges typically faced, and decisions required to perform the job, as well as recommendations made to supervisors or others.  Focus on the nature of existing policies, precedents and procedures used to guide decisions, and the degree to which the incumbent is free to make decisions requiring interpretation and judgment. Provide an example.)

·         Excellent Techical/analytical skills needed for the problem/Issue resolution.


Knowledge and Skills Requirements:

(Describe the knowledge or skills needed to perform this job; these may be technical, managerial or behavioral in nature.)

·         Microsoft SQL 2012/2014/2016/2019 , Intergrations services ( SSIS ) , Reporting services (SSRS)

·         ETL tools

·         Transact SQL

·         IIS,

·         Azure implementation and monitoring for BI solutions (desired)

·         Experience developing ETL packages (desired)

·         Experience with batch scheduling applications such as Control-M (desired)





Supervision Responsibilities:

(Describe the level of supervision received (i.e., the frequency of supervisory contact, degree to which the individual acts independently and on what kinds of issues).  Describe the level of supervision of others, if any (i.e., assigning work, reviewing performance, direct or indirect responsibility).

·           NA



Other Requirements: Weekend Shifts /Late shifts

(Describe other functions or expectations of the job such as whether overtime is regularly required (e.g., during busy season?), whether there are particular times of the year that vacation may not be taken, whether there is frequent travel, whether there are any physical requirements beyond those expected in a normal office environment or any other miscellaneous things about the job that should be made known.)

·           Late shift Mon-Fri



Job Requirements:


(What is the minimum level of education needed/suggested to perform this job?)

·         Bachelor’s degree. Computer Science or IT related field (desired)



(What is minimum number of years needed/suggested to perform this job?)

·         Minimum 5 years of experience.

·         Relevant experience in a similar role will be much appreciated.  



Certification Requirements:

(Describe and explain any certifications and/or licenses needed or helpful to perform this job).

·          Knowledge of ITIL foundation/certification (desired)




This job description is intended as a guide to reflect the principal functions of the job.  However, it is not an all-inclusive listing of the required job functions and functions may vary depending on the particular geographic location of the job and/or the manager.  Further, the job description is subject to change at the discretion of management.

Submit Your Details

Please Enter Your Join By Date

Accepted file types: DOC, DOCX, PDF, TXT Max file size: 5MB

 The information you provide will be used in accordance with our terms of Privacy Policy

  Once applied, you will not be eligible to apply for any other position at Hexaware till your application is processed and acted upon. Please be aware      that we reserve the right to match your profile with other best-fit job requirements as per our discretion and best practices.

Our Employee Value Proposition

At Hexaware, you are encouraged to challenge yourself to achieve your potential and propel your growth.

We trust and empower you to disrupt the status quo and innovate for a better future. You will experience an open and inspiring culture that fosters learning and brings talented, passionate, and caring people together


The Great Place to Work® certification recognizes Hexaware’s commitment to building a High-Trust, High-Performance Culture™

Know More

Hexaware Wins the Brandon Hall Group Silver Award in the ‘Best Program for Upskilling Employees 2021’ Category

Know More