Senior Specialist - Scottsdale, United States - LTIMindtree
Description
About Us:LTIMindtree
is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies.
As a digital transformation partner to more than 700+ clients, LTIMindtree brings extensive domain and technology expertise to help drive superior competitive differentiation, customer experiences, and business outcomes in a converging world.
Powered by nearly 90,000 talented and entrepreneurial professionals across more than 30 countries, LTIMindtree - a Larsen & Toubro Group company - combines the industry-acclaimed strengths of erstwhile Larsen and Toubro Infotech and Mindtree in solving the most complex business challenges and delivering transformation at scale.
For more information, please visitJob Title:
Senior Specialist - Data Engineering
Work Location
Location:
Scottsdale AZ
Job Description:
JD
10 years of experience in BI DW domain
Design and develop SQL Server stored procedures functions views and triggers to be used during the ETL process
Designing and developing SSIS SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing by QRM
Builds data transformations with SSIS including importing data from files moving data from one database platform to another
Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data
Design implement and maintain database objects tables views indexes and database security
Experience working with SSIS packages
Proficient with ETL tools such as Microsoft SSIS
Analyze and develop strategies and approaches to import and transfer data between source staging and ODS Data Warehouse destinations
Test and prepare ETL processes for deployment to production and non production environments
Support system and acceptance testing including the development or refinement of test plans
Benefits/perks listed below may vary depending on the nature of your employment with LTIMindtree ("LTIM"):
Benefits and Perks:
Comprehensive Medical Plan Covering Medical, Dental, VisionShort Term and Long-Term Disability Coverage401(k) Plan with Company matchLife InsuranceVacation Time, Sick Leave, Paid HolidaysPaid Paternity and Maternity Leave
The range displayed on each job posting reflects the minimum and maximum salary target for the position across all US locations.
Within the range, individual pay is determined by work location and job level and additional factors including job-related skills, experience, and relevant education or training.
Depending on the position offered, other forms of compensation may be provided as part of overall compensation like an annual performance-based bonus, sales incentive pay and other forms of bonus or variable compensation.
Disclaimer:The compensation and benefits information provided herein is accurate as of the date of this posting.
LTIMindtree
is an equal opportunity employer that is committed to diversity in the workplace.
Our employment decisions are made without regard to race, color, creed, religion, sex (including pregnancy, childbirth or related medical conditions), gender identity or expression, national origin, ancestry, age, family-care status, veteran status, marital status, civil union status, domestic partnership status, military service, handicap or disability or history of handicap or disability, genetic information, atypical hereditary cellular or blood trait, union affiliation, affectional or sexual orientation or preference, or any other characteristic protected by applicable federal, state, or local law, except where such considerations are bona fide occupational qualifications permitted by law.
Safe return to office:
In order to comply with LTIMindtree' s company COVID-19 vaccine mandate, candidates must be able to provide proof of full vaccination against COVID-19 before or by the date of hire.
Alternatively, one may submit a request for reasonable accommodation from LTIMindtree's COVID-19 vaccination mandate for approval, in accordance with applicable state and federal law, by the date of hire.
Any request is subject to review through LTIMindtree's applicable processesMin Salary:
$100,000 Per year
Max Salary:
$140,000 Per year
#J-18808-Ljbffr