Apply on Employer Site

LTIMindtree · 2 months ago

Senior Specialist - Data Engineering

Branchville - New Jersey - USA

Full-time

Onsite

Senior Level, Lead/Staff

8+ years exp

LTIMindtree is seeking a Senior Specialist in Data Engineering. The role involves leading Informatica IICS projects, focusing on ETL processes, data migration, and collaboration with cross-functional teams.

ConsultingEnterpriseInformation TechnologySoftware

H1B Sponsor Likely

Responsibilities

Lead Informatica IICS projects

Ensure adherence to testing best practices methodologies

Conduct design code reviews

Manage offshore team work and code reviews

Coordinate with client stakeholders

Estimate work efforts for requirements

Develop ETL pipelines from various data sources

Collaborate with cross-functional teams and stakeholders

Maintain strong communication skills with offshore teams

Qualification

Informatica IICSETL conceptsSQLData migrationXML JSONAnalytical skillsInsurance domain knowledgeAgile methodologiesCommunication skillsCollaboration skills

Required

8 - 12 Years of experience

Strong experience on ETL concepts

Experience on working with XML JSON file

Strong SQL fundamentals

Experience in data migration on cloud projects involving Informatica

Good analytical and logical skills in writing SQLs Stored Procedures and creating Marts Views in SQL server Oracle

A good end to end knowledge in ETL landscape starting from source system warehouse mart and reports

Very strong ETL Concepts and hands on experience on Informatica ETL Tool Basic Advanced

Strong written and oral communication skills

Strong ability to work with client stakeholders

Requirement Review and Work Effort Estimation

Ability to manage offshore team work and code review

Lead an onsite/offshore model team to ensure seamless collaboration

Strong collaboration skills with cross-functional teams and stakeholders supported by effective communication

Proven ability to coordinate seamlessly with offshore teams and manage deliverables across different time zones

Minimum 5 yrs of experience working on Informatica PC

Minimum 3 yrs experience on IDMC

Experience on on-prem to cloud migration project for Informatica for at least 1 project

Advance level knowledge on ETL concepts to develop ETL pipeline from multiple types of data sources like csv xml JSON relational database

Preferred

Understanding on ADF platform and framework

Familiar with Agile software development methodologies preferable JIRA

Experience on Azure Databricks Python for ETL

Insurance Domain Knowledge

Benefits

Comprehensive Medical Plan Covering Medical, Dental, Vision

Short Term and Long-Term Disability Coverage

401(k) Plan with Company match

Life Insurance

Vacation Time, Sick Leave, Paid Holidays

Paid Paternity and Maternity Leave

Company

LTIMindtree

Glassdoor3.6

LTIMindtree is a worldwide technology consulting and digital solutions company that empowers businesses in a variety of sectors.

Founded in 1996

Mumbai, Maharashtra, IND

10001+ employees

https://www.ltimindtree.com

H1B Sponsorship

LTIMindtree has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (2651)

2024 (2855)

2023 (2267)