Lead Engineer-IICS Data Migration & Integration

Lead Engineer - IICS Data Migration & Integration

Noida / Bangalore Full-time 8+ years experience

About the role

You will lead the data migration and integration work end to end, using Informatica IICS, Google BigQuery and Salesforce ( Certinia PSA). You will work directly with client stakeholders, often with little direction and a lot of ambiguity, and you will own the outcome.

What youll do

• Lead legacy-to-new data migrations: source-to-target mapping, load sequencing, cutover and rollback.

• Build IICS mappings, mapplets, parameterized components and taskflows .

• Load Salesforce at scale using Bulk API 2.0, REST and SOAP.

• Use BigQuery as the staging layer; write advanced SQL for profiling, transformation and reconciliation.

• Uncover undocumented business logic in legacy data and validate it with business owners.

• Reconcile every load at row, field and business-total level, with sign-off evidence.

• Build in error handling, retries, reliability , alerting and logging; tune performance.

• Automate delivery with CI/CD, Python and Airflow where needed.

• Build Power BI reports for migration validation and business use.

• Run client conversations: weekly status, risks and decisions; mentor junior engineers.

What you bring (required)

• 8+ years in data engineering or integration, including 5+ years hands-on with Informatica IICS or PowerCenter.

• Salesforce integration experience: Bulk API 2.0, REST/SOAP, SOQL, API limits, record locking, external IDs.

• Advanced SQL in BigQuery , Oracle or SQL Server, plus PL/SQL.

• At least two end-to-end legacy-to-new application migrations delivered, one into Salesforce, at 100+ tables or objects.

• REST API integration: OAuth2, JSON/XML mapping, pagination, idempotency.

• Python scripting for automation and validation.

• Power BI report development.

• 3+ years in client-facing consulting or professional services, with strong written and spoken English.

Good to have

• Apache Airflow (Cloud Composer)

• Certinia PSA (FinancialForce) or another Salesforce-native PSA

• OpenAir or a similar PSA or time-and-billing source system

• Informatica, Salesforce or Google Cloud certifications

Who you are

• A self-starter who turns a vague ask into a written plan without waiting for a spec.

• Comfortable in ambiguity: you state assumptions, test them quickly and document decisions.

• A structured thinker who finds root causes, not just symptoms.

• Owner of the client relationship: you push back with evidence and raise risks early.

• Rigorous: you test your own work and review others.