Informatica PowerCenter SQL Architect
Location New York USA Onsite
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 end-to-end Informatica PowerCenter solution you led in an on Prem environment source types staging design mappings workflows 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 |
