Informatica PowerCenter SQL Architect
Location New York USA Onsite
Contract
Must Have Skills
Informatica PowerCenter
I
SQL
Data Warehousing
Secondary Nice To Have Skills NOT MANDATORY
Qlik Replicate
Cloud Technologies Databricks OCl et
3 Qualifying Questions
1
Walk me through an endtoend Informatica PowerCenter solution you led in an onprem environmentsource types staging design mappingsworkflows error hanc deployment approach What were your key design decisions and why
2
Give a specific example where an ETL workflow had performance or latency issues How did you diagnose it session logs DB stats throughput bottlenecks what
apply partitioning pushdown optimization index strategy cache tuning commit intervals and what measurable improvement did you achieve
3
How have you implemented data quality and governance controls in PowerCenter reject handling reconciliation audit columns checksums control tables exce
describe your role in any PowerCenter migrationupgradewhat migration strategy testing approach and risk controls did you use”
Â
Â
|
Neha Chaudhary |
