A little 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 750 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 visit www.ltimindtree.com
Job Title : SSIS Lead (SSIS + AWS)
Job Location : Phoenix, AZ (Hybrid – Onsite)
Job Type : Full Time Employment
Salary Range : $125,000 – $140,000 Per Annum + Benefits
Technical Skills (Primary):
- Primary Technologies: SSIS, SSRS, SSAS
- Database Technologies: SQL, MS SQL Server, Relational Databases
- Experience on AWS Data Migration project
- Adherence to Testing Best Practices & Methodologies (Unit, End-To-End, Etc.)
- Adherence to Application Development Documentation Best Practices
- Experience in conducting Design & Code Reviews
- Experience of analysis and resolution of data quality and integration issues
Technical Skills (Secondary – Nice to have, NOT MANDATORY):
- Knowledge of Change Data Capture (CDC), Type 2 Dimension Data Model and Data Warehouse ETL techniques
- Experience in developing/supporting SCD1/SCD2/SCD3 Dimension Data models and data warehouse
- Experience on writing advanced SQL including some query tuning
- Knowledge on Python scripting
- Familiar with Agile software development methodologies. Ability to write stories and understand the business requirements
Soft Skills:
- As this is an onsite role, must have Excellent communication, interpersonal and listening skills.
- Insurance Domain Knowledge
- Strong ability to work with client stakeholders.
- Requirement Review and Work Effort Estimation
- Experience in providing and maintaining support documentation, STM / FSD / Design documents etc.
How will you grow:
- Role-based Training programs
- Continuing Education Programs (CEP) to enhance your knowledge, skills, and attitude as a professional
- We encourage you to acquire various beneficial international certifications, with costs s reimbursed
- Our role-based workshop helps us groom future leaders for LTI
What’s in it for you:
- Excellent benefits plan: medical, dental, vision, life, FSA, & PTO
- Roll over vacation days
- Commuter benefits
- Excellent growth and advancement opportunities
- Certification reimbursement
- Rewards and recognition programs
- Innovative and collaborative company culture
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.