Senior Specialist - Data Engineering

LTM; Jersey City (NJ); On-site; USD 110,000 - 190,000; Full time

Benefits offered by this job

Comprehensive Medical Plan

Disability Coverage

401(k) Plan with Company match

Life Insurance

Vacation Time, Sick Leave, Holidays

Paid Parental Leave

Job summary

LTIMindtree seeks an Informatica PowerCenter Migration Lead for onsite work in New Jersey near NYC. You will drive large-scale migration projects from legacy systems, leveraging PowerCenter, IICS, Snowflake, Databricks, and Azure Data Factory.

The role requires strong communication, client stakeholder management, and hands-on migration experience with ETL/ELT development and data warehousing knowledge. On-site role with leadership duties and AI-assisted engineering contributions.

Qualifications

• Hands-on experience as Informatica migration developer.
• Experience with large-scale migrations from legacy systems.
• Strong knowledge of ETL/ELT concepts and data warehousing fundamentals.
• Proficiency with Oracle SQL Server DB2 Teradata, and Snowflake.
• Familiarity with AI-assisted engineering tools is a plus.

Responsibilities

• Lead Informatica PowerCenter migration projects onsite.
• Coordinate with client stakeholders and engineering teams.
• Estimate work effort, manage risks, and drive project milestones.

Skills

Informatica PowerCenter

Informatica IICS

ETL Development

Data Warehousing

Oracle

SQL Server

Snowflake

Databricks

Azure Synapse

Azure Data Factory

IDQ

Data Modeling

Performance Tuning

Large-scale Migration

Tools

Informatica PowerCenter

Informatica IICS

Snowflake

Databricks

Azure Synapse

Azure Data Factory

Oracle

SQL Server

DB2

Teradata

Job description

Role Informatica PowerCenter Migration Lead Onsite NJ NYC USA

Experience 711 Years

Location USA New Jersey Eastern Time Zone 3 days WFO

Technical Skills Primary

• Informatica PowerCenter Informatica IICS Cloud Data Integration
• Experience in large scale migration from legacy systems
• ETLELT development Data Warehousing concepts Oracle SQL Server DB2 Teradata
• Snowflake Databricks Synapse Azure Data Factory ADF
• Informatica Data Quality IDQ Data Modeling
• Performance tuning and optimization

Secondary Nice to have NOT MANDATORY

• Team leadership and mentoring
• Stakeholder communication
• Project planning and estimation
• Risk and issue management
• Contribute to evolving best practices for AIassisted engineering

Soft Skills

As this is an onsite role must have strong written and oral communication skills

Insurance Domain Knowledge

Strong ability to work with client stakeholders

Requirement Review and Work Effort Estimation

Qualifying Questions

• Do you have handson experience as Informatica migration developer
• Have you worked with any AI tool such as Cursor Github Copilot in agentic mode
• Do you have Azure cloud experience and deployments

Other Details

Actual compensation within the range will be dependent upon the individual's skills, experience, performance and internal equity.

Benefits And Perks

• 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

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.

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.